On Mon, Nov 14, 2011 at 5:23 PM, Jarvis, Matthew <[email protected]> wrote: > 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: ----------------------------
Make a Stored Procedure with one or two input params. Starting date and or Starting and ending date. > > > "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/cajidmykxuu5trkgca2sahhxrrehvk4p3hbhcjdypdigfkma...@mail.gmail.com ** 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.
