06-17-2015 07:51 AM
Does anyone have a SQL Query that will return the results of each day's search. Name, Dept, Hits.Sampled, Duplicates?
Thanks!!
Solved! Go to Solution.
07-14-2015 05:42 AM
Hi Scott,
Please run following SQL query against CA Customer Database in SQL.
Select tis.Name,tc.Name AS 'Dept',tis.NumHits AS 'Hits',tis.SampleSize As '% sample', tis.NumDuplicates AS 'Duplicates',tis.RunDate,tis.Type
From tblIntSearches tis
Inner Join tblCase AS tc
ON tis.CaseID=tc.CaseID
Note : TYPEs
110 |
Immediate |
111 |
Application Standard |
112 |
Schedule |
113 |
Schedule run |
07-14-2015 05:42 AM
Hi Scott,
Please run following SQL query against CA Customer Database in SQL.
Select tis.Name,tc.Name AS 'Dept',tis.NumHits AS 'Hits',tis.SampleSize As '% sample', tis.NumDuplicates AS 'Duplicates',tis.RunDate,tis.Type
From tblIntSearches tis
Inner Join tblCase AS tc
ON tis.CaseID=tc.CaseID
Note : TYPEs
110 |
Immediate |
111 |
Application Standard |
112 |
Schedule |
113 |
Schedule run |