This:

SELECT tr.practice_id,pr.practice_name

,tr.user_id,CONCAT(u.first_name,' ' ,u.last_name) AS 'User_Name'

,tr.doctor_id

,CASE WHEN tr.doctor_id...

Like this?

DECLARE @StartDate DATETIME

, @EndDate DATETIME;

SELECT @StartDate = '08/01/2011' ...

or this?

; with cte as

(

SELECT distinct master_id, sub_id

FROM SlaveMarket

)

select * , outp.minval

from cte a

cross apply ( select MIN ( sales_price ) minval

...

this?

; with cte as

(

SELECT master_id, sub_id , slave_price , ROW_NUMBER() over( partition by master_id , sub_id order by slave_price asc) AS slave_price_min

FROM SlaveMarket

)

select * from cte

where slave_price_min = 1

just useful ?? not helpful ? 😀 did it solve ur problem ?

How about this?

declare @NumberOfRechargesLimit int, -- initialize it to the number of recharges you want to view; in ur case it is 10

...

Things look weird here 😀

Can you please explain what you trying to get out the queries. It sure can be modified, but i need some information to test my solution.

Need to see the definition of the function to optimize it 🙂

btw, did my query solve ur query ? 😛

Well ,good luck , then 🙂 happy to have been a point on...

Bro ( or sis 😀 ) , BOTH matters. TOP needs ORDER BY to give consistent result.Period.

This?

SELECT

Name = FD.Name

,Fruit1 = MAX ( CASE WHEN IL.FruitID = 1 THEN FN.FruitNames ELSE NULL END )

...

The rows returned by SQL will never be ordered. If you an ordered list, you MUST explicitly use ORDER BY clause. The behavior u are seeing is an classic example...

How many fruits can one Distributor sell?

This?

SELECT * , NEWRATE = t1.AMOUNT * t2.VALUE

from [Fact table] t1

inner join [Exchange Rate table] t2

on t1.CURRENCY = t2.FOREIGN_CURR

and...