Here is the problem, everyone is shooting in the dark. If you would like the best help possible, please read and follow the instructions detailed in the first article...

Give this one a try. You may need to modify it a bit, but if you give me some sample data I can do some of the work.

USE [SandBox]

GO

/******...

I promised you how I'd write the query, and here it is:

declare @Year varchar(30)

set @Year = '2009'

select DATEADD(mm, 0, DATEADD(yy, CAST(@Year as int) - 1900, 0))

SELECT

PART.DESCRIPTION,...

drxjuby (12/8/2009)

---

I thought that would be the case and I will do that.

In reviewing the proper way to submit posts, I was able to figure out a way to handle...

Surround your code with the code block tags (no spaces inside the brackets): [ code="sql" ]your code[ /code ]

All depends on which side of the Equator you reside. Fridge is quite applicable along the Front Range of the Rockies. I had over 5...

Can't tell you what type of questions that you may be asked, but I can provide some advice.

Answer the question and nothing but the question.

Have documentation available to back up...

Now we are a PC Help Desk.

Edit: The post at the other end of the link above has been deleted, so don't try following it.

Sounds to me like you will need to set up a server-side trace on the system. Others may be able to help you off the top of their heads...

Is there supposed to be a space in the file name, '/Data 010109.zip'?

Personally, I'd fix the ETL process and rerun it.

Not knowing the structure of the data (the tables) it may be a bit difficult to provide you a proper answer. ...

Offer suggestions we can't, your code we can't from here see. The force strong enough it isn't.

Please post your code, we really can't help you if we don't know...

The Dixie Flatline (12/7/2009)

---

Spam emails: The preferred method of getting your questions moved to the head of the line when URGENT isn't working for you. I'm not...

I would agree. If we are moving toward 64-bit OS's, both server and desktop/laptop, then there really should be 64-bit versions of the drivers needed to access Access and...

Maybe just a extra 2 or 3 seconds...