>>I blame the practice on Access database users.<<

Poor, maligned Access users! 🙂

I came to SQL Server via Access, but I *never* used spaces in names.

On the other hand, I've...

Thanks for all your helpful posts! I knew I would get good answers from this gang 🙂

You were all correct -- the prefix values needed to be zeros (From a...

FORMAT FILE FLOPS FOR FIXED-LENGTH FILE...

I'm having a great deal of difficulty trying to BULK INSERT from a fixed-length text file into a SQL Server 2000 (SP3) table. From scanning...

whoops, talk about a good example of things not retaining original spacing when you cut and paste... my header example lost all of my laborious indentation.

-- SteveR

A very good thread, thanks again Andy!

I do like to include a header, for many of the same reasons others have mentioned. I've included a sample of a typical one...

Be careful with counting on GROUP BY to do ordering with SQL 2000. This may still work on version 7.0 and below, but you can't really tell beforehand if a...

quote:

---

If you use the 'permanent' temporary table with the SPID column, you will want to clear it at the start of your...

Hola osoto!

If you decide to use a permanent table, I'd suggest adding a column called SPID, and when you do your insert into the table, include @@SPID (process ID) as...

I gotta love 'em!

Back in '89, I learned the concepts of RDBMS, data modeling, etc, but couldn't find a tool to practice on (there was no way the IS people...

Hi!

In your case, you should be able to repeat the entire CASE statement (minus the alias) as a GROUP BY :

GROUP BY

CASE WHEN DATENAME(weekday, (CONVERT(varchar(10),mydate,103))) = 'Friday'

THEN 1

WHEN DATENAME(weekday,...

>>What are your opinions on numer 1, 5 and 6 on http://www.intelligententerprise.com/001205/celko1_1.shtml?<&lt;

Hi Michael!

Thanks for the great link to Joe Celko's article, "Ten Things I Hate About You -...

This is an excellent thread -- I learned a number of new things! Thanks, Andy.

As to the use of Identity columns as Primary Keys verus using "natural" keys -- I've...

Steve - a very good article - thanks very much! I also was struck by practicality of your use of commas ahead of each column in the SELECT.

I'd be...