Thanks problem is sloved.

Thanks Robert.

Yes I understand what you say.I tried many ways but did not get the output the way I wanted.

At last I could find a way to append the string...

Prevoiusly I posted the same doubt and got few suggestions. I tried them but did not help.

Any way I could find a way to append the string value and now...

I got the solution.But I want small modification.I want to create temporary table.When I am trying to exec the Stored Procedure for the 1st time it gave me the correct...

My Stored Procedure is given below

----------------------------------------------------------------

CREATE PROCEDURE financeReport

(

 @StartDate  smalldatetime=null,

 @EndDate  smalldatetime=null

)

AS

BEGIN

 SET NOCOUNT ON

 ---------------------------------------------------

 -- Declare and Set local variables

 ---------------------------------------------------

 DECLARE @ComCode  varchar(5)

 DECLARE @CustID   varchar(15)

 DECLARE @CustName  varchar(255)

 DECLARE @ShipCity  varchar(150)

 DECLARE @Company  varchar(150)

 DECLARE @Company1  varchar(150)

 DECLARE @Company2  varchar(150)

 DECLARE @CommissionRate  float

 DECLARE @PercOfCommission varchar(10)

 DECLARE @PercOfCommission1 float

 DECLARE @PercOfCommission2 float

 DECLARE @LineTotal  float

 DECLARE @Commission  varchar(255)

 DECLARE @IVNO   nvarchar(6)

 DECLARE @IVSTATE  nvarchar(10)

 DECLARE...

Thanks For your suggestion.Yes you are right I would use data as read only to generate the Excel report using string builder looping for each row.Yes I want to use...

Hi,

Thanks a lot for your response!! I'll try this and let you know if any problems..

Regards,

Alice.