Ok, so i did a smaller batch with @@rowcount and found that sql does indeed load to primary before scheme is kicked off. As such it behooves me and you...

Thanks Guys and Gals! Appreciate the help!

Thanks Gail, useful article!

Thanks Lynn, Ill try harder to use whitespace the next time I post.... You dont think using the @@rowcount is useful? Better to just do both statements?

Drew-

Thanks for the input. The table I am updating from is a daily updated temp table to a primary table of 23 billion records. So rather than using Merge I...

Thank you for the effort and trials...! The Temp Table is 23 Million but the Primary table is 23 billion which i why i thought the date scan would make...

Hmm, this seems to try and just create yet another temp table. I was trying to keep this inline transaction from my already existing update statement not adding more trips....

John-

Please bare with me, Im sure you have done this a million times. So I add the output inside the Update statement as below then I can query that in...

John -

So I tried the following in 2008 R2,

OUTPUT Updated.* INTO @UpdateCol and get syntax errors when used before or after the @@rowcount section. I was hoping to have it...

Yes, but I guess thats where I am not sure whats best. Output insert.* for values or output.insert.column? Its not overly clear in a transactional statement what would be best...

Thanks, I dont really want to post 15 files you guys need to review to get an answer. ill figure it out.

thanks Sean, I should have thought of that.

this works now.

Thanks Lynn, each query has different columns and widths. otherwise this would have worked,

Guys, after reviewing MSDN, SQL does not allow this type of usage inside a function. I appreciate your help.

Ok, well i cant give you all my code. If you wanted to create an Inline function and have separate queries returned based on an IF statement is the bottom...