joebickley
Programmer
Hi
I have a table with 10000 applications in it each application is made by a person with an ID. I need to be able to find out how many of the people who made applications in the last 12 month period had never applied before.
Ive done this in MS access by making a qry for the old data and a query for this years data, joining them and counting the ones that dont match.
I want to do this in a Stored Proc alone if there is an easy way of doing this?
Thanks
joe
I have a table with 10000 applications in it each application is made by a person with an ID. I need to be able to find out how many of the people who made applications in the last 12 month period had never applied before.
Ive done this in MS access by making a qry for the old data and a query for this years data, joining them and counting the ones that dont match.
I want to do this in a Stored Proc alone if there is an easy way of doing this?
Thanks
joe