The trigger will always fire, and will only fire, when an INSERT takes place. You will have to put logic within the trigger to test for the other conditions,...

Why not?

Did you have a copy of the execution plan from back before you ever started making changes?

Parameter sniffing refers to SQL generating an execution plan for a stored procedure based...

This will illustrate using OPENROWSET to read the contents of the XML file.

Obviously you could take the FROM OPENROWSET and use it to insert a row into a table, update...

The change in datatype shouldn't have made that much of a difference.

It is possible that your prior poor performance was due to "parameter sniffing". ...

Is the name of the file containing the XML going to be the same every time?

You da man, Steve.

Of course, I may not be able to derive to a point anymore....

Is it just me, or has his grammar improved?

Don't do it Lynn!!

Give no quarter!! Take no prisoners!!

Give them a broadside and see if they've got the stomach for combat!!

(Sorry... I've...

Nice going, Jordan! 😀

Have another cup of coffee and carry on. It's Monday and we all need all the help we can get.

You're welcome, Pakki.

Jeff, I decided if I kept on changing nicknames in addition to avatars I might give Steve a stroke. So out of consideration for his enlightened...

Can we have some sample data and can you tell us exactly what errors you are experiencing?

If you read this article and follow the suggestions it...

Sweet.

While we're on the subject, ISNUMERIC() doesn't even truly mean NUMERIC.

declare @testString varchar(10)

set @testString = '.'

select @testString as [@testString], isnumeric(@testString) as [IsNumeric]

set @testString = ',,'

select @testString as [@testString], isnumeric(@testString) as...

Edited to say:

Reply entered by mistake, but I can't delete this entry now.

Nothing to see here. Move along.... move along.