Viewing 15 posts - 5,941 through 5,955 (of 13,874 total)
February 13, 2017 at 4:47 pm
Thanks very much to those who responded, I appreciate the help.
I've ended up with a somewhat more complex version of Luis' query, which performed the best on my data....
February 13, 2017 at 12:00 pm
I'd be looking to do all of this at source (for example, in T-SQL) rather than in SSIS, if possible.
But if it must do it all in SSIS,...
February 13, 2017 at 10:43 am
Yet another vote from me on implementing this as a FK.
February 13, 2017 at 10:37 am
Your parentheses did not match up.
SELECT
a.account_number
, CurrentBalance
, DateIdentified
, lastpaymentdate
, BlockCode01
, BlockCode02
, BlockCode1Date
, usercode01
, usercode02
, NORPC = CASE
WHEN
(
DATEDIFF(DD, MAX(b.EffectiveDate),...
February 13, 2017 at 8:03 am
February 13, 2017 at 7:25 am
February 13, 2017 at 6:11 am
I did find a workable solution. I fed the output from the OLE DB data...
February 10, 2017 at 11:01 am
mcfarlandparkway - Friday, February 10, 2017 8:46 AMWe are keeping remaining stuff in the same format so I don't want to change it.
The...
February 10, 2017 at 8:55 am
February 10, 2017 at 5:51 am
February 9, 2017 at 9:11 am
Can I get...
February 9, 2017 at 7:43 am
February 9, 2017 at 7:40 am
But my question is it loops 13 times..to...
February 9, 2017 at 5:48 am
I...
February 8, 2017 at 4:31 pm
Viewing 15 posts - 5,941 through 5,955 (of 13,874 total)