Alrighty, I have a bit of a brain scratcher for you guys.
Code:
SELECT dumppt, sum(mass) FROM production
where (date >=@startdate) and (date <= @enddate) group by dumppt
I have that query. I need to be able to translate the first dumppt part to another value from a translation table, within the query, as it is getting dumped to another procedure from the reader variable that it is being read into.
Linear Mode
