Thanks alot and that's what I thought.

King regards,

Eamon

thanks alot, added " as a delimiter and it sorts it.

Regards,

Eamon

Thanks for this.

I kind of expected a reply like this as I've looked around quite a bit and always ended up with CLR or SSIS offering a solution.

Building the html...

Thank you mister.magoo, this works perfectly.

Kind regards,

Eamon

because a downstream process then takes the xml which feeds into a report.

I can't amend the downstream process.

Thanks for this.

The reason I know is that this is an old app which the vendor isn't supporting anymore.

Sometimes a data issue occurs and we've been told that a hard-coded...

Thanks Simon,

NASA do a similar intergalactic feed along with data for finding extra terrestrial beings!

Might be too scientific for me though and I very much appreciate the reply.

Any other suggestions...

shouldn't it be this?

If you're still getting problems run it with the table getting created with one column, then run it so it gets created with two columns, then three...

select from the table using the ROW_NUMBER() function ordering by id and partitioning by value.

Wrap in brackets giving you a derived table.

Run a delete command against the table and joining...

the MERGE statement might help you there but I would create separate update statements and run as a single transaction. Also use nested if statements so that if one...

you'll need to specify each column in the select statement and for the dupe column names use AS to rename.

eg

SELECT

a.dupe_col...

!! WOW !!!

and it's simpler too !:-)

Create a trigger that seeks out any child records and deletes them if found.

Eamon:-)

Hi,

this is an easy one that you can do with an exotic join in conjunction with an addition calendar table.

Yesterday I posted a short case study which illustrates what you're...

Thanks alot guys this is what I thought but decided to post this question just in case I missed some new feature addition to SQL server.

Thanks for the help on...