Use ALTER TABLE

You can do:

select * ...

Stephanie Giovannini (1/14/2015)

---

Agreed. The other two candidate...

Why would you want it in function? Whatever reason, it would be highly unrecommened.

However you can use dummy loop:

declare @dtStart datetime=getutcdate()

...

"CASE WHEN"-less query also possible for ColC of string type:

SELECT [ID]

, ColC

, LEN(ColC)-LEN(ColC)+ROW_NUMBER() OVER(PARTITION BY NULLIF(ISNULL(colC,''), colC) ORDER BY [ID])

FROM #test1

ORDER BY...

With a given data type of your ColC column, you can do the same without any CASE WHEN:

SELECT [ID]

, ColC

, ColC-ColC+ROW_NUMBER() OVER(...

I think this list is missing one extremely important "Best Practices" point:

#7 Never connect to SQL SERVER by any means and never try to run any query against it as...

You should be able to modify the following as per your requirements:

declare @p xml = '<root>

<DOCTOR.SSN>

<OldValue />

<NewValue>111111111</NewValue>

<DisplayName>Social Security Number</DisplayName>

</DOCTOR.SSN>

<DOCTOR.EMAILADDRESS>

<OldValue>abc.com</OldValue>

<NewValue>Julietest@yahoo.com</NewValue>

<DisplayName>Email Address</DisplayName>

</DOCTOR.EMAILADDRESS>

...

What kind of output do you want?

Your output example doesn't represent recordset...

Try this first:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

or wait for someone who will do it for you...

You can generate number on fly without using identity:

SELECT CONVERT(VARCHAR(6), GETDATE(), 12) + 'GP' +

RIGHT('00000' + CAST(ROW_NUMBER() OVER (ORDER BY (SELECT...

The conditions are not really too complicated here and I would recommend...

1. to ignore(not delete) records that have an enterDate equal to either a conversiondate of '2010-01-01' OR a termDate of '2001-01-01'; If they do, use the processDate to select instead...

Adam Bean (12/11/2014)

---

After some more digging and testing, it would seem that a SELECT INTO does indeed lock some of the system tables.

We're now starting to dissect performance between SELECT...

I would recommend this for reading:

http://www.brentozar.com/archive/2013/09/index-maintenance-sql-server-rebuild-reorganize/