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.
Ali.M.Habib Yak Posting Veteran
54 Posts
insert into S -- table name(A,B,c)select(x,y,case xwhen x in (1,2) then 'HI'else 'NO'from D)
webfred Master Smack Fu Yak Hacker
8781 Posts
khtan In (Som, Ni, Yak)
17689 Posts
quote:Originally posted by khtancasewhen x in (1,2) then 'HI'else 'NO'endKH[spoiler]Time is always against us[/spoiler]
casewhen x in (1,2) then 'HI'else 'NO'end
SQLTeam.com Articles via RSS
SQLTeam.com Weblog via RSS
- Advertisement -
Articles
Forums
Blogs
Contact Us
About the Site