Hai,

Here is equivalent converted code.

IF OBJECT_ID

('SPR_DWI_MKT_BRTMOVR') IS NULL

DROP PROCEDURE SPR_DWI_MKT_BRTMOVR

GO

CREATE PROCEDURE dbo.SPR_DWI_MKT_BRTMOVR

@AD_BEGIN_DATE DATETIME ,

@AD_END_DATE DATETIME

AS

SET NOCOUNT ON

/************************************ PART 1 NEW WO INFO...