Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rwasim25
Starting Member
13 Posts |
 Posted - 2010-08-30 : 03:21:09
|
| Hi Experts.. I have to include the query result for the below mention rule in my code:If CCIETEC = '74' in CNV_Policy_Version then default to 'N/A'If CCIETEC in( '70','85') in CNV_Policy_Version (i.e for Belgium policies) then use below.select nave from simm_tbyvers.Please let me know how can I include the syntax for it.FYI The result of above query needs to be capture in the field name "Endorsement_Number".Wasim..Senior Test Engineer |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-08-30 : 03:23:35
|
Is CNV_Policy_Version the table name?Do you need the condition in select list and also in where clause?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
rwasim25
Starting Member
13 Posts |
Posted - 2010-08-30 : 04:09:06
|
| Yes CNV_Policy_Version is the table name and simm_tbyvers is also another table where the second If condition result will get. Yes i want the condition in select list (this needs to be get into the field name "Endorsement_Number". It is only one of the fields alongwith many other in the query result).Wasim..Senior Test Engineer |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-30 : 09:58:56
|
| how do you think you can store a list of values in variable? I guess what you need is a table variable unless you want to store values as csv list or something------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Problem in implementation of IF statement