What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI
ALTER PROCEDURE [dbo].[SP_Update_Exchanges] @fordate datetime AS BEGIN BEGIN TRAN TRAN_SP_Ex Declare @currencyid int Declare @currency nvarchar(50) Declare @referencerate decimal(18,6) Declare @buy decimal(18,6) Declare @sell decimal(18,6) SET NOCOUNT ON; select * from exchanges where systemdate = @fordate if @@rowcount <> 1 begin SELECT @currencyid=currencyid, @currency=currency, @referencerate=referencerate, @buy=buy, @sell=sell from exchanges where systemdate = datediff(day,1,@fordate) insert into exchanges (currencyid,currency,referencerate,buy,sell,systemdate) values (@currencyid,@currency,@referencerate,@buy,@sell,@fordate) end IF @@ERROR <> 0 ROLLBACK TRAN TRAN_SP_Ex ELSE COMMIT TRAN TRAN_SP_Ex END
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.