I knew it!  I've always hated composite name columns... I'm trying to get them to change it but we have a 3rd party app at work where they allow up...

What do I lookup to figure out how to change how the formatting is done?  All I could find was the following and it wasn't very helpful...

Format SQL

You...

If you have a pot-wad of data, I suggest you create a sister table with a UNIQUE IGNORE DUPLICATES key on it... copy the data to the new table and...

The names and ID's of the objects are stored in the SYSOBJECTS table.  The SQL for each is stored in SYSCOMMENTS and the ID in SYSCOMMENTS matches the ID in...

Yes, it would be faster to use a single file... but, then you'd also loose the granularity you need to check the creation of each stored procedure for errors...

I'm not...

You don't need to build  a function for this... if you are always guaranteed to have 3 parts, then there's a function built into SQL Server... ya just gotta give...

You can use the hack, or you can use the functionality built into SQL Sever...

SELECT DATENAME(dw,GETDATE())+' '+CONVERT(CHAR(11),GETDATE(),106)

Ummmm... why not just setup a standard maintenance plan from Enterprise Manager whick, I believe, will do all of that for you.

A better way to do this for the sake of performance is...

 SELECT tab1.*

   FROM tab1

   LEFT OUTER JOIN tab2

     ON tab1.Col1 = tab2.Col1

        tab1.Col2 = tab2.Col2

       ...

Ah yes, absolutely true... I sometimes just forget about things I'm not allowed to use and, unfortunately, I work in a shop where .Net is not allowed.  Don't know why...

Thanks Ray... that's just what I was looking for.  Dunno if ANSI allows for derived tables but I guess I'm going to find...

The key is in the snippet Kenneth posted...

Francis, I know exactly what you're going through... I just inherited yet another monster set of databases and I think among all the SQL procs, views, and udfs, there might...

If you just want your script to give you info from yesterday no matter what today is, you don't need FLOAT and you don't need to pass a date.  I...

Not sure why you'd want to do that when a good maintenance plan will achieve the same result of having properly ordered and defragmented indexes.  So, I have to ask,...