Why not build a "test run" parameter in that writes the @@ROWCOUNT to a table along with the SP name and then you can SELECT from there??

The answer is: It depends.  Based on the # of records, what is to be done with them, etc..  will determine #table or @table.

Generally, @table is for SMALL amounts of...

Try SET DATEFORMAT MDY at the beginning of your stored-procedure.  Also, what day is giving you problems?

I assume that these rows are in the middle.

Port 1433 is used by the DEFAULT instance of SQL and not the named instance.  Try checking the Dynamically determine port and try again.  You will not be able to...

Conversely, you could have 2 different SP's 1 for INSERT, 1 for UPDATE and inside of them write the appropriate data to the audit table.  This would eliminate the trigger...

Try RETURN @ERROR.  The RETURN statement will return any number that you associate with it.  I would also change the SELECT @ERROR to SET @ERROR.

You will then be able to...

I agree with Remi 100%.  We have had to "Tweak" several (ok, ok) ALL of the applications that one of our vendors has provided i.e. the application still looks the...

Remi is generally correct HOWEVER,

I would find a tall tower, and ......  contemplate life.  Whichever you decide don't get stressed out.  That will only make things worse.  Take it...

Have you tried

SELECT COUNT(O1.OrderID), COUNT(O2.ItemID)

FROM dbo.Orders O1

  LEFT JOIN dbo.OrderItems O2 ON O1.OrderID = O2.OrderID

Of course this will need to be tweaked but should give you a start...

If you create a stored-procedure that is owned by the same owner as the job and GRANT EXEC to the sp THEN the non-owner should be able to run the...

My #1 piece of advice I was given a long time ago....

DON'T BE NERVOUS.  Go in and do the best you can.  If you pass/fail and you did your best...

The error is telling you there is a problem with your data.  You are trying to insert Primary Key violations into the system which SQL is politely telling you it...

According to the article an MView: is A materialized view is a database object that contains the results of a query. They are local copies of data located remotely, or...

Personally (as usual) I prefer Remi's.  I like the look and it is LESS typing