Thanks! ntile works nicely.

Thanks to everyone, especially Matt, Grant and Jeremy.

The OUTPUT works.

Thanks,

But when I coded OUTPUT INSERTED.KEYID,

...

The child table has a foreign key ( which is the KeyID system generated on T1).

The KeyID will get populated only after the first mass insert is completed and cannot...

We have not gone live yet. Still in the setup phase this week. We will find out if there is any performance issues soon. Thanks

Thanks! That article is very useful.

Thank you both, Gail and Antonio. Works fine.

More information on my query:

Tab1: I query by account. An Account has an average of 1000 POs.

Tab2: Company inventory POs ( about 2 millions POs)

I am doing...

Thank you so much for the help. That works!

Thanks, Steve. I will give it a try.

Thank you, Gail. Works like a charm.

Hi Steve,

Does you query often use the audit_output in the result set? Yes

These are the queries(from most frequent to least frequent):

1. Administrators sit at their computers, run the...

Thank you both for the suggestions.

As for queries, they are based either on server or both parms - by customer name and server.

I am a novice and have a minimal...

Thank you, anteres686. That is cool. So far it works.

I found the answer

SET @sql = .... ' + CAST(@Status AS VARCHAR(10))

Thanks