CODEWITHSUNDEEP
sqlsql-servert-sql
user1216456
user1216456

Reputation:

presenting repeating column values as blanks in query results except for the very first row in t-sql

I edited my question:

I get an Invalid object name '#Temp1'. The code below runs in a cursor loop...

Code:

IF OBJECT_ID('tempdb..#Temp1') IS NOT NULL
                BEGIN
                    DROP TABLE #Temp1
                END

                    Insert Into #Temp1 
                    Select o.EventSetName,
                           o.EventSetDisplay,
                           o.EventSetDescription,
                           o.ChildSetName,
                           ROW_NUMBER() Over (Order By o.ChildSetName) RN                  
                    From   ##ObsSetLevel o,
                           ##Final f
                    Where  f.ChildSetName = o.EventSetName and 
                           o.EventSetName = @ObsSetList 
                    Order By o.ChildSetName asc  

                    Insert into ##Final
                    Select *
                    From #Temp1
                    Where  RN = 1
                    Union
                    Select '', '', '', ChildSetName, RN
                    From #Temp1
                    Where RN > 1

Upvotes: 0

Views: 123

Answers (1)

Hart CO
Hart CO

Reputation: 34784

Remove the 't' from:

Into #Temp  t

So:

INTO #Temp

An alias is not allowed with INTO

I'd also recommend abandoning deprecated implicit joins:

SELECT  o.EventSetName,
        o.EventSetDisplay,
        o.EventSetDescription,
        o.ChildSetName,
        ROW_NUMBER() Over (Order By o.ChildSetName) RN
INTO #Temp 
FROM    ##ObsSetLevel o
JOIN    ##Final f
    ON  f.ChildSetName = o.EventSetName 
        AND o.EventSetName = @ObsSetList 
ORDER By o.ChildSetName asc

Upvotes: 2

Related Questions