SQL-Squid (11/7/2012)

---

Tava (11/6/2012)

---

SQL-Squid,

I was told I can request the app designer to include a primary key in the feed I receive, if that does happen, the merge will be...

SQL-Squid (11/7/2012)

---

Tava (11/6/2012)

---

SQL-Squid,

You're correct in what you said the issue is that your source has duplicates, so based on the below you will always return multiple results, hence the...

Yes Sorry, I meant Update/Delete not Update/Insert...

SQL-Squid,

You're correct in what you said the issue is that your source has duplicates, so based on the below you will always return multiple results, hence the MERGE statement...

As previous poster asked whats the Datatype for ArchiveID? possibly could be varchar?

Can you show a sample set of Information? like archiveID 13/14/15 if its confidential then just mock...

Thanks guys,

I had the same solution as BriPan up to the Row_Number statement - i had a while loop that would do it while a < b it worked...

All done... thanks everyone for your help... it might be the worst piece of code written but it works & i go no idea what i need to do.

Let me...

The Dixie Flatline (10/24/2012)

---

If you may have a variable number of attachments, you can use CROSS APPLY with the .nodes method to break out multiple nodes into multiple rows. ...

Thanks for the help both of you - i got it working but i have 1 issue if there is multiple attachments

<Attachment>TestAnnouncement123.pdf</Attachment>

<Attachment>TestAnnouncement999.pdf</Attachment>

<Attachment>TestAnn234.pdf</Attachment>

Im inserting into Audit table

INSERT...

I've tried the following from what i read and turned it into an XML, I believe anyway but could be totally wrong - still though even though i've turned it...

Thanks for the replies, I tried both those ways (derived & transformation) prior to doing my idea and I was not able to get it to work. I was...

Hi all,

I resolved the issue by doing a additional check in my stored proc, checking to see if a certain value <> ''

The value should never be empty as it...

Regional settings were dd mm yyyy but i dont want to change it .... STUFF Reply helps me there.

i tried the variable way but im going to stick with the...

sorry 🙂 it was more to see of a way to see if i can understand it better if you know what i mean the STUFF syntax confused me, while...

It still comes back as 15122004 which is how it originally is stated. using that convert

the CAST(STUFF(STUFF syntax worked but trying to do it as a convert like if...