I don't see any table type variable in SQL server 7. Are you talking about SQL server 2000 ?

When tried to use the statement,

DECLARE @TableVar TABLE(col_1 INT PRIMARY KEY, col_2...

Thanx bkelley for those excellent articles. They helped me a lot.

-Bheemsen

Thanx for the reply. See my entire stored procedure below:

BEGIN

Declare LU_AddCursor CURSOR LOCAL FAST_FORWARD for

SELECT living_unit_id

FROM LU_ADDRESS (nolock)

WHERE taper_code = @p_taper_cd

AND terminal_name = @p_terminal_name

...

ThomasRushton,

Thanx for your reply. I had tried with both Named Pipes and TCP/IP protocols and still getting the same error.

Any one has any idea as to why this problem occurs...

racosta,

Thanx for the reply. Looks like the problem is with my operating system. Mine is NT workstation. I think one should have NT server OS to have local database. I...

Steve and Prakash,

Your suggestions are wonderful. That's what "index analysis" also suggested. I am going to go with your suggestions.

Thanx..

-Bheem

Thanx..

Can you please send me the syntax on how to call a stored procedure from a trigger.

-Bheemsen

Hi,

I tried with the following modified version of the query.

SELECT wire_cntr_name, living_unit_id, wtn, id

FROM ff_lu_wtn as flw

Where wire_cntr_id = @v_wire_center and NOT exists

(SELECT *

FROM ff_lu_wtn a inner join...