-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathqueries_ventas.sql
More file actions
88 lines (64 loc) · 6.85 KB
/
Copy pathqueries_ventas.sql
File metadata and controls
88 lines (64 loc) · 6.85 KB
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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
select M.Vendedor, CAST(E.Fecha AS DATE) dia, sum(TotalNeto) as total from TOTALDOCUMENTO T, ENCABEZADOCUMENTO E, MSOCLIENTES M where TipoId = '06' and T.Id = E.Id and E.Vigente = 1 and E.Rut = M.Rut and E.Codigo = M.Codigo
and E.Fecha >='2016-01-01' and E.Fecha <='2016-12-31'
group by M.Vendedor, CAST(E.Fecha AS DATE)
order by M.Vendedor, CAST(E.Fecha AS DATE)
select M.Ruta, CAST(E.Fecha AS DATE) dia, sum(TotalNeto) as total from TOTALDOCUMENTO T, ENCABEZADOCUMENTO E, MSOCLIENTES M where TipoId = '06' and T.Id = E.Id and E.Vigente = 1 and E.Rut = M.Rut and E.Codigo = M.Codigo
and E.Fecha >='2016-01-01' and E.Fecha <='2016-12-31'
group by M.Ruta, CAST(E.Fecha AS DATE)
order by M.Ruta, CAST(E.Fecha AS DATE)
select M.Vendedor, M.Ruta, CAST(E.Fecha AS DATE) dia, sum(TotalNeto) as total from TOTALDOCUMENTO T, ENCABEZADOCUMENTO E, MSOCLIENTES M where TipoId = '06' and T.Id = E.Id and E.Vigente = 1 and E.Rut = M.Rut and E.Codigo = M.Codigo
and E.Fecha >='2016-01-01' and E.Fecha <='2016-12-31'
group by M.Vendedor, M.Ruta, CAST(E.Fecha AS DATE)
order by M.Vendedor, M.Ruta, CAST(E.Fecha AS DATE)
select M.Vendedor, DATEPART(YEAR, E.Fecha), DATEPART(week, E.Fecha) AS semana, sum(TotalNeto) as total from TOTALDOCUMENTO T, ENCABEZADOCUMENTO E, MSOCLIENTES M where TipoId = '06' and T.Id = E.Id and E.Vigente = 1 and E.Rut = M.Rut and E.Codigo = M.Codigo
and E.Fecha >='2016-01-01' and E.Fecha <='2016-12-31'
group by M.Vendedor, DATEPART(week, E.Fecha)
order by M.Vendedor, DATEPART(week, E.Fecha)
select M.Ruta, DATEPART(YEAR, E.Fecha), DATEPART(week, E.Fecha) AS semana, sum(TotalNeto) as total from TOTALDOCUMENTO T, ENCABEZADOCUMENTO E, MSOCLIENTES M where TipoId = '06' and T.Id = E.Id and E.Vigente = 1 and E.Rut = M.Rut and E.Codigo = M.Codigo
and E.Fecha >='2016-01-01' and E.Fecha <='2016-12-31'
group by M.Ruta, DATEPART(week, E.Fecha)
order by M.Ruta, DATEPART(week, E.Fecha)
select M.Vendedor, M.Ruta, DATEPART(YEAR, E.Fecha), DATEPART(week, E.Fecha) AS semana, sum(TotalNeto) as total from TOTALDOCUMENTO T, ENCABEZADOCUMENTO E, MSOCLIENTES M where TipoId = '06' and T.Id = E.Id and E.Vigente = 1 and E.Rut = M.Rut and E.Codigo = M.Codigo
and E.Fecha >='2016-01-01' and E.Fecha <='2017-12-31'
group by M.Vendedor, M.Ruta, DATEPART(YEAR, E.Fecha), DATEPART(week, E.Fecha)
order by M.Vendedor, M.Ruta, DATEPART(YEAR, E.Fecha), DATEPART(week, E.Fecha)
select M.Vendedor, DATEPART(YEAR, E.Fecha),DATEPART(MONTH, E.Fecha) AS mes, sum(TotalNeto) as total from TOTALDOCUMENTO T, ENCABEZADOCUMENTO E, MSOCLIENTES M where TipoId = '06' and T.Id = E.Id and E.Vigente = 1 and E.Rut = M.Rut and E.Codigo = M.Codigo
and E.Fecha >='2016-01-01' and E.Fecha <='2016-12-31'
group by M.Vendedor, DATEPART(YEAR, E.Fecha),DATEPART(MONTH, E.Fecha)
order by M.Vendedor, DATEPART(YEAR, E.Fecha),DATEPART(MONTH, E.Fecha)
select M.Ruta, DATEPART(YEAR, E.Fecha),DATEPART(MONTH, E.Fecha) AS mes, sum(TotalNeto) as total from TOTALDOCUMENTO T, ENCABEZADOCUMENTO E, MSOCLIENTES M where TipoId = '06' and T.Id = E.Id and E.Vigente = 1 and E.Rut = M.Rut and E.Codigo = M.Codigo
and E.Fecha >='2016-01-01' and E.Fecha <='2016-12-31'
group by M.Ruta, DATEPART(YEAR, E.Fecha),DATEPART(MONTH, E.Fecha)
order by M.Ruta, DATEPART(YEAR, E.Fecha),DATEPART(MONTH, E.Fecha)
select M.Vendedor, M.Ruta, DATEPART(YEAR, E.Fecha),DATEPART(MONTH, E.Fecha) AS mes, sum(TotalNeto) as total from TOTALDOCUMENTO T, ENCABEZADOCUMENTO E, MSOCLIENTES M where TipoId = '06' and T.Id = E.Id and E.Vigente = 1 and E.Rut = M.Rut and E.Codigo = M.Codigo
and E.Fecha >='2016-01-01' and E.Fecha <='2016-12-31'
group by M.Vendedor, M.Ruta, DATEPART(YEAR, E.Fecha),DATEPART(MONTH, E.Fecha)
order by M.Vendedor, M.Ruta, DATEPART(YEAR, E.Fecha),DATEPART(MONTH, E.Fecha)
select M.Vendedor, DATEPART(YEAR, E.Fecha), DATEPART(QUARTER, E.Fecha) AS trimestre, sum(TotalNeto) as total from TOTALDOCUMENTO T, ENCABEZADOCUMENTO E, MSOCLIENTES M where TipoId = '06' and T.Id = E.Id and E.Vigente = 1 and E.Rut = M.Rut and E.Codigo = M.Codigo
and E.Fecha >='2016-01-01' and E.Fecha <='2017-12-31'
group by M.Vendedor, DATEPART(YEAR, E.Fecha), DATEPART(QUARTER, E.Fecha)
order by M.Vendedor, DATEPART(YEAR, E.Fecha), DATEPART(QUARTER, E.Fecha)
select M.Ruta, DATEPART(YEAR, E.Fecha), DATEPART(QUARTER, E.Fecha) AS trimestre, sum(TotalNeto) as total from TOTALDOCUMENTO T, ENCABEZADOCUMENTO E, MSOCLIENTES M where TipoId = '06' and T.Id = E.Id and E.Vigente = 1 and E.Rut = M.Rut and E.Codigo = M.Codigo
and E.Fecha >='2016-01-01' and E.Fecha <='2016-12-31'
group by M.Ruta, DATEPART(YEAR, E.Fecha), DATEPART(QUARTER, E.Fecha)
order by M.Ruta, DATEPART(YEAR, E.Fecha), DATEPART(QUARTER, E.Fecha)
select M.Vendedor,M.Ruta, DATEPART(YEAR, E.Fecha), DATEPART(QUARTER, E.Fecha) AS trimestre, sum(TotalNeto) as total from TOTALDOCUMENTO T, ENCABEZADOCUMENTO E, MSOCLIENTES M where TipoId = '06' and T.Id = E.Id and E.Vigente = 1 and E.Rut = M.Rut and E.Codigo = M.Codigo
and E.Fecha >='2016-01-01' and E.Fecha <='2017-12-31'
group by M.Vendedor,M.Ruta, DATEPART(YEAR, E.Fecha), DATEPART(QUARTER, E.Fecha)
order by M.Vendedor,M.Ruta, DATEPART(YEAR, E.Fecha), DATEPART(QUARTER, E.Fecha)
select M.Vendedor, M.Ruta, CAST(E.Fecha AS DATE) dia, sum(TotalNeto) as total from TOTALDOCUMENTO T, ENCABEZADOCUMENTO E, MSOCLIENTES M where TipoId = '06' and T.Id = E.Id and E.Vigente = 1 and E.Rut = M.Rut and E.Codigo = M.Codigo
and E.Fecha >='2016-01-01' and E.Fecha <='2016-12-31'
group by M.Vendedor, M.Ruta, CAST(E.Fecha AS DATE)
order by M.Vendedor, M.Ruta, CAST(E.Fecha AS DATE)
select M.Vendedor, M.Ruta, DATEPART(YEAR, E.Fecha), DATEPART(week, E.Fecha) AS semana, sum(TotalNeto) as total from TOTALDOCUMENTO T, ENCABEZADOCUMENTO E, MSOCLIENTES M where TipoId = '06' and T.Id = E.Id and E.Vigente = 1 and E.Rut = M.Rut and E.Codigo = M.Codigo
and E.Fecha >='2016-01-01' and E.Fecha <='2017-12-31'
group by M.Vendedor, M.Ruta, DATEPART(YEAR, E.Fecha), DATEPART(week, E.Fecha)
order by M.Vendedor, M.Ruta, DATEPART(YEAR, E.Fecha), DATEPART(week, E.Fecha)
select M.Vendedor, DATEPART(YEAR, E.Fecha),DATEPART(MONTH, E.Fecha) AS mes, sum(TotalNeto) as total from TOTALDOCUMENTO T, ENCABEZADOCUMENTO E, MSOCLIENTES M where TipoId = '06' and T.Id = E.Id and E.Vigente = 1 and E.Rut = M.Rut and E.Codigo = M.Codigo
and E.Fecha >='2016-01-01' and E.Fecha <='2016-12-31'
group by M.Vendedor, DATEPART(YEAR, E.Fecha),DATEPART(MONTH, E.Fecha)
order by M.Vendedor, DATEPART(YEAR, E.Fecha),DATEPART(MONTH, E.Fecha)
select M.Vendedor,M.Ruta, DATEPART(YEAR, E.Fecha), DATEPART(QUARTER, E.Fecha) AS trimestre, sum(TotalNeto) as total from TOTALDOCUMENTO T, ENCABEZADOCUMENTO E, MSOCLIENTES M where TipoId = '06' and T.Id = E.Id and E.Vigente = 1 and E.Rut = M.Rut and E.Codigo = M.Codigo
and E.Fecha >='2016-01-01' and E.Fecha <='2017-12-31'
group by M.Vendedor,M.Ruta, DATEPART(YEAR, E.Fecha), DATEPART(QUARTER, E.Fecha)
order by M.Vendedor,M.Ruta, DATEPART(YEAR, E.Fecha), DATEPART(QUARTER, E.Fecha)