data roll
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: data roll

  1. #1
    Join Date
    Mar 2004
    Location
    MSN
    Posts
    1

    data roll

    My question is this:

    I have a table which looks like this below:

    week1 week2 week3 week4 .... week 78

    I want to roll week1 data to week2, week2 to week3....etc..

    What is the best method to use for both data integrity and performance?
    ie) 1. rename week1 to week2 etc week 78 would be deleted
    2. bulk update method?

    Any insight would be greatly appreciated..

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Here's some input:
    1. post your question in the right forum.
    2. Give more specifics so we can actually help you.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width