Hey nandu. Thanks for the info on this. not sure if Chris or I stated this on the post as well.

The way he...

There shouldn't be an issue. I'm currently running VS 2008 right now using the BI tool and pulling data from a couple of 2005 DBS.

Thanks Drew. That worked perfectly.

Got it. the Stored Procedure is I have is using nested queries to create fields based on specific codes.

One of the nested queries is looking at total...

I think I found the issue. the format of the date field is YYYY MM DD HH:MM:SS:MMM. and the startdate/enddate parameters are smalldatetime so I think I need to...

Hey everyone,

Sorry about te first response.

Here's something I haven't seen. I'm running a Stored procedure that's pulling in data Year to Date...

Join the dark side....They have cookies.

Wait until he hits 12. He'll be wishing he was anakin, I know I do:-D

Was it playing while you were over the Atlantic?

Sorry, have to add my 2 cents in on this. I'm dating myself when i say this, I was about 7 when we went to the movies...

You read my mind. That's actually what we ended up doing.