I am sorry... yes it did work.. I just went back to my Dataset and my columns were there.. I must have been blind.. once adding them to my report...

Hi, I thought for other readers, that might need to know if this worked.. No, it did not.. when I put the stored procedure into SSRS, SSRS does not recognize...

Please bear with me just a little longer..  I have put all my code into one stored procedure and it creates the temp table with all my wonderful data as...

I am sorry for the confusion..the above query has an "Insert into "tempTableName" then a statements executes the first query.
Then  there is another "Insert into "tempTableName" then there is...

If OBJECT_ID('#cgILSUTA') IS NOT NULL drop table #cgILSUTA
create Table #cgILSUTA (VendorType varchar(1), FName text, LName text, SSN nvarchar(20), Wages nvarchar(20))

-- This is...

Select         
         z.VType         as [VType]
        ,z.FName         as [FName]
        ,z.LName         as [LName]
        ,z.Social_Security_Number    as [SSN]
        ,z.Wage          as [Wages]
     From (select
         m.state          as [VendorState]
        ,CONVERT(VARCHAR(2), GETDATE(), 2) as...

I noticed when I posted the formatting went away.. I attached a file.

I am sorry, I have tried lining the code up better.  The first query has one record.. I am currently getting the first query to not give me as many...

this is the second part of the query.. I need these both stuck together to get one report.
the first query creates one record.. this query will create a larger...

I assumed that I could put the same query I have in SSMS in SSRS.  I did change some of the data.
This is to create the table and to...

Good Morning,  I am trying to enter my query into SSRS.  It doesn't think anything I put in the query window is valid.. .lol.
Is there a document somewhere or...

Thank you.