USE <YourDatabaseName>
GO
CREATE PROCEDURE <YourProcedureName>
(
	<Optional list of parameters>
)
AS
BEGIN
    <Your code goes here>
END

USE [Sales]
GO
CREATE PROCEDURE [dbo].[DeleteOrderRecord]
(
	@LCF_DataPointer INT 
)
AS
BEGIN
	DECLARE @CF_SysCounter bigINT
	DECLARE @CF_NumLCFLines bigINT
	SET @CF_SysCounter = (SELECT TOP 1 CF_Datum FROM dbo.LCF_Data
		WHERE SysCounter = @LCF_DataPointer)
	DELETE FROM dbo.LCF_Data
		WHERE SysCounter = @LCF_DataPointer
	SET @CF_NumLCFLines = (SELECT TOP 1 SysCounter FROM LCF_Data
		WHERE CF_Datum = @CF_SysCounter)
	IF @CF_NumLCFLines IS NULL
		DELETE FROM dbo.CF_Data WHERE SysCounter = @CF_SysCounter
	RETURN @CF_NumLCFLines
END

INSERT INTO EXP_DATA_2
SELECT A.PERIOD, A.ACTUALITY, A.COMPANY, A.CURRENCY, B.CC_ACCOUNT,(B.SPLIT * A.AMOUNT)AMOUNT ,A.EXTDIM1,A.EXTDIM2,    A.EXTDIM3,A.EXTDIM4,A.JOURNAL_TYPE,A.C_COMPANY,A.C_DIM,A.TRANAMOUNT,A.TRANCURR,A.REGION,
           A.TRANSF_DATE
        FROM EXP_DATA AS A,
                CC_SPLIT AS B
WHERE A.COMPANY = B.COMPANY AND A.ACCOUNT = B.FUNC_ACCOUNT
AND A.PERIOD IN ('1102', '1103', '1104')

USE [Database]
GO
CREATE PROCEDURE [dbo].[Procedurename]
(
	@LCF_DataPointer INT 
)
AS
BEGIN
	SELECT A.PERIOD, A.ACTUALITY, A.COMPANY, A.CURRENCY, B.CC_ACCOUNT,(B.SPLIT * A.AMOUNT)AMOUNT ,A.EXTDIM1,A.EXTDIM2,    A.EXTDIM3,A.EXTDIM4,A.JOURNAL_TYPE,A.C_COMPANY,A.C_DIM,A.TRANAMOUNT,A.TRANCURR,A.REGION,
           A.TRANSF_DATE
        FROM EXP_DATA AS A,
                CC_SPLIT AS B
WHERE A.COMPANY = B.COMPANY AND A.ACCOUNT = B.FUNC_ACCOUNT
AND A.PERIOD IN ('1102', '1103', '1104')
END

USE [Database]

CREATE PROCEDURE [dbo].[Procedurename]
(
	@LCF_DataPointer INT 
)
AS

CREATE PROCEDURE [dbo].[YourProcedureName]

AS

(B.SPLIT * A.AMOUNT)AMOUNT ,

(B.SPLIT * A.AMOUNT) AS AMOUNT ,