Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DO CASE equavalent in Transact-SQL
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01326640
Message ID:
01326732
Views:
19
>It is the same as:
>
>IF @Something1
>   BEGIN
>   -- Select 1
>   END
>ELSE
>   IF @Something2
>      BEGIN
>          -- Select 2
>      END
>   ELSE
>      IF @Something3
>         BEGIN
>         -- Select 3
>         END
>
>But is formatted that way it is hard to read, isn't it?

Right, I like your way better and implemented it this way.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform