Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT YEAR(CONVERT(DATE,OrderDATE))'Rok' ,
- (
- SELECT COUNT(CustomerID)
- FROM Sales.SalesOrderHeader
- WHERE MONTH(CONVERT(DATE,OrderDATE))=1 AND YEAR(CONVERT(DATE,OrderDATE)) = YEAR(CONVERT(DATE,res.OrderDate))
- )'1',
- (
- SELECT COUNT(CustomerID)
- FROM Sales.SalesOrderHeader
- WHERE MONTH(CONVERT(DATE,OrderDATE))=2 AND YEAR(CONVERT(DATE,OrderDATE)) = YEAR(CONVERT(DATE,res.OrderDate))
- )'2',
- (
- SELECT COUNT(CustomerID)
- FROM Sales.SalesOrderHeader
- WHERE MONTH(CONVERT(DATE,OrderDATE))=3 AND YEAR(CONVERT(DATE,OrderDATE)) = YEAR(CONVERT(DATE,res.OrderDate))
- )'3',
- (
- SELECT COUNT(CustomerID)
- FROM Sales.SalesOrderHeader
- WHERE MONTH(CONVERT(DATE,OrderDATE))=4 AND YEAR(CONVERT(DATE,OrderDATE)) = YEAR(CONVERT(DATE,res.OrderDate))
- )'4',
- (
- SELECT COUNT(CustomerID)
- FROM Sales.SalesOrderHeader
- WHERE MONTH(CONVERT(DATE,OrderDATE))=5 AND YEAR(CONVERT(DATE,OrderDATE)) = YEAR(CONVERT(DATE,res.OrderDate))
- )'5',
- (
- SELECT COUNT(CustomerID)
- FROM Sales.SalesOrderHeader
- WHERE MONTH(CONVERT(DATE,OrderDATE))=6 AND YEAR(CONVERT(DATE,OrderDATE)) = YEAR(CONVERT(DATE,res.OrderDate))
- )'6',
- (
- SELECT COUNT(CustomerID)
- FROM Sales.SalesOrderHeader
- WHERE MONTH(CONVERT(DATE,OrderDATE))=7 AND YEAR(CONVERT(DATE,OrderDATE)) = YEAR(CONVERT(DATE,res.OrderDate))
- )'7',
- (
- SELECT COUNT(CustomerID)
- FROM Sales.SalesOrderHeader
- WHERE MONTH(CONVERT(DATE,OrderDATE))=8 AND YEAR(CONVERT(DATE,OrderDATE)) = YEAR(CONVERT(DATE,res.OrderDate))
- )'8',
- (
- SELECT COUNT(CustomerID)
- FROM Sales.SalesOrderHeader
- WHERE MONTH(CONVERT(DATE,OrderDATE))=9 AND YEAR(CONVERT(DATE,OrderDATE)) = YEAR(CONVERT(DATE,res.OrderDate))
- )'9',
- (
- SELECT COUNT(CustomerID)
- FROM Sales.SalesOrderHeader
- WHERE MONTH(CONVERT(DATE,OrderDATE))=10 AND YEAR(CONVERT(DATE,OrderDATE)) = YEAR(CONVERT(DATE,res.OrderDate))
- )'10',
- (
- SELECT COUNT(CustomerID)
- FROM Sales.SalesOrderHeader
- WHERE MONTH(CONVERT(DATE,OrderDATE))=11 AND YEAR(CONVERT(DATE,OrderDATE)) = YEAR(CONVERT(DATE,res.OrderDate))
- )'11',
- (
- SELECT COUNT(CustomerID)
- FROM Sales.SalesOrderHeader
- WHERE MONTH(CONVERT(DATE,OrderDATE))=12 AND YEAR(CONVERT(DATE,OrderDATE)) = YEAR(CONVERT(DATE,res.OrderDate))
- )'12'
- FROM Sales.SalesOrderHeader res
- GROUP BY YEAR(CONVERT(DATE,OrderDATE))
- ORDER BY 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement