It has nothing to do with the sendmail proc at all.

You can't assign the result of an EXEC to a variable like that.

One way would be to rewrite dbo.usp.AuditTrail_rpt to...

Instead of trying to describe the issue you're struggling with just verbally, it would be more helpful if you could post some sample data so we have something to test...

The second approach would require to replace the DELETE functionality with a solution that would add a DELETE flag. Otherwise you wouldn't have a row to add the modified* information...

Still not enough information.

Did you use vb.Net to develop a Web-Frontend or is it a client based solution?

What online functionality will you provide (full functionality or just part of it)?

Do...

Taking aside the fact that there isn't even a DROP TABLE statement in the code you referenced as well as the nested c.u.r.s.o.r. *cough* in there, the reason for the...

maybe this link will help you to figure it out...

Why don't you just use a conditional split with a left outer join to the table holding the primary key. Check for NOT NULL of the PK value and perform...

There's very little information so far...

Where's the table holding the primary key you want to reference again?

Is it in the source or the target database?

What does the process look like?...

To store date and time information in a table, I would recommend the DATETIME2 data type.

It's not very clear why you would store the date parts separately. There are scenarios,...

Your question is "Need query for problem".

Would you mind sharing the logic you came up with to solve the problem? We might be able to help you "translate" it into...

There can be tons of reasons...

Without seeing the code together with the actual execution plan of the code section in question for both cases (fast and slow) it'll be just...

If you have trouble getting the PIVOT syntax right, you might want to try the "classic" rossTab approach. alternatively.

If the max. number of items is known (e.g. 3 based on...

Something like this?

SELECT [one column] FROM table ORDER BY [one column]

What is your question?

As per BOL the index will simply being ignored if the options are set incorrectly.

The connection on which the index is created, and all connections trying INSERT, UPDATE, or DELETE...