DELETE FROM [dbo].[dwdCustomer] WHERE (([strCustomerNo] = @Original_strCustomerNo) AND ((@IsNull_strCustomerName = 1 AND [strCustomerName] IS NULL) OR ([strCustomerName] = @Original_strCustomerName)) AND ((@IsNull_strSnellChannel = 1 AND [strSnellChannel] IS NULL) OR ([strSnellChannel] = @Original_strSnellChannel)) AND ((@IsNull_strSnellArea = 1 AND [strSnellArea] IS NULL) OR ([strSnellArea] = @Original_strSnellArea)) AND ((@IsNull_strSnellcwsireg = 1 AND [strSnellcwsireg] IS NULL) OR ([strSnellcwsireg] = @Original_strSnellcwsireg)) AND ((@IsNull_strSnellrepno = 1 AND [strSnellrepno] IS NULL) OR ([strSnellrepno] = @Original_strSnellrepno)) AND ((@IsNull_strSnellsupergroup = 1 AND [strSnellsupergroup] IS NULL) OR ([strSnellsupergroup] = @Original_strSnellsupergroup)) AND ((@IsNull_strSnellsupergroupName = 1 AND [strSnellsupergroupName] IS NULL) OR ([strSnellsupergroupName] = @Original_strSnellsupergroupName)) AND ((@IsNull_strSnellgrading = 1 AND [strSnellgrading] IS NULL) OR ([strSnellgrading] = @Original_strSnellgrading)) AND ((@IsNull_refRepID = 1 AND [refRepID] IS NULL) OR ([refRepID] = @Original_refRepID)) AND ((@IsNull_refRepBBID = 1 AND [refRepBBID] IS NULL) OR ([refRepBBID] = @Original_refRepBBID)) AND ((@IsNull_refRepDlxID = 1 AND [refRepDlxID] IS NULL) OR ([refRepDlxID] = @Original_refRepDlxID)) AND ((@IsNull_refRepLuxID = 1 AND [refRepLuxID] IS NULL) OR ([refRepLuxID] = @Original_refRepLuxID)) AND ((@IsNull_strRepName = 1 AND [strRepName] IS NULL) OR ([strRepName] = @Original_strRepName)) AND ((@IsNull_strRepNameBB = 1 AND [strRepNameBB] IS NULL) OR ([strRepNameBB] = @Original_strRepNameBB)) AND ((@IsNull_strRepNameDlx = 1 AND [strRepNameDlx] IS NULL) OR ([strRepNameDlx] = @Original_strRepNameDlx)) AND ((@IsNull_strRepNameLux = 1 AND [strRepNameLux] IS NULL) OR ([strRepNameLux] = @Original_strRepNameLux)) AND ((@IsNull_strChannelPrimary = 1 AND [strChannelPrimary] IS NULL) OR ([strChannelPrimary] = @Original_strChannelPrimary)) AND ((@IsNull_strChannelSecondary = 1 AND [strChannelSecondary] IS NULL) OR ([strChannelSecondary] = @Original_strChannelSecondary)) AND ((@IsNull_strSegmentPrimary = 1 AND [strSegmentPrimary] IS NULL) OR ([strSegmentPrimary] = @Original_strSegmentPrimary)) AND ((@IsNull_strSegmentSecondary = 1 AND [strSegmentSecondary] IS NULL) OR ([strSegmentSecondary] = @Original_strSegmentSecondary)) AND ((@IsNull_strType1 = 1 AND [strType1] IS NULL) OR ([strType1] = @Original_strType1)) AND ((@IsNull_strType2 = 1 AND [strType2] IS NULL) OR ([strType2] = @Original_strType2)) AND ((@IsNull_strGroupName = 1 AND [strGroupName] IS NULL) OR ([strGroupName] = @Original_strGroupName)) AND ((@IsNull_strKeyAccount = 1 AND [strKeyAccount] IS NULL) OR ([strKeyAccount] = @Original_strKeyAccount)) AND ((@IsNull_strPriceGroupCode = 1 AND [strPriceGroupCode] IS NULL) OR ([strPriceGroupCode] = @Original_strPriceGroupCode)) AND ((@IsNull_blnPromotionalAccounts = 1 AND [blnPromotionalAccounts] IS NULL) OR ([blnPromotionalAccounts] = @Original_blnPromotionalAccounts)) AND ((@IsNull_blnActive = 1 AND [blnActive] IS NULL) OR ([blnActive] = @Original_blnActive)) AND ((@IsNull_strCode = 1 AND [strCode] IS NULL) OR ([strCode] = @Original_strCode)) AND ((@IsNull_strBranch = 1 AND [strBranch] IS NULL) OR ([strBranch] = @Original_strBranch)) AND ((@IsNull_strSalesOffice = 1 AND [strSalesOffice] IS NULL) OR ([strSalesOffice] = @Original_strSalesOffice)) AND ((@IsNull_strRegion = 1 AND [strRegion] IS NULL) OR ([strRegion] = @Original_strRegion)) AND ((@IsNull_strSAPCode = 1 AND [strSAPCode] IS NULL) OR ([strSAPCode] = @Original_strSAPCode)) AND ((@IsNull_strRegionCode = 1 AND [strRegionCode] IS NULL) OR ([strRegionCode] = @Original_strRegionCode)) AND ((@IsNull_strRegionDesc = 1 AND [strRegionDesc] IS NULL) OR ([strRegionDesc] = @Original_strRegionDesc)) AND ((@IsNull_strRegionAccpacCode = 1 AND [strRegionAccpacCode] IS NULL) OR ([strRegionAccpacCode] = @Original_strRegionAccpacCode)) AND ((@IsNull_strRegionDesc2 = 1 AND [strRegionDesc2] IS NULL) OR ([strRegionDesc2] = @Original_strRegionDesc2)) AND ((@IsNull_strChannel = 1 AND [strChannel] IS NULL) OR ([strChannel] = @Original_strChannel)) AND ((@IsNull_strSegment = 1 AND [strSegment] IS NULL) OR ([strSegment] = @Original_strSegment)) AND ((@IsNull_strCountry = 1 AND [strCountry] IS NULL) OR ([strCountry] = @Original_strCountry)) AND ((@IsNull_strRegionOrder = 1 AND [strRegionOrder] IS NULL) OR ([strRegionOrder] = @Original_strRegionOrder))) INSERT INTO [dbo].[dwdCustomer] ([strCustomerNo], [strCustomerName], [strSnellChannel], [strSnellArea], [strSnellcwsireg], [strSnellrepno], [strSnellsupergroup], [strSnellsupergroupName], [strSnellgrading], [refRepID], [refRepBBID], [refRepDlxID], [refRepLuxID], [strRepName], [strRepNameBB], [strRepNameDlx], [strRepNameLux], [strChannelPrimary], [strChannelSecondary], [strSegmentPrimary], [strSegmentSecondary], [strType1], [strType2], [strGroupName], [strKeyAccount], [strPriceGroupCode], [blnPromotionalAccounts], [blnActive], [strCode], [strBranch], [strSalesOffice], [strRegion], [strSAPCode], [strRegionCode], [strRegionDesc], [strRegionAccpacCode], [strRegionDesc2], [strChannel], [strSegment], [strCountry], [strRegionOrder]) VALUES (@strCustomerNo, @strCustomerName, @strSnellChannel, @strSnellArea, @strSnellcwsireg, @strSnellrepno, @strSnellsupergroup, @strSnellsupergroupName, @strSnellgrading, @refRepID, @refRepBBID, @refRepDlxID, @refRepLuxID, @strRepName, @strRepNameBB, @strRepNameDlx, @strRepNameLux, @strChannelPrimary, @strChannelSecondary, @strSegmentPrimary, @strSegmentSecondary, @strType1, @strType2, @strGroupName, @strKeyAccount, @strPriceGroupCode, @blnPromotionalAccounts, @blnActive, @strCode, @strBranch, @strSalesOffice, @strRegion, @strSAPCode, @strRegionCode, @strRegionDesc, @strRegionAccpacCode, @strRegionDesc2, @strChannel, @strSegment, @strCountry, @strRegionOrder); SELECT strCustomerNo, strCustomerName, strSnellChannel, strSnellArea, strSnellcwsireg, strSnellrepno, strSnellsupergroup, strSnellsupergroupName, strSnellgrading, refRepID, refRepBBID, refRepDlxID, refRepLuxID, strRepName, strRepNameBB, strRepNameDlx, strRepNameLux, strChannelPrimary, strChannelSecondary, strSegmentPrimary, strSegmentSecondary, strType1, strType2, strGroupName, strKeyAccount, strPriceGroupCode, blnPromotionalAccounts, blnActive, strCode, strBranch, strSalesOffice, strRegion, strSAPCode, strRegionCode, strRegionDesc, strRegionAccpacCode, strRegionDesc2, strChannel, strSegment, strCountry, strRegionOrder FROM dwdCustomer WHERE (strCustomerNo = @strCustomerNo) SELECT strCustomerNo, strCustomerName, strSnellChannel, strSnellArea, strSnellcwsireg, strSnellrepno, strSnellsupergroup, strSnellsupergroupName, strSnellgrading, refRepID, refRepBBID, refRepDlxID, refRepLuxID, strRepName, strRepNameBB, strRepNameDlx, strRepNameLux, strChannelPrimary, strChannelSecondary, strSegmentPrimary, strSegmentSecondary, strType1, strType2, strGroupName, strKeyAccount, strPriceGroupCode, blnPromotionalAccounts, blnActive, strCode, strBranch, strSalesOffice, strRegion, strSAPCode, strRegionCode, strRegionDesc, strRegionAccpacCode, strRegionDesc2, strChannel, strSegment, strCountry, strRegionOrder FROM dbo.dwdCustomer UPDATE [dbo].[dwdCustomer] SET [strCustomerNo] = @strCustomerNo, [strCustomerName] = @strCustomerName, [strSnellChannel] = @strSnellChannel, [strSnellArea] = @strSnellArea, [strSnellcwsireg] = @strSnellcwsireg, [strSnellrepno] = @strSnellrepno, [strSnellsupergroup] = @strSnellsupergroup, [strSnellsupergroupName] = @strSnellsupergroupName, [strSnellgrading] = @strSnellgrading, [refRepID] = @refRepID, [refRepBBID] = @refRepBBID, [refRepDlxID] = @refRepDlxID, [refRepLuxID] = @refRepLuxID, [strRepName] = @strRepName, [strRepNameBB] = @strRepNameBB, [strRepNameDlx] = @strRepNameDlx, [strRepNameLux] = @strRepNameLux, [strChannelPrimary] = @strChannelPrimary, [strChannelSecondary] = @strChannelSecondary, [strSegmentPrimary] = @strSegmentPrimary, [strSegmentSecondary] = @strSegmentSecondary, [strType1] = @strType1, [strType2] = @strType2, [strGroupName] = @strGroupName, [strKeyAccount] = @strKeyAccount, [strPriceGroupCode] = @strPriceGroupCode, [blnPromotionalAccounts] = @blnPromotionalAccounts, [blnActive] = @blnActive, [strCode] = @strCode, [strBranch] = @strBranch, [strSalesOffice] = @strSalesOffice, [strRegion] = @strRegion, [strSAPCode] = @strSAPCode, [strRegionCode] = @strRegionCode, [strRegionDesc] = @strRegionDesc, [strRegionAccpacCode] = @strRegionAccpacCode, [strRegionDesc2] = @strRegionDesc2, [strChannel] = @strChannel, [strSegment] = @strSegment, [strCountry] = @strCountry, [strRegionOrder] = @strRegionOrder WHERE (([strCustomerNo] = @Original_strCustomerNo) AND ((@IsNull_strCustomerName = 1 AND [strCustomerName] IS NULL) OR ([strCustomerName] = @Original_strCustomerName)) AND ((@IsNull_strSnellChannel = 1 AND [strSnellChannel] IS NULL) OR ([strSnellChannel] = @Original_strSnellChannel)) AND ((@IsNull_strSnellArea = 1 AND [strSnellArea] IS NULL) OR ([strSnellArea] = @Original_strSnellArea)) AND ((@IsNull_strSnellcwsireg = 1 AND [strSnellcwsireg] IS NULL) OR ([strSnellcwsireg] = @Original_strSnellcwsireg)) AND ((@IsNull_strSnellrepno = 1 AND [strSnellrepno] IS NULL) OR ([strSnellrepno] = @Original_strSnellrepno)) AND ((@IsNull_strSnellsupergroup = 1 AND [strSnellsupergroup] IS NULL) OR ([strSnellsupergroup] = @Original_strSnellsupergroup)) AND ((@IsNull_strSnellsupergroupName = 1 AND [strSnellsupergroupName] IS NULL) OR ([strSnellsupergroupName] = @Original_strSnellsupergroupName)) AND ((@IsNull_strSnellgrading = 1 AND [strSnellgrading] IS NULL) OR ([strSnellgrading] = @Original_strSnellgrading)) AND ((@IsNull_refRepID = 1 AND [refRepID] IS NULL) OR ([refRepID] = @Original_refRepID)) AND ((@IsNull_refRepBBID = 1 AND [refRepBBID] IS NULL) OR ([refRepBBID] = @Original_refRepBBID)) AND ((@IsNull_refRepDlxID = 1 AND [refRepDlxID] IS NULL) OR ([refRepDlxID] = @Original_refRepDlxID)) AND ((@IsNull_refRepLuxID = 1 AND [refRepLuxID] IS NULL) OR ([refRepLuxID] = @Original_refRepLuxID)) AND ((@IsNull_strRepName = 1 AND [strRepName] IS NULL) OR ([strRepName] = @Original_strRepName)) AND ((@IsNull_strRepNameBB = 1 AND [strRepNameBB] IS NULL) OR ([strRepNameBB] = @Original_strRepNameBB)) AND ((@IsNull_strRepNameDlx = 1 AND [strRepNameDlx] IS NULL) OR ([strRepNameDlx] = @Original_strRepNameDlx)) AND ((@IsNull_strRepNameLux = 1 AND [strRepNameLux] IS NULL) OR ([strRepNameLux] = @Original_strRepNameLux)) AND ((@IsNull_strChannelPrimary = 1 AND [strChannelPrimary] IS NULL) OR ([strChannelPrimary] = @Original_strChannelPrimary)) AND ((@IsNull_strChannelSecondary = 1 AND [strChannelSecondary] IS NULL) OR ([strChannelSecondary] = @Original_strChannelSecondary)) AND ((@IsNull_strSegmentPrimary = 1 AND [strSegmentPrimary] IS NULL) OR ([strSegmentPrimary] = @Original_strSegmentPrimary)) AND ((@IsNull_strSegmentSecondary = 1 AND [strSegmentSecondary] IS NULL) OR ([strSegmentSecondary] = @Original_strSegmentSecondary)) AND ((@IsNull_strType1 = 1 AND [strType1] IS NULL) OR ([strType1] = @Original_strType1)) AND ((@IsNull_strType2 = 1 AND [strType2] IS NULL) OR ([strType2] = @Original_strType2)) AND ((@IsNull_strGroupName = 1 AND [strGroupName] IS NULL) OR ([strGroupName] = @Original_strGroupName)) AND ((@IsNull_strKeyAccount = 1 AND [strKeyAccount] IS NULL) OR ([strKeyAccount] = @Original_strKeyAccount)) AND ((@IsNull_strPriceGroupCode = 1 AND [strPriceGroupCode] IS NULL) OR ([strPriceGroupCode] = @Original_strPriceGroupCode)) AND ((@IsNull_blnPromotionalAccounts = 1 AND [blnPromotionalAccounts] IS NULL) OR ([blnPromotionalAccounts] = @Original_blnPromotionalAccounts)) AND ((@IsNull_blnActive = 1 AND [blnActive] IS NULL) OR ([blnActive] = @Original_blnActive)) AND ((@IsNull_strCode = 1 AND [strCode] IS NULL) OR ([strCode] = @Original_strCode)) AND ((@IsNull_strBranch = 1 AND [strBranch] IS NULL) OR ([strBranch] = @Original_strBranch)) AND ((@IsNull_strSalesOffice = 1 AND [strSalesOffice] IS NULL) OR ([strSalesOffice] = @Original_strSalesOffice)) AND ((@IsNull_strRegion = 1 AND [strRegion] IS NULL) OR ([strRegion] = @Original_strRegion)) AND ((@IsNull_strSAPCode = 1 AND [strSAPCode] IS NULL) OR ([strSAPCode] = @Original_strSAPCode)) AND ((@IsNull_strRegionCode = 1 AND [strRegionCode] IS NULL) OR ([strRegionCode] = @Original_strRegionCode)) AND ((@IsNull_strRegionDesc = 1 AND [strRegionDesc] IS NULL) OR ([strRegionDesc] = @Original_strRegionDesc)) AND ((@IsNull_strRegionAccpacCode = 1 AND [strRegionAccpacCode] IS NULL) OR ([strRegionAccpacCode] = @Original_strRegionAccpacCode)) AND ((@IsNull_strRegionDesc2 = 1 AND [strRegionDesc2] IS NULL) OR ([strRegionDesc2] = @Original_strRegionDesc2)) AND ((@IsNull_strChannel = 1 AND [strChannel] IS NULL) OR ([strChannel] = @Original_strChannel)) AND ((@IsNull_strSegment = 1 AND [strSegment] IS NULL) OR ([strSegment] = @Original_strSegment)) AND ((@IsNull_strCountry = 1 AND [strCountry] IS NULL) OR ([strCountry] = @Original_strCountry)) AND ((@IsNull_strRegionOrder = 1 AND [strRegionOrder] IS NULL) OR ([strRegionOrder] = @Original_strRegionOrder))); SELECT strCustomerNo, strCustomerName, strSnellChannel, strSnellArea, strSnellcwsireg, strSnellrepno, strSnellsupergroup, strSnellsupergroupName, strSnellgrading, refRepID, refRepBBID, refRepDlxID, refRepLuxID, strRepName, strRepNameBB, strRepNameDlx, strRepNameLux, strChannelPrimary, strChannelSecondary, strSegmentPrimary, strSegmentSecondary, strType1, strType2, strGroupName, strKeyAccount, strPriceGroupCode, blnPromotionalAccounts, blnActive, strCode, strBranch, strSalesOffice, strRegion, strSAPCode, strRegionCode, strRegionDesc, strRegionAccpacCode, strRegionDesc2, strChannel, strSegment, strCountry, strRegionOrder FROM dwdCustomer WHERE (strCustomerNo = @strCustomerNo) DELETE FROM [dbo].[fsrItem] WHERE (([ItemID] = @Original_ItemID) AND ([refRequisitionID] = @Original_refRequisitionID) AND (['ES'] = @Original_refBrandID) AND ([strProdCode] = @Original_strProdCode) AND ([intQuantity] = @Original_intQuantity) AND ([dblCost] = @Original_dblCost) AND ([dblTotal] = @Original_dblTotal)) INSERT INTO [dbo].[fsrItem] ([refRequisitionID], [refBrandID], [strProdCode], [intQuantity], [dblCost], [dblTotal]) VALUES (@refRequisitionID, @refBrandID, @strProdCode, @intQuantity, @dblCost, @dblTotal); SELECT ItemID, refRequisitionID, refBrandID, strProdCode, intQuantity, dblCost, dblTotal FROM fsrItem WHERE (ItemID = SCOPE_IDENTITY()) SELECT ItemID, refRequisitionID, refBrandID, strProdCode, intQuantity, dblCost, dblTotal FROM dbo.fsrItem UPDATE [dbo].[fsrItem] SET [refRequisitionID] = @refRequisitionID, [refBrandID] = @refBrandID, [strProdCode] = @strProdCode, [intQuantity] = @intQuantity, [dblCost] = @dblCost, [dblTotal] = @dblTotal WHERE (([ItemID] = @Original_ItemID) AND ([refRequisitionID] = @Original_refRequisitionID) AND ([refBrandID] = @Original_refBrandID) AND ([strProdCode] = @Original_strProdCode) AND ([intQuantity] = @Original_intQuantity) AND ([dblCost] = @Original_dblCost) AND ([dblTotal] = @Original_dblTotal)); SELECT ItemID, refRequisitionID, refBrandID, strProdCode, intQuantity, dblCost, dblTotal FROM fsrItem WHERE (ItemID = @ItemID) DELETE FROM [dbo].[fsrRequisition] WHERE (([RequisitionID] = @Original_RequisitionID) AND ([refUserID] = @Original_refUserID) AND ([refRequestTypeID] = @Original_refRequestTypeID) AND ([refManagerID] = @Original_refManagerID) AND ([refAlternateManagerID] = @Original_refAlternateManagerID) AND ([refExecutiveManagerID] = @Original_refExecutiveManagerID) AND ([dtDate] = @Original_dtDate) AND ((@IsNull_strRegion = 1 AND [strRegion] IS NULL) OR ([strRegion] = @Original_strRegion)) AND ((@IsNull_strExpense = 1 AND [strExpense] IS NULL) OR ([strExpense] = @Original_strExpense)) AND ([strBillToAccount] = @Original_strBillToAccount) AND ([strShipToAccount] = @Original_strShipToAccount) AND ((@IsNull_strContactPerson = 1 AND [strContactPerson] IS NULL) OR ([strContactPerson] = @Original_strContactPerson)) AND ([strContactNumber] = @Original_strContactNumber) AND ([blnDelivery] = @Original_blnDelivery) AND ([dtDelivereyDate] = @Original_dtDelivereyDate) AND ([strStatus] = @Original_strStatus) AND ([strInvoiceNumber] = @Original_strInvoiceNumber) AND ([strAuthorizedBy] = @Original_strAuthorizedBy) AND ([dtLastEdit] = @Original_dtLastEdit)) INSERT INTO [dbo].[fsrRequisition] ([refUserID], [refRequestTypeID], [refManagerID], [refAlternateManagerID], [refExecutiveManagerID], [dtDate], [strRegion], [strExpense], [strBillToAccount], [strShipToAccount], [txtRequestDetail], [strContactPerson], [strContactNumber], [blnDelivery], [dtDelivereyDate], [txtPhysicalAddress], [strStatus], [strInvoiceNumber], [strAuthorizedBy], [dtLastEdit]) VALUES (@refUserID, @refRequestTypeID, @refManagerID, @refAlternateManagerID, @refExecutiveManagerID, @dtDate, @strRegion, @strExpense, @strBillToAccount, @strShipToAccount, @txtRequestDetail, @strContactPerson, @strContactNumber, @blnDelivery, @dtDelivereyDate, @txtPhysicalAddress, @strStatus, @strInvoiceNumber, @strAuthorizedBy, @dtLastEdit); SELECT RequisitionID, refUserID, refRequestTypeID, refManagerID, refAlternateManagerID, refExecutiveManagerID, dtDate, strRegion, strExpense, strBillToAccount, strShipToAccount, txtRequestDetail, strContactPerson, strContactNumber, blnDelivery, dtDelivereyDate, txtPhysicalAddress, strStatus, strInvoiceNumber, strAuthorizedBy, dtLastEdit FROM fsrRequisition WHERE (RequisitionID = SCOPE_IDENTITY()) SELECT RequisitionID, refUserID, refRequestTypeID, refManagerID, refAlternateManagerID, refExecutiveManagerID, dtDate, strRegion, strExpense, strBillToAccount, strShipToAccount, txtRequestDetail, strContactPerson, strContactNumber, blnDelivery, dtDelivereyDate, txtPhysicalAddress, strStatus, strInvoiceNumber, strAuthorizedBy, dtLastEdit FROM dbo.fsrRequisition UPDATE [dbo].[fsrRequisition] SET [refUserID] = @refUserID, [refRequestTypeID] = @refRequestTypeID, [refManagerID] = @refManagerID, [refAlternateManagerID] = @refAlternateManagerID, [refExecutiveManagerID] = @refExecutiveManagerID, [dtDate] = @dtDate, [strRegion] = @strRegion, [strExpense] = @strExpense, [strBillToAccount] = @strBillToAccount, [strShipToAccount] = @strShipToAccount, [txtRequestDetail] = @txtRequestDetail, [strContactPerson] = @strContactPerson, [strContactNumber] = @strContactNumber, [blnDelivery] = @blnDelivery, [dtDelivereyDate] = @dtDelivereyDate, [txtPhysicalAddress] = @txtPhysicalAddress, [strStatus] = @strStatus, [strInvoiceNumber] = @strInvoiceNumber, [strAuthorizedBy] = @strAuthorizedBy, [dtLastEdit] = @dtLastEdit WHERE (([RequisitionID] = @Original_RequisitionID) AND ([refUserID] = @Original_refUserID) AND ([refRequestTypeID] = @Original_refRequestTypeID) AND ([refManagerID] = @Original_refManagerID) AND ([refAlternateManagerID] = @Original_refAlternateManagerID) AND ([refExecutiveManagerID] = @Original_refExecutiveManagerID) AND ([dtDate] = @Original_dtDate) AND ((@IsNull_strRegion = 1 AND [strRegion] IS NULL) OR ([strRegion] = @Original_strRegion)) AND ((@IsNull_strExpense = 1 AND [strExpense] IS NULL) OR ([strExpense] = @Original_strExpense)) AND ([strBillToAccount] = @Original_strBillToAccount) AND ([strShipToAccount] = @Original_strShipToAccount) AND ((@IsNull_strContactPerson = 1 AND [strContactPerson] IS NULL) OR ([strContactPerson] = @Original_strContactPerson)) AND ([strContactNumber] = @Original_strContactNumber) AND ([blnDelivery] = @Original_blnDelivery) AND ([dtDelivereyDate] = @Original_dtDelivereyDate) AND ([strStatus] = @Original_strStatus) AND ([strInvoiceNumber] = @Original_strInvoiceNumber) AND ([strAuthorizedBy] = @Original_strAuthorizedBy) AND ([dtLastEdit] = @Original_dtLastEdit)); SELECT RequisitionID, refUserID, refRequestTypeID, refManagerID, refAlternateManagerID, refExecutiveManagerID, dtDate, strRegion, strExpense, strBillToAccount, strShipToAccount, txtRequestDetail, strContactPerson, strContactNumber, blnDelivery, dtDelivereyDate, txtPhysicalAddress, strStatus, strInvoiceNumber, strAuthorizedBy, dtLastEdit FROM fsrRequisition WHERE (RequisitionID = @RequisitionID) DELETE FROM [dbo].[mstBrand] WHERE (([BrandID] = @Original_BrandID) AND ((@IsNull_refPrincipalID = 1 AND [refPrincipalID] IS NULL) OR ([refPrincipalID] = @Original_refPrincipalID)) AND ((@IsNull_refCompanyID = 1 AND [refCompanyID] IS NULL) OR ([refCompanyID] = @Original_refCompanyID)) AND ((@IsNull_refBrandManagerID = 1 AND [refBrandManagerID] IS NULL) OR ([refBrandManagerID] = @Original_refBrandManagerID)) AND ((@IsNull_refBrandManager2ID = 1 AND [refBrandManager2ID] IS NULL) OR ([refBrandManager2ID] = @Original_refBrandManager2ID)) AND ((@IsNull_refGroupingDailyID = 1 AND [refGroupingDailyID] IS NULL) OR ([refGroupingDailyID] = @Original_refGroupingDailyID)) AND ((@IsNull_refGroupingPrimaryID = 1 AND [refGroupingPrimaryID] IS NULL) OR ([refGroupingPrimaryID] = @Original_refGroupingPrimaryID)) AND ((@IsNull_refGroupingSecondaryID = 1 AND [refGroupingSecondaryID] IS NULL) OR ([refGroupingSecondaryID] = @Original_refGroupingSecondaryID)) AND ((@IsNull_strAccpacCode = 1 AND [strAccpacCode] IS NULL) OR ([strAccpacCode] = @Original_strAccpacCode)) AND ((@IsNull_strBrand = 1 AND [strBrand] IS NULL) OR ([strBrand] = @Original_strBrand)) AND ((@IsNull_strGroupCode = 1 AND [strGroupCode] IS NULL) OR ([strGroupCode] = @Original_strGroupCode)) AND ((@IsNull_strGroupAccounts = 1 AND [strGroupAccounts] IS NULL) OR ([strGroupAccounts] = @Original_strGroupAccounts)) AND ((@IsNull_brand2 = 1 AND [brand2] IS NULL) OR ([brand2] = @Original_brand2)) AND ((@IsNull_brandrebate = 1 AND [brandrebate] IS NULL) OR ([brandrebate] = @Original_brandrebate)) AND ((@IsNull_brandToolkit = 1 AND [brandToolkit] IS NULL) OR ([brandToolkit] = @Original_brandToolkit)) AND ((@IsNull_intLeadMonths = 1 AND [intLeadMonths] IS NULL) OR ([intLeadMonths] = @Original_intLeadMonths)) AND ((@IsNull_intMonthsCover = 1 AND [intMonthsCover] IS NULL) OR ([intMonthsCover] = @Original_intMonthsCover)) AND ((@IsNull_dblVariance = 1 AND [dblVariance] IS NULL) OR ([dblVariance] = @Original_dblVariance)) AND ((@IsNull_blnActive = 1 AND [blnActive] IS NULL) OR ([blnActive] = @Original_blnActive)) AND ((@IsNull_strLastUser = 1 AND [strLastUser] IS NULL) OR ([strLastUser] = @Original_strLastUser)) AND ((@IsNull_dtStamp = 1 AND [dtStamp] IS NULL) OR ([dtStamp] = @Original_dtStamp)) AND ([percBrandGrowth] = @Original_percBrandGrowth)) INSERT INTO [dbo].[mstBrand] ([refPrincipalID], [refCompanyID], [refBrandManagerID], [refBrandManager2ID], [refGroupingDailyID], [refGroupingPrimaryID], [refGroupingSecondaryID], [strAccpacCode], [strBrand], [strGroupCode], [strGroupAccounts], [brand2], [brandrebate], [brandToolkit], [intLeadMonths], [intMonthsCover], [dblVariance], [blnActive], [strLastUser], [dtStamp], [percBrandGrowth]) VALUES (@refPrincipalID, @refCompanyID, @refBrandManagerID, @refBrandManager2ID, @refGroupingDailyID, @refGroupingPrimaryID, @refGroupingSecondaryID, @strAccpacCode, @strBrand, @strGroupCode, @strGroupAccounts, @brand2, @brandrebate, @brandToolkit, @intLeadMonths, @intMonthsCover, @dblVariance, @blnActive, @strLastUser, @dtStamp, @percBrandGrowth); SELECT BrandID, refPrincipalID, refCompanyID, refBrandManagerID, refBrandManager2ID, refGroupingDailyID, refGroupingPrimaryID, refGroupingSecondaryID, strAccpacCode, strBrand, strGroupCode, strGroupAccounts, brand2, brandrebate, brandToolkit, intLeadMonths, intMonthsCover, dblVariance, blnActive, strLastUser, dtStamp, percBrandGrowth FROM mstBrand WHERE (BrandID = SCOPE_IDENTITY()) SELECT BrandID, refPrincipalID, refCompanyID, refBrandManagerID, refBrandManager2ID, refGroupingDailyID, refGroupingPrimaryID, refGroupingSecondaryID, strAccpacCode, strBrand, strGroupCode, strGroupAccounts, brand2, brandrebate, brandToolkit, intLeadMonths, intMonthsCover, dblVariance, blnActive, strLastUser, dtStamp, percBrandGrowth FROM dbo.mstBrand UPDATE [dbo].[mstBrand] SET [refPrincipalID] = @refPrincipalID, [refCompanyID] = @refCompanyID, [refBrandManagerID] = @refBrandManagerID, [refBrandManager2ID] = @refBrandManager2ID, [refGroupingDailyID] = @refGroupingDailyID, [refGroupingPrimaryID] = @refGroupingPrimaryID, [refGroupingSecondaryID] = @refGroupingSecondaryID, [strAccpacCode] = @strAccpacCode, [strBrand] = @strBrand, [strGroupCode] = @strGroupCode, [strGroupAccounts] = @strGroupAccounts, [brand2] = @brand2, [brandrebate] = @brandrebate, [brandToolkit] = @brandToolkit, [intLeadMonths] = @intLeadMonths, [intMonthsCover] = @intMonthsCover, [dblVariance] = @dblVariance, [blnActive] = @blnActive, [strLastUser] = @strLastUser, [dtStamp] = @dtStamp, [percBrandGrowth] = @percBrandGrowth WHERE (([BrandID] = @Original_BrandID) AND ((@IsNull_refPrincipalID = 1 AND [refPrincipalID] IS NULL) OR ([refPrincipalID] = @Original_refPrincipalID)) AND ((@IsNull_refCompanyID = 1 AND [refCompanyID] IS NULL) OR ([refCompanyID] = @Original_refCompanyID)) AND ((@IsNull_refBrandManagerID = 1 AND [refBrandManagerID] IS NULL) OR ([refBrandManagerID] = @Original_refBrandManagerID)) AND ((@IsNull_refBrandManager2ID = 1 AND [refBrandManager2ID] IS NULL) OR ([refBrandManager2ID] = @Original_refBrandManager2ID)) AND ((@IsNull_refGroupingDailyID = 1 AND [refGroupingDailyID] IS NULL) OR ([refGroupingDailyID] = @Original_refGroupingDailyID)) AND ((@IsNull_refGroupingPrimaryID = 1 AND [refGroupingPrimaryID] IS NULL) OR ([refGroupingPrimaryID] = @Original_refGroupingPrimaryID)) AND ((@IsNull_refGroupingSecondaryID = 1 AND [refGroupingSecondaryID] IS NULL) OR ([refGroupingSecondaryID] = @Original_refGroupingSecondaryID)) AND ((@IsNull_strAccpacCode = 1 AND [strAccpacCode] IS NULL) OR ([strAccpacCode] = @Original_strAccpacCode)) AND ((@IsNull_strBrand = 1 AND [strBrand] IS NULL) OR ([strBrand] = @Original_strBrand)) AND ((@IsNull_strGroupCode = 1 AND [strGroupCode] IS NULL) OR ([strGroupCode] = @Original_strGroupCode)) AND ((@IsNull_strGroupAccounts = 1 AND [strGroupAccounts] IS NULL) OR ([strGroupAccounts] = @Original_strGroupAccounts)) AND ((@IsNull_brand2 = 1 AND [brand2] IS NULL) OR ([brand2] = @Original_brand2)) AND ((@IsNull_brandrebate = 1 AND [brandrebate] IS NULL) OR ([brandrebate] = @Original_brandrebate)) AND ((@IsNull_brandToolkit = 1 AND [brandToolkit] IS NULL) OR ([brandToolkit] = @Original_brandToolkit)) AND ((@IsNull_intLeadMonths = 1 AND [intLeadMonths] IS NULL) OR ([intLeadMonths] = @Original_intLeadMonths)) AND ((@IsNull_intMonthsCover = 1 AND [intMonthsCover] IS NULL) OR ([intMonthsCover] = @Original_intMonthsCover)) AND ((@IsNull_dblVariance = 1 AND [dblVariance] IS NULL) OR ([dblVariance] = @Original_dblVariance)) AND ((@IsNull_blnActive = 1 AND [blnActive] IS NULL) OR ([blnActive] = @Original_blnActive)) AND ((@IsNull_strLastUser = 1 AND [strLastUser] IS NULL) OR ([strLastUser] = @Original_strLastUser)) AND ((@IsNull_dtStamp = 1 AND [dtStamp] IS NULL) OR ([dtStamp] = @Original_dtStamp)) AND ([percBrandGrowth] = @Original_percBrandGrowth)); SELECT BrandID, refPrincipalID, refCompanyID, refBrandManagerID, refBrandManager2ID, refGroupingDailyID, refGroupingPrimaryID, refGroupingSecondaryID, strAccpacCode, strBrand, strGroupCode, strGroupAccounts, brand2, brandrebate, brandToolkit, intLeadMonths, intMonthsCover, dblVariance, blnActive, strLastUser, dtStamp, percBrandGrowth FROM mstBrand WHERE (BrandID = @BrandID) DELETE FROM [dbo].[mstProduct] WHERE (([strProdCode] = @Original_strProdCode) AND ((@IsNull_refBrandID = 1 AND [refBrandID] IS NULL) OR ([refBrandID] = @Original_refBrandID)) AND ((@IsNull_strProductDesc = 1 AND [strProductDesc] IS NULL) OR ([strProductDesc] = @Original_strProductDesc)) AND ((@IsNull_intPack = 1 AND [intPack] IS NULL) OR ([intPack] = @Original_intPack)) AND ((@IsNull_intSize = 1 AND [intSize] IS NULL) OR ([intSize] = @Original_intSize)) AND ((@IsNull_dblPrice = 1 AND [dblPrice] IS NULL) OR ([dblPrice] = @Original_dblPrice)) AND ((@IsNull_strLongProdDesc = 1 AND [strLongProdDesc] IS NULL) OR ([strLongProdDesc] = @Original_strLongProdDesc)) AND ((@IsNull_strType = 1 AND [strType] IS NULL) OR ([strType] = @Original_strType)) AND ((@IsNull_strType2 = 1 AND [strType2] IS NULL) OR ([strType2] = @Original_strType2)) AND ((@IsNull_intShortCode = 1 AND [intShortCode] IS NULL) OR ([intShortCode] = @Original_intShortCode)) AND ((@IsNull_strPriceSeg = 1 AND [strPriceSeg] IS NULL) OR ([strPriceSeg] = @Original_strPriceSeg)) AND ((@IsNull_strCategory = 1 AND [strCategory] IS NULL) OR ([strCategory] = @Original_strCategory)) AND ((@IsNull_strCategory2 = 1 AND [strCategory2] IS NULL) OR ([strCategory2] = @Original_strCategory2)) AND ((@IsNull_blnActive = 1 AND [blnActive] IS NULL) OR ([blnActive] = @Original_blnActive)) AND ((@IsNull_dblFlat = 1 AND [dblFlat] IS NULL) OR ([dblFlat] = @Original_dblFlat)) AND ((@IsNull_cwsicat = 1 AND [cwsicat] IS NULL) OR ([cwsicat] = @Original_cwsicat)) AND ((@IsNull_strPrincipalMaterialRefNum = 1 AND [strPrincipalMaterialRefNum] IS NULL) OR ([strPrincipalMaterialRefNum] = @Original_strPrincipalMaterialRefNum)) AND ((@IsNull_strPrincipalProdDesc = 1 AND [strPrincipalProdDesc] IS NULL) OR ([strPrincipalProdDesc] = @Original_strPrincipalProdDesc)) AND ((@IsNull_strBottleBarcode = 1 AND [strBottleBarcode] IS NULL) OR ([strBottleBarcode] = @Original_strBottleBarcode)) AND ((@IsNull_strCaseBarcode = 1 AND [strCaseBarcode] IS NULL) OR ([strCaseBarcode] = @Original_strCaseBarcode)) AND ((@IsNull_strGiftboxBarcode = 1 AND [strGiftboxBarcode] IS NULL) OR ([strGiftboxBarcode] = @Original_strGiftboxBarcode)) AND ((@IsNull_intDisplayOrder = 1 AND [intDisplayOrder] IS NULL) OR ([intDisplayOrder] = @Original_intDisplayOrder)) AND ((@IsNull_strBrandVarietal = 1 AND [strBrandVarietal] IS NULL) OR ([strBrandVarietal] = @Original_strBrandVarietal)) AND ((@IsNull_dtStamp = 1 AND [dtStamp] IS NULL) OR ([dtStamp] = @Original_dtStamp)) AND ((@IsNull_strLastUser = 1 AND [strLastUser] IS NULL) OR ([strLastUser] = @Original_strLastUser)) AND ((@IsNull_strProdCodeArchive = 1 AND [strProdCodeArchive] IS NULL) OR ([strProdCodeArchive] = @Original_strProdCodeArchive)) AND ([blnQF] = @Original_blnQF)) INSERT INTO [dbo].[mstProduct] ([strProdCode], [refBrandID], [strProductDesc], [intPack], [intSize], [dblPrice], [strLongProdDesc], [strType], [strType2], [intShortCode], [strPriceSeg], [strCategory], [strCategory2], [blnActive], [dblFlat], [cwsicat], [strPrincipalMaterialRefNum], [strPrincipalProdDesc], [strBottleBarcode], [strCaseBarcode], [strGiftboxBarcode], [intDisplayOrder], [strBrandVarietal], [dtStamp], [strLastUser], [strProdCodeArchive], [blnQF]) VALUES (@strProdCode, @refBrandID, @strProductDesc, @intPack, @intSize, @dblPrice, @strLongProdDesc, @strType, @strType2, @intShortCode, @strPriceSeg, @strCategory, @strCategory2, @blnActive, @dblFlat, @cwsicat, @strPrincipalMaterialRefNum, @strPrincipalProdDesc, @strBottleBarcode, @strCaseBarcode, @strGiftboxBarcode, @intDisplayOrder, @strBrandVarietal, @dtStamp, @strLastUser, @strProdCodeArchive, @blnQF); SELECT strProdCode, refBrandID, strProductDesc, intPack, intSize, dblPrice, strLongProdDesc, strType, strType2, intShortCode, strPriceSeg, strCategory, strCategory2, blnActive, dblFlat, cwsicat, strPrincipalMaterialRefNum, strPrincipalProdDesc, strBottleBarcode, strCaseBarcode, strGiftboxBarcode, intDisplayOrder, strBrandVarietal, dtStamp, strLastUser, strProdCodeArchive, blnQF FROM mstProduct WHERE (strProdCode = @strProdCode) SELECT strProdCode, refBrandID, strProductDesc, intPack, intSize, dblPrice, strLongProdDesc, strType, strType2, intShortCode, strPriceSeg, strCategory, strCategory2, blnActive, dblFlat, cwsicat, strPrincipalMaterialRefNum, strPrincipalProdDesc, strBottleBarcode, strCaseBarcode, strGiftboxBarcode, intDisplayOrder, strBrandVarietal, dtStamp, strLastUser, strProdCodeArchive, blnQF FROM dbo.mstProduct UPDATE [dbo].[mstProduct] SET [strProdCode] = @strProdCode, [refBrandID] = @refBrandID, [strProductDesc] = @strProductDesc, [intPack] = @intPack, [intSize] = @intSize, [dblPrice] = @dblPrice, [strLongProdDesc] = @strLongProdDesc, [strType] = @strType, [strType2] = @strType2, [intShortCode] = @intShortCode, [strPriceSeg] = @strPriceSeg, [strCategory] = @strCategory, [strCategory2] = @strCategory2, [blnActive] = @blnActive, [dblFlat] = @dblFlat, [cwsicat] = @cwsicat, [strPrincipalMaterialRefNum] = @strPrincipalMaterialRefNum, [strPrincipalProdDesc] = @strPrincipalProdDesc, [strBottleBarcode] = @strBottleBarcode, [strCaseBarcode] = @strCaseBarcode, [strGiftboxBarcode] = @strGiftboxBarcode, [intDisplayOrder] = @intDisplayOrder, [strBrandVarietal] = @strBrandVarietal, [dtStamp] = @dtStamp, [strLastUser] = @strLastUser, [strProdCodeArchive] = @strProdCodeArchive, [blnQF] = @blnQF WHERE (([strProdCode] = @Original_strProdCode) AND ((@IsNull_refBrandID = 1 AND [refBrandID] IS NULL) OR ([refBrandID] = @Original_refBrandID)) AND ((@IsNull_strProductDesc = 1 AND [strProductDesc] IS NULL) OR ([strProductDesc] = @Original_strProductDesc)) AND ((@IsNull_intPack = 1 AND [intPack] IS NULL) OR ([intPack] = @Original_intPack)) AND ((@IsNull_intSize = 1 AND [intSize] IS NULL) OR ([intSize] = @Original_intSize)) AND ((@IsNull_dblPrice = 1 AND [dblPrice] IS NULL) OR ([dblPrice] = @Original_dblPrice)) AND ((@IsNull_strLongProdDesc = 1 AND [strLongProdDesc] IS NULL) OR ([strLongProdDesc] = @Original_strLongProdDesc)) AND ((@IsNull_strType = 1 AND [strType] IS NULL) OR ([strType] = @Original_strType)) AND ((@IsNull_strType2 = 1 AND [strType2] IS NULL) OR ([strType2] = @Original_strType2)) AND ((@IsNull_intShortCode = 1 AND [intShortCode] IS NULL) OR ([intShortCode] = @Original_intShortCode)) AND ((@IsNull_strPriceSeg = 1 AND [strPriceSeg] IS NULL) OR ([strPriceSeg] = @Original_strPriceSeg)) AND ((@IsNull_strCategory = 1 AND [strCategory] IS NULL) OR ([strCategory] = @Original_strCategory)) AND ((@IsNull_strCategory2 = 1 AND [strCategory2] IS NULL) OR ([strCategory2] = @Original_strCategory2)) AND ((@IsNull_blnActive = 1 AND [blnActive] IS NULL) OR ([blnActive] = @Original_blnActive)) AND ((@IsNull_dblFlat = 1 AND [dblFlat] IS NULL) OR ([dblFlat] = @Original_dblFlat)) AND ((@IsNull_cwsicat = 1 AND [cwsicat] IS NULL) OR ([cwsicat] = @Original_cwsicat)) AND ((@IsNull_strPrincipalMaterialRefNum = 1 AND [strPrincipalMaterialRefNum] IS NULL) OR ([strPrincipalMaterialRefNum] = @Original_strPrincipalMaterialRefNum)) AND ((@IsNull_strPrincipalProdDesc = 1 AND [strPrincipalProdDesc] IS NULL) OR ([strPrincipalProdDesc] = @Original_strPrincipalProdDesc)) AND ((@IsNull_strBottleBarcode = 1 AND [strBottleBarcode] IS NULL) OR ([strBottleBarcode] = @Original_strBottleBarcode)) AND ((@IsNull_strCaseBarcode = 1 AND [strCaseBarcode] IS NULL) OR ([strCaseBarcode] = @Original_strCaseBarcode)) AND ((@IsNull_strGiftboxBarcode = 1 AND [strGiftboxBarcode] IS NULL) OR ([strGiftboxBarcode] = @Original_strGiftboxBarcode)) AND ((@IsNull_intDisplayOrder = 1 AND [intDisplayOrder] IS NULL) OR ([intDisplayOrder] = @Original_intDisplayOrder)) AND ((@IsNull_strBrandVarietal = 1 AND [strBrandVarietal] IS NULL) OR ([strBrandVarietal] = @Original_strBrandVarietal)) AND ((@IsNull_dtStamp = 1 AND [dtStamp] IS NULL) OR ([dtStamp] = @Original_dtStamp)) AND ((@IsNull_strLastUser = 1 AND [strLastUser] IS NULL) OR ([strLastUser] = @Original_strLastUser)) AND ((@IsNull_strProdCodeArchive = 1 AND [strProdCodeArchive] IS NULL) OR ([strProdCodeArchive] = @Original_strProdCodeArchive)) AND ([blnQF] = @Original_blnQF)); SELECT strProdCode, refBrandID, strProductDesc, intPack, intSize, dblPrice, strLongProdDesc, strType, strType2, intShortCode, strPriceSeg, strCategory, strCategory2, blnActive, dblFlat, cwsicat, strPrincipalMaterialRefNum, strPrincipalProdDesc, strBottleBarcode, strCaseBarcode, strGiftboxBarcode, intDisplayOrder, strBrandVarietal, dtStamp, strLastUser, strProdCodeArchive, blnQF FROM mstProduct WHERE (strProdCode = @strProdCode) DELETE FROM [dbo].[mstUser] WHERE (([UserID] = @Original_UserID) AND ((@IsNull_refUserGroupID = 1 AND [refUserGroupID] IS NULL) OR ([refUserGroupID] = @Original_refUserGroupID)) AND ((@IsNull_refUserGroupSuperbowlID = 1 AND [refUserGroupSuperbowlID] IS NULL) OR ([refUserGroupSuperbowlID] = @Original_refUserGroupSuperbowlID)) AND ((@IsNull_refUserGroupForecastID = 1 AND [refUserGroupForecastID] IS NULL) OR ([refUserGroupForecastID] = @Original_refUserGroupForecastID)) AND ((@IsNull_refUserGroupPromotionID = 1 AND [refUserGroupPromotionID] IS NULL) OR ([refUserGroupPromotionID] = @Original_refUserGroupPromotionID)) AND ((@IsNull_refUserGroupScoreCardID = 1 AND [refUserGroupScoreCardID] IS NULL) OR ([refUserGroupScoreCardID] = @Original_refUserGroupScoreCardID)) AND ((@IsNull_refUserGroupFreeStockID = 1 AND [refUserGroupFreeStockID] IS NULL) OR ([refUserGroupFreeStockID] = @Original_refUserGroupFreeStockID)) AND ([refManagerID] = @Original_refManagerID) AND ([refManagerAlternativeID] = @Original_refManagerAlternativeID) AND ([refManagerExecutiveID] = @Original_refManagerExecutiveID) AND ((@IsNull_strUserName = 1 AND [strUserName] IS NULL) OR ([strUserName] = @Original_strUserName)) AND ((@IsNull_strPassword = 1 AND [strPassword] IS NULL) OR ([strPassword] = @Original_strPassword)) AND ((@IsNull_strDomainLogin = 1 AND [strDomainLogin] IS NULL) OR ([strDomainLogin] = @Original_strDomainLogin)) AND ((@IsNull_strEmail = 1 AND [strEmail] IS NULL) OR ([strEmail] = @Original_strEmail)) AND ([strRegion] = @Original_strRegion) AND ([blnManager] = @Original_blnManager) AND ([blnManagerExecutive] = @Original_blnManagerExecutive) AND ((@IsNull_strLastUser = 1 AND [strLastUser] IS NULL) OR ([strLastUser] = @Original_strLastUser)) AND ((@IsNull_dtStamp = 1 AND [dtStamp] IS NULL) OR ([dtStamp] = @Original_dtStamp))) INSERT INTO [dbo].[mstUser] ([refUserGroupID], [refUserGroupSuperbowlID], [refUserGroupForecastID], [refUserGroupPromotionID], [refUserGroupScoreCardID], [refUserGroupFreeStockID], [refManagerID], [refManagerAlternativeID], [refManagerExecutiveID], [strUserName], [strPassword], [strDomainLogin], [strEmail], [strRegion], [blnManager], [blnManagerExecutive], [strLastUser], [dtStamp]) VALUES (@refUserGroupID, @refUserGroupSuperbowlID, @refUserGroupForecastID, @refUserGroupPromotionID, @refUserGroupScoreCardID, @refUserGroupFreeStockID, @refManagerID, @refManagerAlternativeID, @refManagerExecutiveID, @strUserName, @strPassword, @strDomainLogin, @strEmail, @strRegion, @blnManager, @blnManagerExecutive, @strLastUser, @dtStamp); SELECT UserID, refUserGroupID, refUserGroupSuperbowlID, refUserGroupForecastID, refUserGroupPromotionID, refUserGroupScoreCardID, refUserGroupFreeStockID, refManagerID, refManagerAlternativeID, refManagerExecutiveID, strUserName, strPassword, strDomainLogin, strEmail, strRegion, blnManager, blnManagerExecutive, strLastUser, dtStamp FROM mstUser WHERE (UserID = SCOPE_IDENTITY()) SELECT UserID, refUserGroupID, refUserGroupSuperbowlID, refUserGroupForecastID, refUserGroupPromotionID, refUserGroupScoreCardID, refUserGroupFreeStockID, refManagerID, refManagerAlternativeID, refManagerExecutiveID, strUserName, strPassword, strDomainLogin, strEmail, strRegion, blnManager, blnManagerExecutive, strLastUser, dtStamp FROM dbo.mstUser UPDATE [dbo].[mstUser] SET [refUserGroupID] = @refUserGroupID, [refUserGroupSuperbowlID] = @refUserGroupSuperbowlID, [refUserGroupForecastID] = @refUserGroupForecastID, [refUserGroupPromotionID] = @refUserGroupPromotionID, [refUserGroupScoreCardID] = @refUserGroupScoreCardID, [refUserGroupFreeStockID] = @refUserGroupFreeStockID, [refManagerID] = @refManagerID, [refManagerAlternativeID] = @refManagerAlternativeID, [refManagerExecutiveID] = @refManagerExecutiveID, [strUserName] = @strUserName, [strPassword] = @strPassword, [strDomainLogin] = @strDomainLogin, [strEmail] = @strEmail, [strRegion] = @strRegion, [blnManager] = @blnManager, [blnManagerExecutive] = @blnManagerExecutive, [strLastUser] = @strLastUser, [dtStamp] = @dtStamp WHERE (([UserID] = @Original_UserID) AND ((@IsNull_refUserGroupID = 1 AND [refUserGroupID] IS NULL) OR ([refUserGroupID] = @Original_refUserGroupID)) AND ((@IsNull_refUserGroupSuperbowlID = 1 AND [refUserGroupSuperbowlID] IS NULL) OR ([refUserGroupSuperbowlID] = @Original_refUserGroupSuperbowlID)) AND ((@IsNull_refUserGroupForecastID = 1 AND [refUserGroupForecastID] IS NULL) OR ([refUserGroupForecastID] = @Original_refUserGroupForecastID)) AND ((@IsNull_refUserGroupPromotionID = 1 AND [refUserGroupPromotionID] IS NULL) OR ([refUserGroupPromotionID] = @Original_refUserGroupPromotionID)) AND ((@IsNull_refUserGroupScoreCardID = 1 AND [refUserGroupScoreCardID] IS NULL) OR ([refUserGroupScoreCardID] = @Original_refUserGroupScoreCardID)) AND ((@IsNull_refUserGroupFreeStockID = 1 AND [refUserGroupFreeStockID] IS NULL) OR ([refUserGroupFreeStockID] = @Original_refUserGroupFreeStockID)) AND ([refManagerID] = @Original_refManagerID) AND ([refManagerAlternativeID] = @Original_refManagerAlternativeID) AND ([refManagerExecutiveID] = @Original_refManagerExecutiveID) AND ((@IsNull_strUserName = 1 AND [strUserName] IS NULL) OR ([strUserName] = @Original_strUserName)) AND ((@IsNull_strPassword = 1 AND [strPassword] IS NULL) OR ([strPassword] = @Original_strPassword)) AND ((@IsNull_strDomainLogin = 1 AND [strDomainLogin] IS NULL) OR ([strDomainLogin] = @Original_strDomainLogin)) AND ((@IsNull_strEmail = 1 AND [strEmail] IS NULL) OR ([strEmail] = @Original_strEmail)) AND ([strRegion] = @Original_strRegion) AND ([blnManager] = @Original_blnManager) AND ([blnManagerExecutive] = @Original_blnManagerExecutive) AND ((@IsNull_strLastUser = 1 AND [strLastUser] IS NULL) OR ([strLastUser] = @Original_strLastUser)) AND ((@IsNull_dtStamp = 1 AND [dtStamp] IS NULL) OR ([dtStamp] = @Original_dtStamp))); SELECT UserID, refUserGroupID, refUserGroupSuperbowlID, refUserGroupForecastID, refUserGroupPromotionID, refUserGroupScoreCardID, refUserGroupFreeStockID, refManagerID, refManagerAlternativeID, refManagerExecutiveID, strUserName, strPassword, strDomainLogin, strEmail, strRegion, blnManager, blnManagerExecutive, strLastUser, dtStamp FROM mstUser WHERE (UserID = @UserID)