We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
My goal is to have a script that will select the location code counts from tblMainHistory and dump them into a column along with the date in RecordDate. The result would look like this:
SELECT ISNULL(h.DESCRIPTION, 'UNASSIGNED') AS Description, COUNT(DISTINCT v.RECORDIDNUMBER) RecordCount FROM tblMainHistory v, tblLocationCode h WHERE h.LOCATIONCODE =* v.LOCATION AND RecordDate='2011-5-3' GROUP BY ISNULL(h.DESCRIPTION, 'UNASSIGNED')