Re: Help with Query
> Is there a way to show data based on if dates are consecutive. Im try
> to show only the people who have consecutive Vac days out of a list of
> 20,000 records.
At first I thought you could get the max and min dates and count grouped
on employeeID and save to a query. Then Select those where
maxday-minday+1 = countofdays. But that wouldn't work because the date
range might be so large...maybe data over 2 weeks...there'd be gaps
because of weekends.
The best thing to do would be to write a function with your rules and
call the function within the query.
|Thread||Thread Starter||Forum||Replies||Last Post|
|Re: How to incorporate/assign variables within SQL query?||Howard Schreier||Newsgroup comp.soft-sys.sas||0||04-25-2008 03:04 AM|
|Re: How to incorporate/assign variables within SQL query?||Irin later||Newsgroup comp.soft-sys.sas||0||04-24-2008 07:32 PM|
|Re: How to incorporate/assign variables within SQL query?||Sigurd Hermansen||Newsgroup comp.soft-sys.sas||0||04-24-2008 03:46 PM|