Buddy, this is called spoon feeding. The things u asked above are so...

How about this?

DECLARE @CurrentDate DATETIME

,@StartOfMonth DATETIME

,@EndofMonth...

Wonderful idea; i always thot we could accomplish this via APPLY,...

First lets set up the sample data ( remember, you chances of getting a lovely query will depend solely on how clear and elaborate your question is)

SET NOCOUNT ON;

BEGIN

IF...

A series of 15 CASE statment will do. Or dymanic query is also a route u can take.

Example of CASE statement

select country,

...

Thanks for stopping by and posting this. This would we heart warming to everyone of the answerers in this forum.

LIKE at times make the query SARGable but CHARINDEX. CHARINDEX might cut performance form the total query ( My personal tryst with CHARINDEX has always been dreary 🙁 ) May...

Results from my laptop ( my laptop sucks 😀 )

(100 row(s) affected)

(1000000 row(s) affected)

========== BASELINE ==========

(2 row(s) affected)

SQL Server Execution Times:

CPU time = 110 ms, ...

L' Eomot Inversé (11/3/2011)

---

Here's some code that does that: it orders the groups by their max price (descending), and the rows with a group by their price (descending).

Could use a...

Even better solution

DECLARE @MaxIDoFMaxPrice INT

; WITH RowWithMaxValue AS

(

SELECT TOP 1 ID

FROM @Table

ORDER BY PRICE DESC

)

SELECT @MaxIDoFMaxPrice = ID FROM RowWithMaxValue

SELECT * FROM @Table

ORDER BY CASE WHEN ID = @MaxIDoFMaxPrice...

How will this do?

DECLARE @Table TABLE

( PRICE INT,

SOME_TEXT VARCHAR(15),

ID INT

)

INSERT INTO @Table

VALUES

( 11000 , 'AAAAAAAAA', 2 )

,(12000...

So, the Group with the max price at the top with individual prices in the same group sorted by in desc order. what about the rest of the groups/rows? they...

How about this?

SELECT A.[Account#] , A.RepCode [OldRepCode] , CrsAppOutput.RepCode [CurrentRepCode]

FROM #Account A

CROSS APPLY

( SELECT TOP 1 AD.RepCode

...

Can you provide us sample of your data ( not your original data, but a mock-up)

Depends how do u define failure here... a failure is , say, datatype mismatch or failure to find a matching row ?