USE database
Go
/*================================================================================
Server:
DataBase:
Author:
Object:
Date:
Content:
================================================================================*/
CREATE PROCEDURE [dbo].[UP_RMA_UpdateCompanyCodeOfRMAMaster]
AS
BEGIN
SET NOCOUNT ON
IF NOT EXISTS(
SELECT TOP 1 1
FROM dbo.RMAMaster WITH(NOLOCK)
WHERE CompanyCode IS NULL
)
BEGIN
SELECT 'There is no record with null company code in RMAMaster.' as Result
RETURN
END
DECLARE @rows int
,@row_batch int
,@row_count int
SELECT
@rows = 0
,@row_batch = 2000
,@row_count = @row_batch
WHILE @row_count = @row_batch
BEGIN
UPDATE TOP(@row_batch) SVC2005.dbo.RMAMaster
SET CompanyCode=1003
WHERE
CompanyCode IS NULL
SELECT
@row_count = @@ROWCOUNT
,@rows = @rows + @row_count
RAISERROR('%d rows.', 10, 1, @rows) WITH NOWAIT
WAITFOR DELAY '00:00:10'
END
SELECT CAST(@rows AS VARCHAR(10)) + ' records are processed.' as Result
END