Advertisement
Guest User

Untitled

a guest
Aug 20th, 2019
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. create table #PS
  2. (
  3. CountN nvarchar(80),
  4. Month nvarchar(80)
  5. );
  6.  
  7. INSERT INTO #PS
  8. VALUES
  9. ('1000', 'Jan'),
  10. ('1100', 'Feb'),
  11. ('1500', 'Mar'),
  12. ('3000', 'April');
  13.  
  14. CountN Month
  15. 1000 Jan
  16. 1100 Feb
  17. 1500 Mar
  18. 3000 April
  19.  
  20. CountN Month Variance Result
  21. 1000 Jan
  22. 1100 Feb 10% P
  23. 1500 Mar 36% F
  24. 3000 April 100% F
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement