Many thanks Martin, 
That was the missing step, setting the date type in the advanced tab of the source data. I had to do it for both the table creation...

Cheers, 
I'd be interested in what you find.

OK, I'll try again in the hope that it provides more calrity on the issue I am having..... 

I attach 3 files.

1. The csv data file, Import1.csv (attached here as a...

Thanks guys for the help. Think i've now something which will work. Still don't fully understand the surrogate key. Gotta research a bit more. Also ignored the 'merge' for the...

daniel.freedman 80164 (11/12/2014)

---

You may be over-thinking this a little. Just have a holding table with a surrogate key field and use that for the clustered index (the data is stored...

Cheers Daniel,

Holding table is the way to go for sure. Was going need that for other validation.

Craig's idea to combine fields to make a key field is also going...

Cheers Craig, for the quick response.

Logically, i figured as much. Since i can't control the data coming in, I'd have to check against each existing record.

Cheers guys,

I have used the script approach before, when adding new SP's for example, but its still tedious when i gotta list out all my stored procedures for...

Thanks Gail for the quick reply.

Problem was i had a user with the same name, in the db users list.

Once i remove it, then it allowed me to re-create...

You hit the nail on the head Louis.

Many thanks 🙂

Thanks again.

Here's the code i ended with. (bit raw and needs tidying but works).

(code has been simplified for ease of reading, and left out the obvious stuff. Changed...

Thanks for help.

I understand now that i have to work around, but have an answer if I use sum in place of count, and remove the results field. Gives...

No that did not work. But i see the...

First many thanks for the really quick reply.

Here's the code. While the second reply will get me an answer, results are in 2 colums. Need them as a list....