Sorry I thought that you might have think array string as SP,please find Stored Procedure below...
USE [STHDB]
GO
/****** Object: StoredProcedure [dbo].[SPInsertXMLData] Script Date: 08/10/2012 21:23:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SPInsertXMLData]
@OutletCode nvarchar(3)=null,
@OutletDailySalesDate datetime=null,
@ReferenceNo nvarchar(10)=null,
@TransactionTime datetime=null,
@NonNettSalesItem nvarchar(10)=null,
@NettSalesItem nvarchar(10)=null,
@AmountBeforeSalesItemDiscount decimal(18,2)=null,
@AmountAfterSalesItemDiscount decimal(18,2)=null,
@SalesDiscountPercentage nvarchar(10)=null,
@SalesDiscountValue nvarchar(10)=null,
@SalesDiscountAll nvarchar(10)=null,
@AmountAfterTotalDiscount decimal(18,2)=null,
@ServiceTypeChargeInValue nvarchar(10)=null,
@GovernmentTaxChargeInValue nvarchar(10)=null,
@SalesGrandTotal decimal(18,2)=null,
@SalesGrandTotalRounding decimal(18,2)=null,
@VATSales nvarchar(10)=null,
@VATExemptSales nvarchar(10)=null,
@VATZeroRatedSales nvarchar(10)=null,
@VATAmount decimal(18,2)=null,
@CashPayment nvarchar(10)=null,
@CreditCardPayment nvarchar(10)=null,
@CreditorAccountPayment nvarchar(10)=null,
@CashVoucherPayment nvarchar(10)=null,
@MemberID nvarchar(20)=null,
@CreatedBy nvarchar(50)=null
AS
BEGIN
if exists(select * from tbl_Transactions where ReferenceNo=@ReferenceNo)
Return 0
else
begin
INSERT INTO [tbl_Transactions]
([OutletCode]
,[OutletDailySalesDate]
,[ReferenceNo]
,[TransactionTime]
,[NonNettSalesItem]
,[NettSalesItem]
,[AmountBeforeSalesItemDiscount]
,[AmountAfterSalesItemDiscount]
,[SalesDiscountPercentage]
,[SalesDiscountValue]
,[SalesDiscountAll]
,[AmountAfterTotalDiscount]
,[ServiceTypeChargeInValue]
,[GovernmentTaxChargeInValue]
,[SalesGrandTotal]
,[SalesGrandTotalRounding]
,[VATSales]
,[VATExemptSales]
,[VATZeroRatedSales]
,[VATAmount]
,[CashPayment]
,[CreditCardPayment]
,[CreditorAccountPayment]
,[CashVoucherPayment]
,[MemberID]
,[CreatedBy]
,[CreatedDate]
)
VALUES
(@OutletCode
,@OutletDailySalesDate
,@ReferenceNo
,@TransactionTime
,@NonNettSalesItem
,@NettSalesItem
,@AmountBeforeSalesItemDiscount
,@AmountAfterSalesItemDiscount
,@SalesDiscountPercentage
,@SalesDiscountValue
,@SalesDiscountAll
,@AmountAfterTotalDiscount
,@ServiceTypeChargeInValue
,@GovernmentTaxChargeInValue
,@SalesGrandTotal
,@SalesGrandTotalRounding
,@VATSales
,@VATExemptSales
,@VATZeroRatedSales
,@VATAmount
,@CashPayment
,@CreditCardPayment
,@CreditorAccountPayment
,@CashVoucherPayment
,@MemberID
,@CreatedBy
,GETDATE())
RETURN SCOPE_IDENTITY()
END
end