hi karl,

yes i know that and my objective is to achieve it as single row.can these be concatenated and shown in the output? this columns output need to be dynamically...

can some help me in this please

Sir this does not work either.the description can be different for each claim id.so i gues it has be concatenated or what?.i think pivot can be used but my db...

yes i tried that but it gives the following as output

CLAIMID TOTAL AMT ...

Hi Wilfred,

yes d is one of the physical disk.i do have raid 5 with 2 logical partition,c & d.where else can i move it?also this is a new hardware.

Hi Ian,

thanks can you give me one another method and also how i can get only the time part from a date

Thanks Gila

no chance for duplicates

Hi,

Yes,dates can miss and it is not consecutive.Also dates are all midnight.

this is 2000 and its not homework.the first table is a sales table which gets updated w when a sale happnes.to arrive at the sale for a specific date I...

no PK and Indexes are there.

Ivan when i did as you said I get error

Server: Msg 245, Level 16, State 1, Line 1

Conversion failed when converting the varchar value '/' to data type int.

HI Andras

I get the following error

Msg 325, Level 15, State 1, Line 30

Incorrect syntax near 'PIVOT'. You may need to set the compatibility level of the current database to...

Andras,

how should the query be modified if 3&4 cust is also to be included as column in the output.

The query should fetch the all the visit-ids which is for another date like below for the sample data I gave.

Visit_Id Med_Id Date ...