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.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Case When querry

Author  Topic 

julius.delorino
Starting Member

29 Posts

Posted - 2012-06-05 : 09:34:44
Good day sir, may i ask for your assistance, is this possible
using case when function;

case when Var1 ='1' and Var2='30' then 1 else 0 end

how can you write in SQL 2008?

thank you for your help, more power guys!

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2012-06-05 : 09:49:01
That looks good.
Put it in place of a value and it shuold work.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -