June 4, 2013 at 6:10 am
My below query is giving error while writing in query editor [ SSIS].
declare @janflag as varchar(56)
set @janflag ='y'
declare @febflag as varchar(56)
set @febflag ='y'/[ SELECT TOP 1 febfl FROM saupdate ]
* saupdate table in the control flow.
UPDATE sacustomer
SET salesamt1 = CASE WHEN (@janflag='y') THEN ? ELSE salesamt1 END ,
costamt1 = CASE WHEN (@janflag='y') THEN ? ELSE costamt1 END ,
qtysold1 = CASE WHEN (@janflag='y') THEN ? ELSE qtysold1 END ,
salesamt2 = CASE WHEN (@febflag ='y') THEN ? ELSE salesamt1 END ,
costamt2 = CASE WHEN (@febflag ='y') THEN ? ELSE costamt1 END ,
qtysold2 = CASE WHEN (@febflag ='y') THEN ? ELSE qtysold1 END
where cono=?
and yr=?
and divno= ?
and whse= ?
and custno= ?
Not sure about the declare code...
please check it and help me .
Thanks
June 6, 2013 at 6:30 am
Try this
declare @janflag as varchar(56)
declare @febflag as varchar(56)
BEGIN
set @janflag ='y'
set @febflag ='y' --[ SELECT TOP 1 febfl FROM saupdate ]
<<ALLL your udpate statements here>>
End
Vikash Kumar Singh || www.singhvikash.in
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy