General information
Forum:
Microsoft SQL Server
If I do
SELECT *
INTO #TEST
FROM #ASTRA_BOOK_ALL
IF @@ROWCOUNT = 0
SELECT *
INTO #ASTRA_BOOK
FROM #ASTRA_BOOK_ONE
ELSE
SELECT *
INTO #ASTRA_BOOK
FROM #ASTRA_B00K_ALL
I have still declared #ASTRA_BOOK twice.
Thanks
Jim
>>I was trying to make a complex program simple.
>>I made a view that Selected just the records I needed from
>>the huge transaction table. This made the joins to the smaller tables go much faster.
>>This is a warehouse program
>>The program is accessed by people or other programs. Nothing may be passed other than the customer code, optional parameters are start and end date,
>>book (part number) and type of transaction (Scrap, move, etc.)
>>
>>So to make it simple I was selecting into #ASTRA_All the view and all of the joins.
>>
>>I would then test for 'ALL', null, '', or '20961'
>>in the @BOOK variable.
>>
>>if 'ALL', null, or '' I would select the entire #ASTRA_ALL into #ASTRA_BOOK
>>Or if a specific part number I would Select the rows with that part number into #ASTRA_BOOK. But of course you can not do that.
>>
>
>See @@ROWCOUNT in BOL
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only