"Erik" <erikg@pcslink.com> wrote in message
news:8-CdndqTu-2g8OHcRVn-3Q@comcast.com...
> I have SQL Similar to this:
>
> --Put new records in Table3
> Truncate Table Table3
> Insert into table3
> select * from STAGING where key1 not in (select distinct key1 from LIVE)
>
> It works fine in SQL Analyzer, but when I create a stored procedure with
the
> same Sql code in it, its related process has RID Locks like crazy and just
> hangs there...
>
> This make no sense to me. I've tried running it in a BEGIN TRAN-COMMIT
TRAN
> and not difference.
>
> Any idea why a stored proc would make a difference?
>
>

"Erik" <erikg@pcslink.com> wrote in message
news:8-CdndqTu-2g8OHcRVn-3Q@comcast.com...
>I have SQL Similar to this:
>
> --Put new records in Table3
> Truncate Table Table3
> Insert into table3
> select * from STAGING where key1 not in (select distinct key1 from LIVE)
>
> It works fine in SQL Analyzer, but when I create a stored procedure with
> the same Sql code in it, its related process has RID Locks like crazy and
> just hangs there...
>
> This make no sense to me. I've tried running it in a BEGIN TRAN-COMMIT
> TRAN and not difference.
>
> Any idea why a stored proc would make a difference?
>