[Code]

2010-01-05 00:00:00.000 120.0000002580.00 BHEL SRI SAI KIRAN2010-01-05 2580.000000

2010-01-05 00:00:00.000 120.0000002580.00 BHEL SRI SAI KIRAN2010-01-05 2580.000000

[/code]

I delete removed the null values and particular fields in the query and sending the values...

hi shahm

thanks for ur reply

i modified the query according to ur suggestions i'm getting the multiple records but i didnt get the batchno. and expirydate for that each item...

hi shahm

thanks for ur reply

iam designing a report by using this following query

declare @sampletab table

(

ItemName varchar(50),

MfrName varchar(50),

Batchno varchar(50),

Exprdate DateTime,

Quantity numeric(3),

Rate numeric(5),

vat numeric(3)

)

declare @ItemNo varchar(25)

declare @ItemName varchar(50)

declare @MfrName varchar(50)

declare @Batchno...