Sorry GSquared, when I said the solution won't work because of the 5s, I was referring to the solution from G² (what are the chances of such similar names?? ;))....

Hi Lowell,

I think your solution would only tell me how many available hours there were in a week, rather than how many days in the week have availability - that...

Thanks Matt,

You're right, I didn't ask the correct question originally which is sometimes half the trick. Thanks for the clear explanation - your answer has shown me exactly how to...

OK it turns out the example I gave was overly simplistic (hmmm, maybe that applies to me too! :unsure: ). Does the same logic apply when using NOT IN ([sub...

Thanks to both of you on this. I can see that you're both right. And I guess the bottom line is that now I know the answer I can remember...

Hi Luke,

Thanks for your advice. I think I need the derived tables because there are sometimes 30 or more rows in the source table where I need just a single...

Thanks Gail. I know what you're saying about data normalisation. The issue here is that these are raw data dumps (from another database with a completely different structure) that are...

Thanks to both of you for your help with this. The server went down last night and has stayed down, so currently I can't test it, but it looks good....

Hmmm, Lowell hit the nail on the head - it's a unicode file. But having said that, I've tried saving it out as ANSI (just using notepad) just it's still...

Hmmm, sorry that this is dragging on everyone, now that I have the files in the right place (;)) the tables are being picked up. However, when I open the...

Ok, apologies for that guys - I needed to put the csv files on the sql server, not my local drive :blush:

Hi Lowell, Hi Jeff,

Thanks for your suggestion - sounds just right for my situation. Everything works fine until I get to this bit: SELECT *

FROM TxtSvr...sample#csv...

Thanks for your help Carolyn,

Tom

Hi Tomm,

I hear what you're saying and agree with it. Now I have to fess up to being a tad disingenuous with my original post. My real life example has...

Thanks for your help everyone. I'll give it a try 😎

Tom