Find Jobs
Hire Freelancers

SQL Server - Need fix on procedure problem

$20 CAD

In corso
Pubblicato circa 9 anni fa

$20 CAD

Pagato al completamento
Hello, I would need a fix in the below procedure. As this is urgent, this needs to be done in the next hour, I will be available on freelancer chat to test solution. Everytime I call(exec) it from T-SQL I get following error: Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0 Procedure: ============== CREATE PROC dbo.start_sash AS BEGIN set nocount on; declare @trancount int; set @trancount = @@trancount; BEGIN TRY if @trancount = 0 BEGIN TRANSACTION else save transaction start_sash; -- BEGIN TRANSACTION --BEGIN EXEC [intm_perf].dbo.initialize_sash_views EXEC [msdb].dbo.sp_update_job @job_name = N'JOB_GATHER_SASH_DATA_1', @enabled = 1; --END COMMIT; END TRY BEGIN CATCH declare @error int, @message varchar(4000), @xstate int; select @error = ERROR_NUMBER(), @message = ERROR_MESSAGE(), @xstate = XACT_STATE(); if @xstate = -1 rollback; if @xstate = 1 and @trancount = 0 rollback if @xstate = 1 and @trancount > 0 rollback transaction start_sash; INSERT INTO [intm_perf].dbo.error_log (ErrorProcedure, ErrorLine, ErrorNumber, ErrorMessage, ErrorSeverity, ErrorState) SELECT N'start_sash', ERROR_LINE(), ERROR_NUMBER(), ERROR_MESSAGE(), ERROR_SEVERITY(), ERROR_STATE() --raiserror ('usp_my_procedure_name: %d: %s', 16, 1, @error, @message) ; END CATCH END --PRINT 'Here 30' GO
Rif. progetto: 7490419

Info sul progetto

3 proposte
Progetto a distanza
Attivo 9 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
3 freelance hanno fatto un'offerta media di $20 CAD
Avatar dell'utente
Hello, I am very much interested to to fix the issue, i have strong knowledge on writing complex sql queries in ms sql server. I think i can solve this issue easily. Looking forward to have a positive response from you.
$20 CAD in 0 giorno
5,0 (181 valutazioni)
7,8
7,8
Avatar dell'utente
Between 2009 to Present, I worked as a web application, mobile application and desktop application developer for several employers. In terms of my accomplishments: MVC framework with Entity Framework in .net,Angular js and Yii in PHP. Expertise in mobile app development platform like Android, iPhone and Window 7/8. Excel VBA with macros. I have Strong knowledge in Asp.net, PHP, Word-Press, C#.net,Wpf, MVC,Angularjs,Razor, SQL server , MongoDB , MySql , Web Service , WCF Service , JavaScript , Ajax , Crystal Report , Dev Express , Telerik , HTML5, CSS3, Jquery , Bootstrap, VPS server management. I would welcome the opportunity to discuss my background in greater detail, and look forward to hearing from you. give me one chance to prove that. thanks You miss one statement in sql server procedure that i know very well...
$20 CAD in 1 giorno
5,0 (15 valutazioni)
6,7
6,7
Avatar dell'utente
Hello there, I would like to be considered for this job as I have great working experience in SQL SERVER development. Thanks, Ramesh
$20 CAD in 3 giorni
5,0 (4 valutazioni)
3,9
3,9

Info sul cliente

Bandiera: CANADA
Montreal, Canada
5,0
38
Metodo di pagamento verificato
Membro dal mar 7, 2015

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.