hi remi

thanks for all your advice and helping..

kalpan

hi remi

did you got sometime to check the querry?????

insert into tblsortorder values (554,"NPTC",307," ")

insert into tblsortorder values (611,"MRI",314," ")

insert into tblcasedata values ("OMOR12233"," ","2180961","CHRISTOPHE","POLLARD"," ",1951-12-10 00:00:00,"M",3,2005-08-11 00:00:00,"OMOR12233"," ","611"," ",3,2005-08-11 15:15:00,2005-08-11 16:00:00,2005-08-11 17:15:00,2005-08-11 17:45:00,4,6,1,0,0,1,," ",2005-08-12 08:53:26.310000000,2005-08-12 08:53:27.043000000,"21"," "," ",0,"...

i dont want to insert anything i just want to show that in output..

can i do that...

thank you for support

TABLE DDL STATEMENTS

TBLCASEDATA

CREATE TABLE [tblCaseData] (

 [CaseID] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

 [SaturnPatientID] [int] NULL ,

 [MRN] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [FirstName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL...

Hi Remi

thanks for suggestion but i tried on development server but couldn't figure out how it could help in my scenario.

can you throw some light how can i use...

i cannot use update or create as this is on production server only i could use select then it would be useful

thankx

i have to do sequencing on the query below

select orroomname, tblsortorder.orroomno,atime, dtime, caseid from tblcasedata  inner join tblsortorder

on tblcasedata.orroomno= tblsortorder.orroomno

where dateofservice= '8/11/2005'

and tblsortorder.orroomno in ('611','554')

and qcstatus=4

order...