Hi all,
We have stored procedure, which basically strips a header and footer of
a table (first and last line). The procedure is written like so:

CREATE procedure stage.usp_StripSMMT
as

declare @count int
declare @smmt_count int
declare @check char(3)

select @count = (select count(*) from stage.smmt_test)

select @smmt_count = (select substring(linein, 76, 5) from
stage.smmt_test
where pk = @count)

if (@count - @smmt_count) = 2
begin
delete from stage.smmt_test where pk in (1, @count)
end

GO

Ever since I accidently over wrote this (with exactly the same
procedure!) its suddenly stopped working!?

Any ideas would be most gratefully received.
Sam


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!