Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
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')
|Sharepoint 2016 - all-in-one-server vs. two servers||24||35|
|Getting error trying to connect to SQL Server using java||4||32|
|Create table dynamically while passing the table name||2||393|
|Grouping within groups: SQL||5||29|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
7 Experts available now in Live!