Stored Procedure and also a generated table holding the period end dates for each period.
Parameters into the SP would simply be the Year and Period. Dave C -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jarvis, Matthew Sent: 14 November 2011 23:23 To: [email protected] Subject: [NF] SQL code for moving date range I know I've seen or done this before but can't figger it out at this moment... I have a request from payroll dept to produce an overtime report by pulling from our timeclock system. The report I can do for a date range I enter into the SQL query, or I can do it for the current date easily. But her request is for a range that moves dates over time, like this: "The file will need to be generated for the current pay period 11/6/2011 - 11/19/2011 each time. When we roll to the next pay period, I will need 11/6/2011 - 11/19/2011 (previous) and 11/20/2011 - 12/3/2011 (current)" So based on it being the current date, how does one do this for something like these payroll periods? Thanks, Matthew Jarvis || Business Systems Analyst IT Department McKenzie-Willamette Medical Center 1460 G Street, Springfield, OR 97477 || Ph: 541-744-6092 || Fax: 541-744-6145 -------------------------------------------------------------------------- Disclaimer: This electronic message may contain information that is Proprietary, Confidential, or legally privileged or protected. It is intended only for the use of the individual(s) and entity named in the message. If you are not an intended recipient of this message, please notify the sender immediately and delete the material from your computer. Do not deliver, distribute or copy this message and do not disclose its contents or take any action in reliance on the information it contains. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
