Good question. I guessed 0 thinking it was SQL injection issue which would delete all the rows in the table.Learnt sth new.

The SERVERPROERTY function can give you some info on the server level:

For example can give you collation information to know the language info.

Hope this helps.

select SERVERPROPERTY ('Collation') as 'Collation'

I believe you meant to say...partition it by ProductName and delete all the records greater than rownum 1.

You probably missed to add the Partition By in the Over clause. Yes,...

I am assuming that there is an Identity Column in the tblVersion table 🙂

Forgot to past the script:

DELETE D FROM

(

SELECT ProductName, ROW_NUMBER()OVER(ORDER BY ProductName) AS RowNum

FROM dbo.T1

) as D

JOIN

(

SELECT ProductName, ROW_NUMBER()OVER(ORDER BY ProductName) AS RowNum

FROM T1

) as E

on D.ProductName = E.ProductName

AND...

You are right about the systax errors, it was happening as I had some empty characters in the query I attached. I am reattaching the script w/o the empty characters.

Also,...

Yes, it's an Index Covering issue. Having the following index should also suffice your query and will not have any key/bookmark lookup and just an index seek since columns KEY1...

Hi,

I tried it using cross join and that seems to be a better way to handle this.

Thanks

Hi All,

Any comments or suggetions of any other best practices to handle this would be very helpful.

Thanks

Matt,

I tried by putting the XML schema validation within a nested Try/Catch in the proc and now it's able to capture the LocalError passsed in.

Thanks for you feedback.

Hit Matt,

Thanks for you feedback.

Actually yes, I am already doing that in my Unit Test for the from as shown below, but still no luck

--Set the values for the Input...

Hi Jacob,

I am trying to Raise an error using RAISEERROR function in sql when the XML schema validation fails.

I am doing this inside a store proc. I am declaring the...

Thanks Jacob,

That works pretty well. Have used Cross Apply with XML and another table but within the same XML. This is pretty useful. Appreciate your feedback on this.

Hi Jacob,

Wondering if could give some feedback to my issue here.

With SQL Server 2008...

I have an XML document and created it's XSD schema using VSTF (Visual Studio) create schema tool.

I...

GSquared,

I don't have to update the existing Main XMl, generting a new one as a final XML fine as well.

I am not understanding the following statement of yours.

"It would be...