Did you get this resolved? It only takes a minor change from previously posted code

😎

SELECT

AC.name AS 'Acct',

(SELECT column_id AS 'Item/data()'

FROM sys.columns AS ITEMS1

WHERE ITEMS1.object_id = AC.object_id

FOR XML PATH ('Items'),...

Using Lutz's code with the addition of NULLIF to also handle literal 'NULL' value

😎

create table #t (EmpID char(5), Name varchar(10), WorkDate date,Status varchar(5),WkdHrs int)

insert into #t

values

('00010', 'JOSEPH', '20140710','P', 8),

('05200', 'ANTHONY',...

Quick question, can you supply the table structure and sample data in a consumable format?

😎

saxena200 (8/2/2014)

---

Alright.. Lets follow it up with some "substantial" details -

our data contains tables which have cyclic dependency, there are transaction and master tables but its not necessary that...

GilaMonster (8/2/2014)

---

Also need to keep in mind that CDC is Enterprise Only.

p.s. Nolock has side effects, it's not a go-faster switch that should be added to every single statement. Let's...

Thanks Gail and Erland, I was slightly (understatement) 😀 hasty responding before.

😎

Jeff Moden (8/2/2014)

---

I agree that SEQUENCE has the advantage of being able to cover multiple tables and that IDENTITY requires SET IDENTITY INSERT if you want to update the identity...

saxena200 (8/2/2014)

---

Really!

u may want to read the second line of the post dude!; BTW I believe I landed on the wrong place for this kind off question.

Thanks for reading that...

Jeff Moden (8/2/2014)

---

Here's what I'd use to solve this problem on my systems because it's short and accurate with the accuracy limits of DATETIME. No... it's not ANSI/ISO compliant...

Jeff Moden (8/2/2014)

---

Sean Lange (7/31/2014)

---

Sql server stores datetime as decimal. You can easily cast a datetime to decimal. But what is the point? What are you trying to do with...

Daniel Matthee (8/2/2014)

---

Hi Eirikur

I dont fully agree that it has the same flexibility.

For example in my suggestion i can create any date range as...

saxena200 (8/2/2014)

---

Hi,

As report model project is being deprecated in ss2012 - what are the alternatives available for us.

we have highly unstructured database (highly normalised and transactional in nature)

Tabular model is...

Nor being implied either,...

Jeff Moden (8/2/2014)

---

Eirikur Eiriksson (8/2/2014)

---

Update code

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @ITER INT = 0 ;

DECLARE @COUNT INT = 100000;

DECLARE @NextId INT = 0...

TomThomson (8/2/2014)

---

Evil Kraig F (8/1/2014)

---

If you want to lock rows for the duration of a transaction from being read, or better keep anyone else from getting into the table at...