Experts Exchange connects you with the people and services you need so you can get back to work.
At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.
create procedure #validate_pricechange_form @user varchar(100), @Date datetime, @Site varchar(100), @No_change int
declare @site_txt varchar(100)
set @site_txt= @site
select @site_txt = substring(@site_txt, 8, len(@site_txt))
select @site_txt = rtrim(@site_txt)
select @site_txt = ltrim(@site_txt)
declare @site2 char(4) collateion Latin1_General_CI_AI
select @site2=cast([site] as varchar) from master.location where naziv=@site_txt
declare @valid int
declare @error nvarchar(4000)
set @error = ''
if @site2 is NULL
select @site2 = substring(@site, 0, 5)
if @site2<>'1000' and @site2<>'2000' and @site2<>'3000' and @site2<>'4000'
set @error = @site2+' location doesnt exist.'
select @error as result
Open in new window
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.
Premium members get this course for $159.20.
Premium members get this course for $151.20.
Premium members get this course for $299.99.
Premium members get this course for $12.50.
Premium members get this course for $174.99.