Viewing 15 posts - 136 through 150 (of 600 total)
KGJ-Dev (2/4/2015)
February 5, 2015 at 1:26 pm
I haven't used that transformation/wizard before but my understanding is it is generating OLE DB Commands transformations for updating older rows.
Try changing those into destinations into a staging table, which...
February 5, 2015 at 1:19 pm
What is the OR for anyway?
Doesn't the WHERE clause within your apply guarantee that the both of those values are the same, meaning that the conditions are always both true...
February 5, 2015 at 12:51 pm
What about having a view on details that calculates the additional fee?
That way none of the underlying rows are changing, all the updates can be called, and then you can...
February 5, 2015 at 12:26 pm
Basically you are making the rows into columns, each with the identifier of the original row, and one of the winning numbers.
There is an UNPIVOT sql statement, or you can...
February 5, 2015 at 11:07 am
You would probably unpivot the data in both tables so that you have a key for which set of numbers it belongs to, but each winning/drawn number is its own...
February 5, 2015 at 10:44 am
How long does the differential take when the indexes are on, say, the largest table?
February 5, 2015 at 10:37 am
sarath.tata (2/5/2015)
Thanks a lot!! I didn't expect you giving me complete code 🙂PS: Hope you took Aspirin!
With something like that sometimes its easier to provide in working code...
February 5, 2015 at 10:36 am
Pretty sure the below is right, logically, for what you are looking for.
Warning that if you need to use indexes on either of those keys it could be...
February 5, 2015 at 10:34 am
If any one of these keys is in the f.AttPhysKey field, I need the row, but only if any of the other specified keys is not in the f.SurgeonKey field....
February 5, 2015 at 10:06 am
KoldCoffee (2/4/2015)
Differentials a whole different story: the whole ETL from flat file to stage (SSIS) to final tables (upsert/merge) goes a lot faster -...
February 5, 2015 at 10:01 am
This is probably more complicated than you would like. It is possible to make destinations dynamic with expressions, but not really at the row level.
So you will first need...
February 5, 2015 at 7:45 am
cstg85 (2/4/2015)
The column names will not change, I will read that Stairways article and give it a shot, thank you for the link. I guess my first thought was to...
February 4, 2015 at 4:19 pm
We're kind of nesting a couple of common questions (dynamic pivots and concatenation) here.
Basically you do the concatenation first using STUFF and FOR XML PATH to get the concatenated value...
February 4, 2015 at 3:31 pm
Should I assume it still has to be dynamic? In other words, that could happen for any Type value and each should be handled the same way?
February 4, 2015 at 3:02 pm
Viewing 15 posts - 136 through 150 (of 600 total)