RBA

SQL Monitor sinusoidal test metric

RBA
Dec 6th, 2011
137
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.32 KB | None | 0 0
  1. DECLARE @c CHAR
  2. DECLARE @i INT
  3. DECLARE @mod INT
  4. SET @c = 'a'
  5. SET @i = 1
  6. SET @mod = 0
  7. WHILE(@c <> '')
  8. BEGIN
  9. SELECT @c = SUBSTRING(DB_NAME() ,@i,1)
  10. SET @i = @i + 1
  11. SET @mod = (@mod+CAST(CAST(@c AS VARBINARY(1)) AS INT))%60
  12. END
  13.  
  14. SELECT  (SIN(((CAST(datepart(mi, getdate()) AS INT) + @mod)%60)/60.0*2*3.1415926)+1)*50
  15.  
Advertisement
Add Comment
Please, Sign In to add comment