Avatar of Newie_reporting_services

asked on 

How to arrange data in your SQL statement

I have attached a PDF so you can see what I am talking about.

In the matrix I have Prospect Status and Rating Description.  How can I move around each field in the Rating Description.  Example

$40000 - $50000

I want to arrange these in the correct order in the report or sql statement.

SELECT     DCons_ProspectStatus, DConRtng_RatingDescription, COUNT(DSol_ConstituentID) AS Expr1, DSol_ConstituentID, DSol_FullName
FROM         DR_SolicitorRelations
GROUP BY DCons_ProspectStatus, DConRtng_RatingDescription, DSol_ConstituentID, DSol_FullName

Open in new window

Microsoft SQL Server 2005

Avatar of undefined
Last Comment

8/22/2022 - Mon