Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
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
Join the community of 500,000 technology professionals and ask your questions.