What exactly are you trying to do in Access? Are you running VBA code? If so, what is it?

Todd Fifield

You actually don't need an explicit transaction unless you want to roll it back. The idea is that the next key value in the table has the one you...

Jeffrey,

I live in Lake Arrowhead and have to commute to Gardena 3 times a week. I can understand your comments on the commute.

Todd Fifield

I've done a lot of Access/SQL Server development. I avoid joining a local Access table to a SQL Server table unless the Access table has only a couple of...

I've been meaning to write an article about just this sort of key word search, but I haven't quite got around to it yet. The type of search I'm...

Ejbatiu1,

I would handle this sort of thing with a calendar table and let the table to most of the work. It would make things easier if for some reason...

I deal with a proprietary POS system where the Delphi code is not touchable and so to get some things done I have to resort to triggers - even though...

The almost dead give away...

Annamika,

As I understand it you want each customer whether or not they have an order for a particular day and only 1 order. I would use a Calendar table...

UDF's don't necessarily hurt performance. I write UDF's all the time to do string manipulation type actions. These aren't much slower than built in functions like SUBSTRING(). ...

Mathew,

I would use a calendar table to do all of the heavy lifting on this type of query - especially if you have to do this each month. I...

Brian,

The easiest way to do this is always update everything and use ISNULL() function to set the column to itself if the corresponding column is null. I use ISNULL...

Grant,

The point of what I was getting at is that I used this method to determine that there were 2 distinct sets of parameters. I had a situation where...

I've had very good success using the surrogate identity key as the clustering key in this type of table as long as the other index is selective enough. The...

I know I'm coming in on the rather late. There have been times when I had to open the stored procedure, then copy/paste it to a new SSMS window...