Here's an example... you can't do unlimited hierarchies, but it's normally good enough.  And, it's not your specific example... it for something I did for someone else... thought it might...

Unlike DTS, Query Analyzer, and BCP, OSQL was NOT designed to scan the data and size the output accordingly.  Since you don't want headers, BCP is the best bet.  DO...

Tell me... is AppointmentDate a VARCHAR column? 

Unless you need absolutely awesome performance on a huge table, this'll do nicely with pretty good performance...

 SELECT i.IntName,r.RegName,r.RegInterests

   FROM Registrations r,

        Interests i

  WHERE ','+r.RegInterests+',' LIKE '%,'+CAST(i.fk_Interests AS...

That's just not the way we do things here... lot's of folks busted a hump trying to help and now you're not going to take the time to explain what...

No need for even a single CAST or CASE...

 SELECT (

         SELECT COUNT(*) * 100.0

           FROM @ProviderLink

          WHERE PLtat + PLunworkable > 75

        ) 

     / (COUNT(*)) AS Percentage

 ...

Thanks folks... great feedback and I appreciate it very much.

Ben, I've not found much on Triangular joins but I did write an explanation for someone else on this forum.  Please...

You can go a bit further... the following will return the number of spaces found for each row for that column...

 SELECT pkcolumnname, LEN(yourcolumn) - LEN(REPLACE(yourcolumn,' ','')) AS Spaces

  ...

How is it that a casual user has been allowed access to backups?  That, in itself, would be a violation on PCI audits...

The problem may be with any SQL DMO or sp_OA* code you may have... if you forget to close and drop connections, you may end up with a "connection leak".

A 200 mb TempDB is nothing... I wouldn't recommend leaving it that small... as others have stated, figure out how big it needs to be and the set the intial...

Here there everybody... thank you folks for the good info... most of you are of the same ilk about the necessity of a primay key... I think that's why they...

Heh... figures... Rudy!  They cut off my access to the DB in question so I can't see the table and it's dependents anymore... guess they got tired of my prying...

Heh... yeah, I was talking about the indexes.  BTW (dunno if you took it this way)  Didn't mean to make it sound like that whole thing was directed at you or...

I strongly recommend that you do NOT store images in your database... store the file names in the database and let the app load them.

See my next post below for...