In the absence of test data here is my spin on it

DECLARE @Client_Domains TABLE

(

Client_VndName NVARCHAR(100) ,

...

Can you provide some sample data and expected output for this please? In the middle of giving it a go now 🙂

No worries. Glad to have helped

Thanks :blush:

dbalmf (3/7/2014)

---

I would do this:

Create a backup of your table, because backup is your friend.. 🙂

Select all archive rows into a temp table

Update the rows in the temp table with...

Rough and ready. Customers matched on customer ID and where have Type 'Archive' will be updated with details from 'Recent' This also assumes that only one 'Recent' entry...

Can we assume where 2 records exist for a customer we take the 'Recent' type to update the 'Archive' type when different? Is there only even one recent type...

Whilst not my area of expertise I do have a couple of questions:

If the database has failed and you cannot repair and data will be written to the old database...

It does yes but we get round this by writing a custom query to create the headers and add that as part of the BCP script

Depending on the volume of data we generally go for BCP when exporting data from a table to CSV. This give great flexibility generating the file name on the...

This is likely to do with what Gail has mentioned already. Your database collation is case sensitive and as such anywhere you use the variable from the point of...

GilaMonster (2/24/2014)

---

michael.higgins (2/24/2014)

---

GilaMonster (2/24/2014)

---

Yeah, I mean it's the SQL Server 2008 forum, surely it must...

GilaMonster (2/24/2014)

---

Yeah, I mean it's the SQL Server 2008 forum, surely it must be SQL...

Here is me assuming it's 2008 :blush: What is it they say about assuming !

Just ran that and it's good on mine. At a guess I would say there is possible some reserved word or an iffy named table?

I will have to pass...