What type of file is that? (means like csv or ...)

Dave,

I am also looking for that type of job,

Would you please post the scripts and explain little more?.

Thanks.

Try this,

Put SET NOCOUNT ON at the beggining of stored procedure

SET NOCOUNT OFF at the ending of stored procedure

Thanks, it worked.

Thanks for your response,

I did follow the sswords idea, it worked for me.

Thank you!, it worked.

Try This,

set @v_Query = @v_Query + ' si.Order_Date > ''' + CONVERT(CHAR(10),@ServiceCallStartDate,101) + ''''

Thanks,

BABITA,

I think your code is for Oracle.

Dave,

Unfortunatly i cannot change the table structure, you mentioned that you had a program for this, could you please tell me hints how can...

Thanks Murthy it worked.

Thanks.

Thanks for your reply, but i want to pass temp table from one stored procedure to another.

yes, there is a firewall

it's windows 2000, sp 4 and sql 2k sp 3

Could you please post the error message.

David,

Let me explain my problem here

CREATE TABLE TEMP

(ID INT,

stdate DATETIME,

CODE CHAR(10))

INSERT INTO TEMP VALUES(1,'2004-04-01','TEST1')

INSERT INTO TEMP VALUES(2,'2004-04-02','TEST1')

INSERT INTO TEMP VALUES(3,'2004-04-03','TEST1')

INSERT INTO TEMP VALUES(4,'2004-04-01','TEST2')

INSERT INTO TEMP VALUES(5,'2004-04-02','TEST2')

INSERT INTO TEMP VALUES(6,'2004-04-03','TEST2')

INSERT...