Post reply

How to delete all rows but noon's on Friday?

  • December 2, 2011 at 11:23 am

    #263932

    Hello -

    I need help in creating a store procedure that will clean out a table that has been having data inserted into it all day every 2 hours. The one thing is I need is to keep Friday's Noon run for archival purposes.

    In this table is a point in time column I can referance that shows the current date and time the SSIS package ran to pull in the data into the table.

    I've looked and tried many scipts but cannot get anything to work. Can someone help me out?

    Thanks

    David

  • December 2, 2011 at 11:41 am

    #1416129

    To assist others in assisting you please post the table definition, some sample data. You can do this quickly and easily by clicking on the first link of my signature block, and following the articles instructions, and using it sample T-SQL

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • December 2, 2011 at 12:01 pm

    #1416144

    Will do the next time I post. I found my answer. Thanks...

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply