Removing the alias makes perfect sense, oh and it works perfectly! This will make my reporting a lot easier!

Thank you Sue for the insight and Ben for the article!

So I have tried this query and I repeatedly get the error "Invalid column name". Everything I have read indicates that you can't use alias in the group by since...

I don't know why I didn't think about just making multiple tables and inserting the data I want into each. Thanks Jack!

Sounds to me that you will need to prep you excel files by stripping the useless data from the beginning of the file and then maybe create a standard set...

Follow the link at the bottom of my post for help on getting help. I am sorry I don't have an answer on your Excel issue.

Sorry about previous post. Clicked wrong button.

Jeffrey, you are correct with regard to timestamp issue. I hurried past that without thinking about the single day selection.

I bow to your greatness...:hehe:

CREATE PROCEDURE dbo.GIFTByDate

@STARTDate datetime

,@ENDDate datetime

AS

SET @StartDate = DATEADD(day, DATEDIFF(day, 0, @StartDate), 0); -- get start date...

Something like this should work...

CREATE PROCEDURE [dbo].[GIFTByDate] (@STARTDate datetime, @ENDDate datetime) AS

begin

select pledge.giftkey,pledge.gifteffdat,pledge.giftamount

from gift.pledge left outer join chart_of_accounts on chart_code=pledg.giftrest

where pledge.gifteffdat between @STARTDate and @ENDDate

end

A google search on the error string you present doesn't return much on your specific topic. I broke the error down and searched and found some references that didn't exactly...

Glad to have been helpful. BTW, it is MRitch but I kinda like Mr. itch...:w00t:

I have not done this myself but here is a link that may help you solve your issue.

http://msdn.microsoft.com/en-us/library/aa964131.aspx

Hope this helps you solve your issue...:cool:

I had the same issue and created a SQL login for report users including my domain users and embedded the credentials in the data source and that seems to be...

Thank you for your help! I will try your script.

Sorry Lowell I always forget something... :Whistling:

The tables are basically flatfiles. There is no FK or PK for that matter. They are a collection of denormalized data.

The link below may give some insight to memory usage by Excel 2007.

http://www.decisionmodels.com/memlimitsc.htm

Have you tried to connect to your data from another workstation and running the process?

Can you...