Hey, thanks for the reply.

The issue is that dept is dynamic, the user can pass value for deptno. depends on what user passes we need to get data for that...

Thanks for your reply. I have created a View as per your suggestion in schema binding. below is the code

ALTER VIEW PAA

With schemabinding

AS

SELECT

L_FUNDID,

L_trntype,

L_trndate,

L_description

FROM

DBO.PAA_ViewPostion

GROUP BY

However when I create an index...

As per the requirment there will be always more than one inserted in the table at one time.

I am still writting the code suggested by you. will post it soon.

I...

Thanks a ton i did work, last one thing for update is the table name updated?

Hello,

As per your suggestion adding the code SET FMTONLY OFF in the SP did resolve my problem thanks a lot.

Also do you have an example stating how can I use...

Hello, the second batch also takes by default the first set of collumns.

Do you have any idea, can we call three SP in one package to generate 3 DIFFERENT files?>

Hello, were you able to fix this issue? I am also facing the same issue.

Thanks for your help, the only option I see is to modify the code.

Changing the name of the duplicate column name will resolve the issue. However the same code works well in sql server 2000. As this is a production code and we...

This isn't a system SP.

The same code works in SQL Server 2000. Does that mean to make this SP work in 2008, I need to change the code i.e. either rename the column or...