August 27, 2015 at 10:48 pm
Comments posted to this topic are about the item Redirecting Output
August 27, 2015 at 11:31 pm
This was removed by the editor as SPAM
August 28, 2015 at 2:06 am
Nice to see a "real world" question on here. At the moment roughly 25% of respondents have gone for the answer which would make any US record with a missing state go straight to "Foreign Sales".
August 28, 2015 at 6:23 am
Easy question, though I did have to think about it, as other combinations not provided as QotD options would have worked: 1, 3, 2 for example. Strip out foreign countries, dump to manual queue if state is a mismatch, send the remainder to the state-match destination.
Rich
August 28, 2015 at 6:29 am
rmechaber (8/28/2015)
Easy question, though I did have to think about it, as other combinations not provided as QotD options would have worked: 1, 3, 2 for example. Strip out foreign countries, dump to manual queue if state is a mismatch, send the remainder to the state-match destination.Rich
1, 3, 2 was the answer I was looking for. But since it was not an option, I went with the sub-optimal 1, 2 ,3... 😎
August 28, 2015 at 6:38 am
Xavon (8/28/2015)
rmechaber (8/28/2015)
Easy question, though I did have to think about it, as other combinations not provided as QotD options would have worked: 1, 3, 2 for example. Strip out foreign countries, dump to manual queue if state is a mismatch, send the remainder to the state-match destination.Rich
1, 3, 2 was the answer I was looking for. But since it was not an option, I went with the sub-optimal 1, 2 ,3... 😎
Why do you say "sub-optimal" as opposed to "alternative", Xavon? In general, when I am writing CASE statements (which the conditional split essentially is), I write them logically so as to handle matches first (from general to specific) and leave all mismatches for the ELSE.
Rich
August 28, 2015 at 7:15 am
Amazing! That's the same combination I have on my luggage! 😀
August 28, 2015 at 8:53 am
Nice question.
Actually 1-2 would be enough. You can send the error rows to the default output.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 28, 2015 at 2:28 pm
sknox (8/28/2015)
Amazing! That's the same combination I have on my luggage! 😀
Wait, you have that combo too?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 28, 2015 at 4:47 pm
SQLRNNR (8/28/2015)
sknox (8/28/2015)
Amazing! That's the same combination I have on my luggage! 😀Wait, you have that combo too?
I think everyone has had that combination at one time or another.
August 30, 2015 at 9:03 am
Not everyone. Some of us stick to easy to remember things like 1,1,1
Tom
August 31, 2015 at 2:38 pm
I assumed that all records with a valid US State also had USA for the country. If they don't then we could be putting valid US States into the foreign table.
September 6, 2015 at 4:55 am
I am far to be a specialist of SSIS which I am using and studying rarely but I tried only to think in a logical way. I was surprised to have given the good answer
Anyway a good and useful question so thanks.
September 8, 2015 at 7:36 am
It's much better to make the combination harder by doubling the numbers. 2,4,6 is much better, don't you think? 😀
Nice easy question, Steve, thanks.
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply