Viewing 4 posts - 1 through 5 (of 5 total)
Worked for me thanks!!
"To be 'The Man,' you gotta beat the man!" ~The Nature Boy
August 13, 2013 at 7:33 am
Sorry, after reviewing mickyT's code and results i realize the dates should be "contiguous" if i'm understanding correctly.(in which mickyT's does just that). Just wanted to post an update to...
"To be 'The Man,' you gotta beat the man!" ~The Nature Boy
August 11, 2013 at 8:15 am
I think this may work as well...not 100%
UPDATE target_table
SET to_Date = (T2.from_date-1)
FROM target_table T1
LEFT JOIN source_table T2 ON T1.Uarn = T2.Uarn
WHERE t1.to_Date IS NULL
INSERT target_table
SELECT DISTINCT...
"To be 'The Man,' you gotta beat the man!" ~The Nature Boy
August 8, 2013 at 7:45 am
For the basics ....
"To be 'The Man,' you gotta beat the man!" ~The Nature Boy
August 8, 2013 at 6:45 am
Viewing 4 posts - 1 through 5 (of 5 total)