Thanks you very much Eiriksson..Excellent solution with good matrix explanation..

But Need to exclude alphabet letters like I and O those easy to confuse letters with numbers from the series

g.britton (11/28/2014)

---

How? Sequences do not allow apha-numeric data. They can only be of these types:

tinyint -...

we are using sql 2014. we can implement the solution using sequences

Luis Cazares (11/26/2014)

---

I would keep an identity with seed and increment of 5. Based on that identity column, you could calculate the needed sequence. Note that with this formula, you...

Thanks Luis , sorry for the confusion.

As you all suggested we can go with identity columns as a primary key and computed column for unique sequence numbers.

i have installed SQL Server instance in E drive(E:\program files\MSSQL12.SQL2014_4\MSSQL\DATA),

restored Master db in E drive it self ..

but I am not sure why error log shows "C:\Program Files\Microsoft...

Hi ,

PFA is the Last few lines of Error log.

Thanks Miller,

Query working as expected , here is the query I used for dynamic pivot from #temp2 result

DECLARE @sqlNVARCHAR(MAX)

DECLARE @dynamic_pivotNVARCHAR(MAX)

SET @dynamic_pivot = STUFF(( SELECT DISTINCT ',' + ColumnName FROM...

Thanks Matt!

Is there any way to select columns names dynamically as we may add more key values pairs in XML in near future.

just like 4th row

INSERT INTO #temp

VALUES...

Cody K (4/10/2014)

---

You can't use secondary mirrors for reporting without...

Thanks Cody K,

So read-only replica is always sync with primary and we can query on read-only replica at any time.

Grant Fritchey (3/18/2014)

---

Snapshot isolation is great when you have a mix of exclusive locks and shared locks because it isolates them from each other. But this is a mix of...

Tried with TOP(100) .. but still no lock

There is no offpeack hours on that database...