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.
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