• nfs_john (11/26/2012)


    Mr. Lange,

    Sorry for the delay I was pulled off to another fire before coming back to this project. As for this question and answer I don't see where to mark as an answer or give you credit but your post provided enough to jog my memory back into RDBM & TSQL world. I created my update tables and executed the joins. It all worked quite nicely.

    THANK YOU

    JB

    Glad that worked for you. Around here we don't have a mechanism for "Mark as Answer" or that type of thing. All threads remain open because there may be somebody else who comes along and has a different approach to the same issue that is better than the posted "answer". As far as credit...well you just gave it to me by your comment. Thanks for letting me know that worked and as always feel free to post here or start a new thread when you find yourself in need of help in the future.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/