Post reply

Table Update Query -- Need Help!

  • April 21, 2008 at 7:58 am

    #804988

    The 😉 (wink) should just be a close paren )

  • April 21, 2008 at 9:37 am

    #805052

    hey that worked... thanks so much for your help....

    let me ask one more question if that is ok....

    same scenario, but say the lower levels have a description but the upper levels do not, is there a way to populate the upper levels based on the lower ones?

    11315

    11315.001

    11315.001.002 Description

    or

    11315

    11315.001 Description

    11315.001.002

    Just wondering....

    Thanks again for your help!!!

  • April 21, 2008 at 10:52 am

    #805100

    Yes, there is, but I think that would be a good exercise for you to work on using the test code I initially provided along with the change for using SQL Server 2000 (i.e. you have to eliminate the CTE and use a derived table in the update).

    If you run into problems, open a new thread in a SQL Server 2000 forum, show what you have done, and where you are having a problem. This is the one of the best ways to learn.

    😎

  • April 21, 2008 at 11:00 am

    #805104

    gotcha... thanks for your help!!!

Viewing 4 posts - 16 through 18 (of 18 total)

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