SELECT DPPD.[RECEIPTNO],CASH.CASHDATE AS MAILDATE,'' AS BANKNAME,'' AS CHEQUENO,

'CASH' AS INSTTYPE,'' AS INSTDATED,'' AS BRANCHNAME, 'CASH' AS BATCHTYPE , DPPD.AMOUNT AS AMOUNT, DPPD.DONHEAD , ...

it is in datetime datatype but i need only date ....

tables 1 has more than 50 k records

tables 2 is a configuration table has 50 records.

ALTER FUNCTION [dbo].[GetDontionHeadsforAuditReceipts]

(

@receiptno NVARCHAR(32), @partnerid NVARCHAR(32) , @currdate NVARCHAR(32)

)

RETURNS NVARCHAR(MAX)

AS

BEGIN

DECLARE @r NVARCHAR(MAX)

...

DECLARE @r VARCHAR(MAX)

SELECT @r = ISNULL(@r+'/', '')

+ t2.col4 + ' - '...

Thank you very much for both of you ... both the queries are working fine

It is for top 3 .... for example of ties i've given one more row..... from that i want top three...

hi,

i dont want to skip ranks .... i want it like 1, 2, 2, 4, 5, 5, 7......

i want to use RANK() and get the results