You need to share more detail regarding your issue, sample information if possible so we could understand what is causing the issue.

One point thou, If you are calculating something inside...

Its self explanatory, you should better check the procedure source...

Woww .... to many nested While loops 🙂

Nice question, as its reminded the nested loop depth. Thanks for sharing.

I wonder what Jeff Moden have to say about this ... ...

Let me clear you on...

for a moment i was like :w00t:

I suppose script is not unit tested 😛

Excellent solution shared by Eirikur. i should avoid sharing not recommended solution in the future.

Just to let you know and other information regarding the namespace. Please do make sure...

just to give you idea:

Declare @Xml as xml = Replace(

'<ClinicalDocument xmlns:sdtc="urn:h12-org:abcd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="urn:h12-org:v3">

<realmCode code="US" />

<typeId extension="POCD_HD000040" root="2.16.840.1.113883.1.3" />

<templateId root="2.16.840.1.113883.10.20.22.1.1" />

<id root="226ff30f-3b1f-11e3-a969-005056bb0109" />

...

you are welcome.

Easiest would be to use Import Wizard of sql server, fetch the data from the source

create a staging(new)...

interesting question. Thanks for share

nice question steve, thanks for share 🙂

ok, so now can you share how you are doing it on SSIS, as its works on teh avaliable meta data for a given object. i-e, if the SSIS see...

xrapidx (9/5/2014)

---

Trying to keep this as simple as possible.

SQL2008R2

I have a source that uses change tracking - we need to pull through and handle deletes on the target.

1.) The target...

DrKiller (9/4/2014)

---

I think the explanation need some work.

CTEs doesn't ALWAYS need a semi-colon in front.

This for example works fine:

DECLARE @tmpVariable INT

WITH cte

AS

(

SELECT 1/0 as 'Result'

)

SELECT *

FROM...

Nice question. Table Type is a very handy feature if someone know of its existence.