Katie, something which may help is a fixed-leg chair i.e. one with four legs and no castors. It's very different sitting on one of these as opposed to the 5-leg...

Hi Surya

It would sure help us all if you could post the first few lines of your file 'surya.csv', opened with Notepad...

Cheers

ChrisM

Hi Matt

I do two hours each way, but when I read this...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=61&messageid=378449

...it don't seem too bad. My predecessor was surly and uncooperative, couldn't handle the workload even though he...

Oops! Did the work last night, posted this morning, sorry. You have a knack for posting the perfect solution Peter, magnificent. The most concise and the fastest method, and exactly...

Don't you just adore helper tables?

You can do this with a smaller table, though...

DROP TABLE #Zeros
CREATE TABLE #Zeros (HowMany int, zerostring Varchar(13))
INSERT...

...or post a few lines of the file opened with a text editor so we can see those pesky double-quotes!

It's summer here in the UK, showers are outdoors.

No kidding, doc, that's really stinjy (okok I don't know how to spell it).

I did a 6-stretch for Barclays Bank last year, signed up as a temp. Even as...

BTW Ade, isn't living on the set of the esteemed soap Hollyoaks sufficent perk already?

Good lord Adrian that's cushy! I'm living in Reading and contracting in Surbiton, two hours each way (3 trains) - they gave me a lappy set up for vpn, wednesdays...

<<For me? I could use a stable boy >>

My colleague told me that the boys at the local school here are pretty stable, before...

Hi Randy

Just a thought (from a recent thread)...check that your datatypes are EXACTLY the same between the SELECT from your source table, and your target temp table.

Values which are...

Surya, Excel does nasty things when it opens files, like hiding characters which are essential for us to see when we're figuring out how to import data. Try opening your...

Not really - putting it in the GROUP BY in the way you infer won't actually change the result set because every row in the set will have the same value...

This will work...

.

.

WHERE (l.[Name] IS NOT NULL OR c.[Name] IS NOT NULL)

AND  m.[Name] LIKE 

    CASE WHEN @FirstName IS NULL

         THEN m.[Name]