I got solution.

So mine query will be like this:

DECLARE @Tbl AS TABLE

(

pk_Id INT PRIMARY KEY NOT NULL IDENTITY(1,1),

tblId INT,

tblNo NVARCHAR(50),

dt_StartTime DATETIME,

dt_EndTime DATETIME

)

In that, there are multiple records with same...

Thanks for the reply.

About your comment,

3. In your setup record with PK=3 is: '19081,19078',1683

but in your expected results you want to see it as 19081, 1683. Am I right to...

Hi,

Thanks for the reply.

So I will post again and here is:

Table "tbl_Reservation" contains below rows.

CREATE TABLE #tbl_Reservation

(

...

Well Noted.

Thank you!

Guys,

Below one worked for me.

-- Itzik's VATN

CREATE FUNCTION dbo.fn_nums(@n AS bigint) RETURNS TABLE AS

RETURN

WITH

L0 AS(SELECT 1 AS c UNION ALL SELECT 1),

L1 AS(SELECT 1 AS c...

Hi,

I have slightly modified the query and it worked for me.

So query is:

UPDATE t1 SET sessionStTime = DATEADD(mi, RwNumber-1, sessionStTime)

FROM

(

SELECT sessionStTime,ROW_NUMBER() OVER (PARTITION by sessionStTime ORDER BY sessionStTime)...

There are above 50,000/ 1 Lac members. So do we need to create JOB and then schedule it? SO system will fire sp_send_dbmail from JOB?

Hi,

The link http://www.sql-server-performance.com/2006/email-functionality/ help me a lot.

Thanks

Thank you so much.

Guys, Finally i got query.

SELECT dt_BirthDate FROM tbl_MARC_MemberMaster G

WHERE ISNULL(dt_BirthDate,'')<>'' AND CONVERT(VARCHAR,dt_BirthDate,101)<>'01/01/1900'

AND 1 = (FLOOR(DATEDIFF(dd,G.dt_BirthDate,CONVERT(SMALLDATETIME,'06/15/2011')+DATEDIFF(dd,CONVERT(SMALLDATETIME,'01/05/2011'),CONVERT(SMALLDATETIME,'06/15/2011'))) / 365.25))

- (FLOOR(DATEDIFF(dd,G.dt_BirthDate,CONVERT(SMALLDATETIME,'06/15/2011')) / 365.25))

Chao.

Thanks my friend. Really nice.

Solved this query problem.

Sagar

Hi,

Please find out the attached screen shots from my original post.

Hi,

To get distinct with max try this.

select name,MAX(amount) AS MaxValue from #temp group by name having MAX(amount) <> 0

TP get distinct with last record of each user, amount and count:

if...

Hi

Are you talking about Data_Type?