Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BUG: sp and conditional temp table
Message
 
 
To
23/05/2005 11:54:01
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
01016662
Message ID:
01016793
Views:
12
	SELECT * 
	INTO #TEMPTABLE
	FROM (SELECT 	1 x WHERE @choice=0
	UNION ALL
	SELECT 0 x WHERE @choice<>0) dt1
>Sergey,
>this have the same problems
>of others workarounds ( exec or conditional select ),
>plus the INSERT transaction log slowdown.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform