Viewing 4 posts - 1 through 4 (of 4 total)
Beautiful! Thanks a bunch!
March 7, 2012 at 4:01 pm
Nevermind, I got by placing the above into an EXECUTE 😛
August 19, 2011 at 4:18 pm
Stewart can you give me a pointer how to include the above with INSERT INTO?
What seems logical is
; With SingleCampaign AS
....
UNION ALL
SELECT INTO T_AffiliateLeads (CaptureDate....)
(SELECT l.CaptureDate
...
Where l.LeadID IS NULL)
but...
August 19, 2011 at 12:24 pm
This is brilliant Stewart, more complicated than I can comprehend so I'm going to break it apart to try to learn what is going on. Thanks so much!
August 19, 2011 at 10:59 am
Viewing 4 posts - 1 through 4 (of 4 total)