Temp Table in SSRS Dataset

  • Good Morning/Evening Guys,

    is it possible to use a temp table inside a Text SQL Query inside the SSRS report to be used as a dataset? my client's requirements are to not use a stored procedure to generate the dataset in the SSRS Dataset query. I just want to know if this is possible or supported under the SSRS Dataset compiler

    Best Regards,

    Noel Isip

  • Yes you can. I'd much rather use stored procedures though.

  • Much Thanks Sir!

  • Please, Can you explain? How used the Temp table in SSRS?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply