April 25, 2018 at 7:48 am
I wrote 10,000 lines of SQL (several temp tables) and i would like to move it to SSRS but i can't copy and paste that much code. Thoughts?
thanks
April 25, 2018 at 8:05 am
Use an SP. Putting the SQL directly in SSRS is rarely a good idea.
Also, however, I doubt that using several temporary tables is going to be the best (performing) solution.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 25, 2018 at 8:05 am
jeffshelix - Wednesday, April 25, 2018 7:48 AMI wrote 10,000 lines of SQL (several temp tables) and i would like to move it to SSRS but i can't copy and paste that much code. Thoughts?thanks
Convert it to a stored procedure and call the stored procedure from SSRS.
--Jeff Moden
Change is inevitable... Change for the better is not.
April 25, 2018 at 8:16 am
Thom A - i totally agree that my large temp table isnt good code, but i need Duty Rates from Customs and that table is 9500 rows long. My company doesnt have a Table that holds them . . . yet
THanks
Jeff
April 25, 2018 at 8:18 am
Put your code into a stored procedure, execute your SSRS report using a stored procedure.
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy