Viewing 4 posts - 1 through 4 (of 4 total)
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...
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...
August 8, 2013 at 7:45 am
For the basics ....
August 8, 2013 at 6:45 am
Viewing 4 posts - 1 through 4 (of 4 total)