Viewing 15 posts - 53,671 through 53,685 (of 59,068 total)
Double posting is so rude... waste time answering one only to find answer on the other.
http://www.sqlservercentral.com/Forums/Topic430841-5-1.aspx
http://www.sqlservercentral.com/Forums/Topic430840-146-1.aspx
December 8, 2007 at 10:10 am
But now I want to know the newly inserted row number
...and, if you're smart, you'll make the trigger code handle more than 1 row at a time. 😉
December 8, 2007 at 10:01 am
Two way street here, Jeff... how about posting your solution? Two reasons... like I said, "two way street" and the other is these types of problems typically lead to...
December 8, 2007 at 9:59 am
Double posting tends to tick folks off because they may spend some time of one of your posts trying to give you an answer only to find that a good...
December 8, 2007 at 9:56 am
December 8, 2007 at 9:42 am
Look in the Index of Books Online for "cross-tab reports"... good example there.
December 8, 2007 at 9:37 am
Ok, Ray... I've changed the code above... minor tweak... should do what you want now... give 'er a try on a test table like the one you posted...
December 8, 2007 at 9:00 am
I don't think there's any overhead with CI... it's a difference of only 1 bit (32) and only an internal difference of what the mask looks like.
I love CI because...
December 8, 2007 at 12:29 am
p.s. Code above assumes all "Amounts" are negative... may have to make a second pass for positive "Amounts".
December 8, 2007 at 12:23 am
Yes sure you can add columns. Is it for Cleaning the data ?
Yes... and for storing it, too. The following works on the data you provided for the tbExtract...
December 8, 2007 at 12:14 am
Yeah, I've seen that... but usually for smaller sets of rows.
December 7, 2007 at 10:56 pm
Copy only the data you need for the report from the linked server into a local table... then, do the reporting off that and drop the table when you are...
December 7, 2007 at 10:55 pm
Thank you, Jeff - from now on I will more-closely watch my use of inline queries.
Taking what Larry Taylor said a little bit further --
Jeff clearly states that...
December 7, 2007 at 7:36 pm
Viewing 15 posts - 53,671 through 53,685 (of 59,068 total)