Redirecting Output
-
Comments posted to this topic are about the item Redirecting Output
-
This was removed by the editor as SPAM
-
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".
-
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
-
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...
-
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
-
Amazing! That's the same combination I have on my luggage!
-
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 -
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 -
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.
-
Not everyone. Some of us stick to easy to remember things like 1,1,1
Tom
-
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.
-
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.
-
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