How to have multiple select statements in CASE

Question

How to have multiple select statements in CASE

MVIT

Right there with Babe

Points: 748
More actions
January 29, 2014 at 1:23 am

#396182

eg.
CASE Type
WHEN 1 THEN Select * from table1
WHEN 2 THEN Select * from Table 2
ELSE Select * from Table 3
END
Am finding difficulty to write the Select statements.Please help me !

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 1

Can you show the context in which this would be used?

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

MVIT Right there with Babe Points: 748 More actions · Answer 2

Based on the Type I need to query different tables to get the data.

I hope this helps!

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 3

Not really. CASE is used within a query. Can you post the whole query within which you want to use the CASE construct?

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

MVIT Right there with Babe Points: 748 More actions · Answer 4

So as per your comments, I need to use multiple If's.... But if there are more than 100 types , then having 100 if's would not be good practice ?

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 5

sabeer.mvit (1/29/2014)
So as per your comments, I need to use multiple If's.... But if there are more than 100 types , then having 100 if's would not be good practice ?
Regards,
Sabeer

No, I've said nothing about IF. Post the whole query in which you want to use your CASE.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

MVIT Right there with Babe Points: 748 More actions · Answer 6

The sample query that I have mentioned in my post is the similar to what I need to write.

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 7

Where does the column [Type] come from?

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

Farlzy Mr or Mrs. 500 Points: 561 More actions · Answer 8

Surely the only way you'd achieve this is with dynamic sql, which would be an absolute pig to maintain. Could you combine the various table you want to query into a single view, exposing the type too, then join on to the view?

Sean Lange SSC Guru Points: 286590 More actions · Answer 9

Farlzy (1/29/2014)
Surely the only way you'd achieve this is with dynamic sql, which would be an absolute pig to maintain.

That is a pretty bold statement to make when we don't really know what the OP is trying to do.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/