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 |
|
ironmonkey
Starting Member
8 Posts |
 Posted - 2010-07-05 : 18:44:36
|
| I need a where clause that will handle the following conditionI have a variable say var1. It's value can range from 0-11. Ifvar1 = 0 then copy 0var1 = 1 then copy p3var1 = 2 then copy p3var1 = 3 then copy p3var1 = 4 then copy p3,p6var1 = 5 then copy p3,p6var1 = 6 then copy p3,p6var1 = 7 then copy p3,p4,p9var1 = 8 then copy p3,p4,p9var1 = 9 then copy p3,p4,p9var1 = 10 then copy p3,p4,p9,12var1 = 11 then copy p3,p4,p9,12var1 = 12 then copy p3,p4,p9,12Any ideas how to start this? |
|
|
sql-programmers
Posting Yak Master
190 Posts |
Posted - 2010-07-05 : 23:38:07
|
| I don't what you mean by copy.Anyway try this script,CASE WHEN @var1 = 0 THEN 'copy 0' WHEN @var1 >= 1 AND @var1 <= 3 THEN 'copy p3' WHEN @var1 >= 4 AND @var1 <= 6 THEN 'copy p3,p6' WHEN @var1 >= 7 AND @var1 <= 9 THEN 'copy p3,p4,p9' WHEN @var1 >= 10 AND @var1 <=12 THEN 'copy p3,p4,p9,12'ENDSQL Server Programmers and Consultantshttp://www.sql-programmers.com/ |
 |
|
|
|
|
|
|
|
Help writing a query