Thanks, Tom. I actually spent quite a lot of time on it. I especially liked that though it was T-SQL question, cutting and pasting it to a query...

Hmm, I'm having a lot of trouble...

FYI, I just remembered that the DAY/DATEADD/DATEDIFF functions can be a problem sometimes...

Hang on, I'll have to look it up...

Well, I most definitely am not a SQL Server DBA, even though SQL Server is my primary focus. I am a SQL Server Developer and (even worse :-)) a...

Go to the "Processes" tab and then sort-descending on the CPU column.

My pleasure, Jason. 🙂

Oops, I forgot one other possible solution: Use a PASSTHOUGH option. Almost all access method libraries have some kind of option to allow the query to be passed...

Understood. This is uncommon, but still a reasonable occurrence, primarily because the SQL that you are...

photonicman (4/7/2010)

---

Also, the error is not very descriptive, I attached a copy of the error, if I goto Debug, the select line of code is at the end of the...

photonicman (4/7/2010)

---

The Debug.Print SQL command doesn't yield any results, the SQL Query is not allowed to execute, excel stops the query from executing with the run-time error 1004.

I think there...

GSquared (4/7/2010)

---

RBarryYoung (4/7/2010)

---

ghostdance1969 (4/6/2010)

---

OMG..............I feel so stupid, lmao............

I can't believe I overlooked that this whole time.

Thank you so much

By the way I read alot of your replies helping others, you're...

Well, some of it is, but a lot of it is not even there. Rather, much of it is...

Here's some stuff that can help us answer your question:

1) add a DEBUG.PRINT SQL and paste the results here so that we can more easily see the whole SQL command...

Lookup the syntax for INSERT INTO..SELECT. You cannot put any external qualifications between the INSERT and the SELECT. If you want to filter it you should do that...