Not necessary at all. It shouldn't affect performance. The optimiser should be smart enough to ignore it....

JMSM (1/27/2008)

---

I can’t tell you much more since i arrive this new job last Monday.

People who works here tell me that they dettach the database where this query is...

You said you were going to store it as a numeric and do all the manipulations and editing in the front end. Do the same, just have it as a...

Ok, so you have no indexes other than the primary keys (from the code you posted). Is that correct?

I'm just guessing without knowing the rows involved, but perhaps indexes on...

That's one thing I learnt years ago. Becoming invaluable...

Could you please post table schema, sample data and desired results.

Please see the following article - http://www.sqlservercentral.com/articles/Best+Practices/61537/

Almost. I would suggest you leave the datetime as a datetime in SQL. That way you can use all the date time functions and you don't need to worry about...

In that case, I would suggest the following.

When the new file is spotted, import that file (bcp or Bulk insert) into a staging table. Then do joins between that staging...

In SQL a short date time is a date and a time. SQL tables have no concept of formats.

My access is rather rusty, but maybe you could link the table...

Cross post. Replies to the following thread please - Managing Hours and minutes (MS Access)

Don't think so. Will check next week.

That's gonna really hurt, especially if there's no index. Are there other indexes on the table, other than the primary key? If so, on what columns

Where are you getting the...

The Insert into ... select is what you need. There's no problems with including variables or constants in the select clause of a select statement.

Insert into TheTBL (ColumnList)

SELECT M.Email, @msg...

Had to ask. You'll be amazed how often the simplest possible explanation to a problem is the correct one....

If you add all the columns listed in the group by to the select, what's the result set?

Basically, there's something in the group by that shouldn't be there for the...