I am not clear with your requirement..can you please some more detailed information to us.......

mkswanson (7/19/2013)

---

In the statement below, there is a problem where some records are occasionally duplicated. I have not been able to figure out where my problem is.

When...

Change the datatype of Op to CHAR and run the query that I posted... Hope it will work for you

you can try this-

;WITH CTE AS

(

select op,imei, DENSE_RANK() over (order by op,imei) rankno

FROM mastertab

)

select c.op, COUNT(distinct rankno) - 1 cnt

FROM CTE c

GROUP BY c.op

First thing is your table structure is incorrect..

You have specified op as INT but you are inserting character values in that column

aa, 0191, 111222333

Can you please provide your merge script that you have written,,,,,

As Sean said we are not cleared what you are trying to achieve and your Select statement is also incorrect as you have nt specified any column names.....

Can you please...

ChrisM@Work (7/19/2013)

---

Steve-3_5_7_9 (7/19/2013)

---

Of course you...

Steve-3_5_7_9 (7/19/2013)

---

Of course you can....

PLease provide the proper DDL statements and data so that we can help you in your problem....

Refer this link whever you post any problem:

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

Thanks Perry... I was unaware about this TUF file fact...

NO you cant add the IDENTITY property to the existing column using a sql query....

But it can be done from edit design of a table

dan-572483 (7/18/2013)

---

Interesting! When tinkering with data, I've often forgotten to to run COMMIT TRAN until the last change, then just ran COMMIT TRAN repeatedly until "The COMMIT TRANSACTION request...

I select SSDT as now when we open new SQL SERVER 2012 it comes with name Server Server Data Tool so I selected that option but still got wrong :w00t:

You can do one thing.....

You can assign your constant value to a variable like this

Declare @var char(3) ='abc'

And put this variable in condition of your case statements.... So if...