Blogger For you

Blogger For you:
IP Address : 83.110.137.104
Ads Title : Sample PDO Connection sql server on php
Country : Trik dan teknik
Description : Yesterday Date
select
[date],
DATENAME(day, date) AS DaysNo,
DATENAME(WEEKDAY, [date]) AS Days,
amount
FROM dbo.DailySales
WHERE ([date] BETWEEN getdate() - 2 AND getdate())
ORDER BY [date] DESC

Total Sales Sample
SELECT
SUM(amount) AS CurrentSales

FROM dbo.DailySales

Sample Target
SELECT



Target=case when 2000000000-(select sum(amount) FROM dbo.DailySales) <= 0 then
'Yes' else 'No' end

Sample By Month


SELECT
YEAR(date) AS [Year],
MONTH(date) AS [Month],
DATENAME(MONTH, date) AS [Month Name],
sum(amount) AS [Sales Amount]
FROM dbo.DailySales
GROUP BY YEAR(date), MONTH(date), DATENAME(MONTH, date)
ORDER BY YEAR(date), MONTH(date)

Sample Progress Remaining
SELECT
RemainingAmount=2000000000-(select sum(amount) FROM dbo.DailySales),
TotalSales=(select sum(amount) FROM dbo.DailySales),
TargetStatus=case when 2000000000-(select sum(amount) FROM dbo.DailySales) <= 0
then 'Yes' else 'No' end

Name : Teknik Informatika
Email : anaktki9@gmail.com