1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
| SET @Result='SELECT *
FROM
(
SELECT
ChauffeurID
,ChauffeurName
,Date
,tarra
,bruto
,(bruto-tarra) as Netto
FROM Clark.dbo.BakMove
where
ChauffeurID='+CAST(@Chauffeur AS varchar(10))
+' AND TotalStatus<>1
AND Bruto<>0
union
SELECT
ChauffeurID
,'+'''Total'''+' as ChauffeurName
,Max(Date) AS date
,sum(tarra)
,sum(bruto)
,(sum(bruto)-sum(tarra)) as Netto
FROM Clark.dbo.BakMove
where
ChauffeurID='+CAST(@Chauffeur AS varchar(10))
+' AND TotalStatus<>1
group by ChauffeurID
) AS T
order by Date'; |
