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...

See the Attachment

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...

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...

Lol, I did not read your reply, Pass Through... how do I do that, lol

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...

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...

Just to Clarify, the Debug Window Code, pated into Management Studio works 100%

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 =...

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...

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...