|Temp Tables? [message #1783019]
||Tue, 06 March 2018 16:12
| Jeff Stouse
Registered: March 2018
Thanks in advance!|
I have to create a report where I need to group matters, but sort them by the matter that has the oldest service date. Now I can create a Temp Table that has the matters, with the corresponding oldest service date, and sort them by the oldest date, but I need to add that Oldest date back into the original table because it contains thirty or so other fields I need to display in the report.
So, I created an "oldest_Date" table which contains the matter ID (keyfield) and the oldest service date - just two fields.
I then created a "Temp_ABCData" table and altered the table to include a "Max_DOS" field and inserted the Oldest date from the "Oldest_Date" table's Oldest service date field into the "MAX_DOS" field. This table has the other fields necessary to complete the report.
No errors when I run it in SSMS, but when I run it in the BIRT query preview window I get the error: SQL Statement does not return a ResultSet: Cannot find the object "Temp_ABCData" because it does not exist or you do not have permissions."
So, can I use Temp tables? If so, what am I doing wrong. If I can't then what?
Again, thanks for any help - first time trying to use Temp tables - and in BIRT.
Powered by FUDForum
. Page generated in 0.01629 seconds