I am using MS SQL Server 2012. I want to use this query in SSRS.
I have the following table:
Year Month AccNo Balance
2011 2 45 900
2011 3 45 700
2011 4 45 800
2011 1 50 20
2011 2 50 15
2011 3 50 40
I want to the following Division:
Balance of AccNo 45 / Balance of AccNo50
Where AccNo45.Year = AccNo50.Year
AND AccNo45.Month = AccNo50.Month
The Answer should be something like this:
Year Month Ratio
2011 2 900/15 (=60)
2011 3 800/40 (=20)
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.