Viewing 15 posts - 1 through 15 (of 19 total)
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!
May 3, 2019 at 5:26 pm
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...
May 3, 2019 at 3:08 pm
I don't know why I didn't think about just making multiple tables and inserting the data I want into each. Thanks Jack!
November 4, 2011 at 3:05 pm
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...
April 28, 2009 at 8:50 am
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.
April 28, 2009 at 6:26 am
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:
April 23, 2009 at 6:13 am
CREATE PROCEDURE dbo.GIFTByDate
@STARTDate datetime
,@ENDDate datetime
AS
SET @StartDate = DATEADD(day, DATEDIFF(day, 0, @StartDate), 0); -- get start date...
April 23, 2009 at 6:09 am
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
April 22, 2009 at 2:24 pm
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...
April 17, 2009 at 6:14 am
Glad to have been helpful. BTW, it is MRitch but I kinda like Mr. itch...:w00t:
April 13, 2009 at 3:07 pm
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:
April 13, 2009 at 1:24 pm
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...
April 10, 2009 at 6:31 am
Thank you for your help! I will try your script.
April 9, 2009 at 11:42 am
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.
April 9, 2009 at 10:34 am
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...
April 2, 2009 at 8:24 am
Viewing 15 posts - 1 through 15 (of 19 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy