Help with Sql Server queries

Question

Help with Sql Server queries

Navigation

#1 by (3 votes)

0

I have my following questions:

SELECT T0.ItemCode as Codigo,T0.ItemName as Descripción,  
sum(Convert(int,A.VPiezas)) as Cantidad, sum(Convert(money, 
(A.VPiezas)))/sum(Convert(money,(A.VPiezas))) as PrecioU 
FROM OITM T0
INNER JOIN OITT T1 ON T0.[ItemCode] = T1.[Code] 
INNER JOIN ITT1 T2 ON T1.[Code] = T2.[Father] 
INNER JOIN OITM T3 ON T2.[Code] = T3.[ItemCode] 
INNER JOIN [Ventas_catavina].dbo.SVenta A ON T3.ItemCode = Codigo1   
COLLATE SQL_Latin1_General_CP850_CI_AS
WHERE T0.TreeType = 'T' and T3.ItmsGrpCod in (111)
group by T0.ItemCode, T0.ItemName
union
SELECT T3.ItemCode as Codigo, T3.ItemName as 
Descripción,sum(Convert(int,A.VKilos)) as Cantidad, null as PrecioU
FROM OITM T0
INNER JOIN OITT T1 ON T0.[ItemCode] = T1.[Code]
INNER JOIN ITT1 T2 ON T1.[Code] = T2.[Father] 
INNER JOIN OITM T3 ON T2.[Code] = T3.[ItemCode]
INNER JOIN [Ventas_catavina].dbo.SVenta A ON T3.ItemCode = Codigo1   
COLLATE SQL_Latin1_General_CP850_CI_AS 
WHERE T0.TreeType = 'T' and T3.ItmsGrpCod in (111)
group by T3.ItemCode, T3.ItemName

And they give me back:

What I want is for the row with the null value to appear below and not above.

sql-server

asked by Elizabeth 02.07.2018 в 20:34

source

1 answer

Get the fourth number of numbers separated by; with regular expressions java How to continue setInterval after having stopped it

score 3 · Accepted Answer

Try adding a ORDER BY like this:

SELECT T0.ItemCode as Codigo,T0.ItemName as Descripción,  
sum(Convert(int,A.VPiezas)) as Cantidad, sum(Convert(money, 
(A.VPiezas)))/sum(Convert(money,(A.VPiezas))) as PrecioU 
FROM OITM T0
INNER JOIN OITT T1 ON T0.[ItemCode] = T1.[Code] 
INNER JOIN ITT1 T2 ON T1.[Code] = T2.[Father] 
INNER JOIN OITM T3 ON T2.[Code] = T3.[ItemCode] 
INNER JOIN [Ventas_catavina].dbo.SVenta A ON T3.ItemCode = Codigo1   
COLLATE SQL_Latin1_General_CP850_CI_AS
WHERE T0.TreeType = 'T' and T3.ItmsGrpCod in (111)
group by T0.ItemCode, T0.ItemName
union
SELECT T3.ItemCode as Codigo, T3.ItemName as 
Descripción,sum(Convert(int,A.VKilos)) as Cantidad, null as PrecioU
FROM OITM T0
INNER JOIN OITT T1 ON T0.[ItemCode] = T1.[Code]
INNER JOIN ITT1 T2 ON T1.[Code] = T2.[Father] 
INNER JOIN OITM T3 ON T2.[Code] = T3.[ItemCode]
INNER JOIN [Ventas_catavina].dbo.SVenta A ON T3.ItemCode = Codigo1   
COLLATE SQL_Latin1_General_CP850_CI_AS 
WHERE T0.TreeType = 'T' and T3.ItmsGrpCod in (111)
group by T3.ItemCode, T3.ItemName
ORDER BY PrecioU DESC