You said it will increase the performance if it is two different partition. What makes you tell that like is there any specific process that happens each time you do...

I planning to give a try with join Query.

Thanks for your reply, So Count will lead to performance issue. Right?

if yes Then the modification made my senior is not the solution.

Create procedure prcA

(

......

)

as

Begin

.......

.......

Alter table a

disable trigger atrigger

update a

set column1 = '200-525'

where .....

Alter table a

enable trigger atrigger

end

Question

1) will this really disable the trigger and enable it because I was...

I understand your point but my seniors wants it to be as sp's.

Their point is that function used recompile each everytime it is executed.So if SQL2000 doesn't support explicit table...

not more than 4 rows

my aim is to avoid passing too many output paramerters since I have around 250 columns.

Scenarios is like this I will have a main procedure like Proc1 inside that I...

Thanks ,

1) Without using dynamic SQL is it possible like passing it has sysvariable.

2) Is it possible to return a table output parameter from a procedure in SQL2005 or in...

Thanks Buddy,

Added to your point, Please go through the below give Microsoft Article.

FIX: Error messages when you run a query that references a view in SQL Server 2005 Service Pack...

Thanks Ken. Got the difference. Thanks again.

Can you explain what is "Adding any outer bits of the JOINs."

Excellent Article. Can u please tell about Image handling using BCP.It is really time consuming action to save the image in the db.