I get this error when I run the query. (Must declare the table variable "@WorkOrder".)

I am working in Ignition. I do not have access to create statements or sample records.

Here is what I come up but I removed some of the joins until I...

• This reply was modified 5 years ago by Tech.

I get this error when I run the code. SQLServerException: Invalid column name 'ShiftStartDT'.

well, that is way over my head. I have a lot to learn. I understand the Joins and the Alias but is there a way to do it with out...

sorry if I wasn't clear.  I am looking for the data for Day Shift Total and Night Shift Total for each day of the previous week.