storedprocedure

Question

i have written a query in sp for update but am getting result as the new value is appended to the old value insted of the new vale why it happens?

Sukesh Marla · Answer

what do u mean by appended Please explain it properly dearthen only we can help.

Akkiraju Ivaturi · Answer

Please copy the stored procedure in word and then paste it. Otherwise the code cannot be understood.

anil john · Answer

This my sp: ALTER PROCEDURE dbo.sp_UserRights ( @iUserLevel int @vAddUser varchar(50) @vBalance varchar(50) @vBankofAccounts varchar(50) @vBranchMaster varchar(50) @vChittyAuction varchar(50) @vChittyGeneralReciept varchar(50) @vChittyInstallments varchar(50) @vChittyMaster varchar(50) @vChittyPayments varchar(50) @vChittyReciepts varchar(50) @vChittyRegistration varchar(50) @vChittyReport varchar(50) @vCompanyMaster varchar(50) @vContra varchar(50) @vCustomerLedger varchar(50) @vCustomerMaster varchar(50) @vDueList varchar(50) @vEmployeeMaster varchar(50) @vGeneralPayments varchar(50) @vGeneralReciept varchar(50) @vInstallmentCreation varchar(50) @vJournelEntry varchar(50) @vLogin varchar(50) @vMAGNA varchar(50) @vMAGNA_BRANCH varchar(50) @vPaymentDetails varchar(50) @vPrintBankAcc varchar(50) @vPrintPandL varchar(50) @vPrintTrailBalance varchar(50) @vReportAccountLedger varchar(50) @vUserPrevilege varchar(50) @vVoucherConfiguration varchar(50) @vVoucherListView varchar(50) @blockType int @TempID int ) AS SET NOCOUNT ON IF(@blockType=0) Begin IF EXISTS(SELECT * FROM tblUserRights WHERE iUserLevel=@iUserLevel AND TempID=@TempID) BEGIN RETURN END ELSE BEGIN INSERT INTO tblUserRights(iUserLevelvAddUservBalancevBankofAccountsvBranchMastervChittyAuctionvChittyGeneralReciept vChittyInstallmentsvChittyMastervChittyPaymentsvChittyRecieptsvChittyRegistration vChittyReportvCompanyMastervContravCustomerLedgervCustomerMastervDueListvEmployeeMaster vGeneralPaymentsvGeneralRecieptvInstallmentCreationvJournelEntryvLoginvMAGNAvMAGNA_BRANCH vPaymentDetailsvPrintBankAccvPrintPandLvPrintTrailBalancevReportAccountLedgervUserPrevilege vVoucherConfigurationvVoucherListView) VALUES(@iUserLevel@vAddUser@vBalance@vBankofAccounts@vBranchMaster@vChittyAuction@vChittyGeneralReciept @vChittyInstallments@vChittyMaster@vChittyPayments@vChittyReciepts @vChittyRegistration@vChittyReport@vCompanyMaster@vContra@vCustomerLedger@vCustomerMaster@vDueList @vEmployeeMaster@vGeneralPayments@vGeneralReciept@vInstallmentCreation@vJournelEntry@vLogin@vMAGNA @vMAGNA_BRANCH@vPaymentDetails@vPrintBankAcc@vPrintPandL@vPrintTrailBalance@vReportAccountLedger @vUserPrevilege@vVoucherConfiguration@vVoucherListView) RETURN END End ELSE IF(@blockType=1) Begin UPDATE tblUserRights SET vAddUser=@vAddUservBalance=@vBalancevBankofAccounts=@vBankofAccountsvBranchMaster=@vBranchMaster vChittyAuction=@vChittyAuctionvChittyGeneralReciept=@vChittyGeneralRecieptvChittyInstallments=@vChittyInstallments vChittyMaster=@vChittyMastervChittyPayments=@vChittyPaymentsvChittyReciepts=@vChittyReciepts vChittyRegistration=@vChittyRegistrationvChittyReport=@vChittyReportvCompanyMaster=@vCompanyMaster vContra=@vContravCustomerLedger=@vCustomerLedgervCustomerMaster=@vCustomerMastervDueList=@vDueList vEmployeeMaster=@vEmployeeMastervGeneralPayments=@vGeneralPaymentsvGeneralReciept=@vGeneralReciept vInstallmentCreation=@vInstallmentCreationvJournelEntry=@vJournelEntryvLogin=@vLoginvMAGNA=@vMAGNA vMAGNA_BRANCH=@vMAGNA_BRANCHvPaymentDetails=@vPaymentDetailsvPrintBankAcc=@vPrintBankAccvPrintPandL=@vPrintPandL vPrintTrailBalance=@vPrintTrailBalancevReportAccountLedger=@vReportAccountLedgervUserPrevilege=@vUserPrevilege vVoucherConfiguration=@vVoucherConfigurationvVoucherListView=@vVoucherListView WHERE iUserLevel=@iUserLevel AND TempID=@TempID SELECT @TempID As RowID End RETURN

Sukesh Marla · Answer

Can you please post query here?