Viewing 11 posts - 1 through 11 (of 11 total)
What should I do if it is ranking duplicates the same?
--Apply Raw Rank to Payroll / CC
SELECT *, RANK() OVER (PARTITION BY AGENCY_CODE ORDER BY PAYROLL DESC) AS 'Top 7...
January 7, 2011 at 4:32 pm
The post doesn't look like I was expecting,
I get PA_EnterpriseID Then 1 - 10 Columns - BUT the PA_EnterpriseID continues to duplicate and I want it to group, I'm getting...
January 5, 2011 at 8:46 pm
Thanks yewang80 but the values in the column vary, so far I've come up with this, it sucks:
SELECT *, RANK() OVER (PARTITION BY PA_EnterpriseID ORDER BY PP_ID DESC) AS...
January 5, 2011 at 8:44 pm
Lol, I did not read your reply, Pass Through... how do I do that, lol
April 7, 2010 at 12:17 pm
Excellent Advice,
I just tired SELECT VS SET and I still receive the same error message, this must mean it wasn't the "SET" command causing the issue. Also I have another...
April 7, 2010 at 12:16 pm
I'm not able to determine the cause of the error, excel refuses to allow the SET command, then again, maybe the SET command is invalid for use in the query...
April 7, 2010 at 11:56 am
Just to Clarify, the Debug Window Code, pated into Management Studio works 100%
April 7, 2010 at 11:49 am
Thank you, that did help, however I'm still lost 🙁
Immediate Window:
DECLARE @mydate DATETIME
DECLARE @First AS DATETIME
DECLARE @Last AS DATETIME
SET @mydate = CONVERT(VARCHAR(25),GETDATE(),101) SET @First =...
April 7, 2010 at 11:48 am
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 macro...
April 7, 2010 at 11:36 am
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 is...
April 7, 2010 at 11:33 am
Viewing 11 posts - 1 through 11 (of 11 total)