the enterprise manager says version 8?

Nick

The first comment - I am inserting (a copy) in to the database, using insert into tbl_directdebits (....) select .... from tbl_directdebits where id=@id (the original record)

Second comment - there...

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author:Nick Ashton

-- Create date: 15/04/2013

-- Description:updates tbl_directdebits ready for next months payment

--

-- =============================================

ALTER PROCEDURE [dbo].[failedDD]

-- Add the parameters for the stored procedure here

@processdate datetime,...

There are no loops, I make an update to the original record, then copy it to another table, I then make another update to the original record, then the two...