No, a column of data type rowversion.

Thank so much, peacesells

Wonderful solution 😀

Yes, there was other stuff at the end of th CREATE proc...

Thanks!

As you can see, this is a quick fix, stop gap bit of script. It's just something to patch us through until we do it right.

I've got a little mystery...

I found the solution here:

http://www.sqlteam.com/article/using-the-output-clause-to-capture-identity-values-on-multi-row-inserts

Mark: My client's Sql Server is pre-2008, so MERGE is not available. It would be a good solution.

Thanks!

Thanks Lowell. OUTPUT will help.

That's it. I was testing for different projects. I must have assumed....

Put me in the corner with the dummy hat on.

Thanks!!!

Got it:

WHERE

(Projects.ProjectID = @ProjectID)

AND ((dbo.Firms.ChildSpecsAsSubreports = 1) AND (dbo.Components.ParentField IS NULL) OR(dbo.Firms.ChildSpecsAsSubreports = 0))