I got the required output. Please find below query
select
a.RequestId,a.ResolverGroup,a.datecreated RecvdDate
,lead(a.datecreated) over(order by a.datecreated) processdate Processdate
from Requestdetails a
AND b.StateName in ('Submitted','Assign To')
AND a.RequestId in (123)

Thanks for your solution.

It is working fine in Sql server 2005.

But problem is we are using Sql server 2000

Can provide me the soultion in Sql server 2000

regards

Prakash

Actuall i have 3 table StuffTbl,ContainerTbl,ContainerTypeTbl,

StuffTbl contians FormId,CreatedBy,POD Columns.

ContainerTbl Contains FormId,ContainerTypeId(Ref key ContainerTypeTbl),StuffId(Ref key StuffTbl),Remarks

ContainerTypeTbl contains continerid,Type.

StuffTbl data

FormIdCreatedByPOD

1Rocky ...

Thanks for your reply

Can i have output in one column rather than 3 colums

Solution for these is

CREATE FUNCTION dbo.fnMakeTeamList

( @TeamID int )

RETURNS varchar(1000)

AS

BEGIN

DECLARE @TempTeam table

...

Thanks a lot it is working

Thanks for your reply,

Is there any possiblity with any corelated query or subquery not by assinging to a variable

Dear All

I want the output in this way

Days No of.Requests

Mon 5

Tue 6

Wed 7

Thu 3

Fri 2

Sat 1

I will pass only the date to the query

Pls help me to solve this problem