Preparing a report on a SQL Server database
I have a SQL Server database of customers that called our company, and now i want to prepare a report that indicates which ones are new to our database. How would I do this?
Software/Hardware used:
Software/Hardware used:
ASKED:
March 3, 2009 7:52 PM
UPDATED:
March 4, 2009 8:34 AM
Answer Wiki:
i think in your table lets call it CustomerCalls there is the below fields:
CustomerName
CustomerNumber
DateOfCall
and lets say new clients for your company are clients who started calling from Jan 2009
the query will be:
select * from CustomerCalls
where DateofCall>'01-01-2009 00:00:00.000'
and CustomerNumber not in
(select CustomerNumber from CustomerCalls where DateofCall<'01-01-2009 00:00:00.000')
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
