Guys,

I use HAVING all the time. It is alive and well in my code. I'd like someone to find a simpler way to get a list of customers...

Gabriel,

Mine probably could execute faster if I had included the Month Description in the dates index. It probably wouldn't have to do any bookmark lookup then.

I've found that using...

I wouldn't use a numbers table on this type of query. I'd rather use a properly indexed calendar type table. I've found that they are very useful for...

Gilles,

Let me know how it goes.

Todd Fifield

Gilles,

If the back end database is Access then you get the new autonumber (RecID) as soon as you start to insert a new record. With SQL Server as the...

Gilles,

Let's say you have a button on the form that saves the current record called btnSave. Let's say that the primary key for the table is an INT called...

Gilles,

I forgot to mention that the requery would then put you at the 1st record in the recordset. A solution to that would be to save the primary key...

Your problem is that you have a form bound to the underlying recordset that gets changed outside of the form - i.e. the trigger. Access has read the underlying...

I somewhat regularly use multiple record sets for front end apps that are either .Net or some Java web front end. They are useful when you want to load...

There's another way to do this using the EXCEPT operator.

SELECT *, 'A' FROM samm

UNION ALL

SELECT *, 'B' FROM sammM

EXCEPT SELECT *, 'B'

FROM samm

The reason you have to use...

Gail,

Your post on NOLOCK has cleared up one of the big mysteries of the universe for me. Thanks

Todd Fifield

I'm with Gail and Jeff and Bob.

If I were going to write a stored procedure from scratch to do what you're doing I would break it down into pieces and...

Jeff,

Thanks for posting the link about SELECT INTO. I've been given grief by other DBA's for using this technique for years - claiming that it locked sysobjects in tempdb....

Jeff,

I got into the habit of doing it from debugging large complicated stored procedures. I copy the procedure code up to the point where I want to see intermediate...

This type of query will give you the actual number of spaces in the columns:

CREATE TABLE XX_Test

( [Col 1]INT

, [Col 2]INT

, [Col 1 X]INT

, [Col 2 X] INT

,...