Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BUG: sp and conditional temp table
Message
From
23/05/2005 17:21:54
 
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
01016662
Message ID:
01016903
Views:
9
>Fabio,
>
>>Often the things that are not understood appear ridicules.
>
>*L* I understand.
>
>If you are conditionally writing different structured cursors, the whole rest of the SP has to be littered with so much conditional code that I'm really glad I'm not following behind you trying to maintain the unmaintainable code.

Of course, the structure of the cursor is the same!
It is the COMPLEX source that it is contidional.

Example: the Select's source
can to have 33 different outlines of this combination :
77 tables join with 222 subqueries and a where with 1111 lines with grouping and having....

Of course i can write all the workarounds, but this is not the point,
the point is the MS SQL bug.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform