Usuário com melhor resposta
Query SQL

Pergunta
-
No Access eu tenho uma a expressão:
SELECT NUM_DTMedicao AS Data, NUM_PercExec AS [%], NUM_USAdicional AS Adic, NUM_USDesconto AS [Desc], NUM_USPaga AS Total,
NUM_PedidoCompra AS [P.Compra], TAG_Pago, IIf([T_NS_MedicaoServ]![Tag_Pago] = 0, [Não], [Sim]) AS Pago
FROM T_NS_MedicaoServ
WHERE (NUM_ID_NS = 53200)
ORDER BY NUM_DTMedicao DESCComo ficaria a mesma expressão no sql server 2000?
Respostas
-
Ivanenko, utilize o 'case'..
SELECT NUM_DTMedicao AS Data, NUM_PercExec AS [%], NUM_USAdicional AS Adic, NUM_USDesconto AS [Desc],
NUM_USPaga AS Total, NUM_PedidoCompra AS [P.Compra], TAG_Pago,
(case when T_NS_MedicaoServ.Tag_Pago = 0 then 'Não' else 'Sim' end) AS Pago
FROM T_NS_MedicaoServ
WHERE (NUM_ID_NS = 53200)
ORDER BY NUM_DTMedicao DESC
abraco!
-
Ivanenko,
segue um exemplo do próprio BOL, utilizando o banco Pubs...
USE pubs
GO
SELECT Category =
CASE type
WHEN 'popular_comp' THEN 'Popular Computing'
WHEN 'mod_cook' THEN 'Modern Cooking'
WHEN 'business' THEN 'Business'
WHEN 'psychology' THEN 'Psychology'
WHEN 'trad_cook' THEN 'Traditional Cooking'
ELSE 'Not yet categorized'
END,
CAST(title AS varchar(25)) AS 'Shortened Title',
price AS PriceFROM titles
WHERE price IS NOT NULL
ORDER BY type, price
COMPUTE AVG(price) BY type
qquer coisa, retorne..
abraco!
Todas as Respostas
-
Ivanenko, utilize o 'case'..
SELECT NUM_DTMedicao AS Data, NUM_PercExec AS [%], NUM_USAdicional AS Adic, NUM_USDesconto AS [Desc],
NUM_USPaga AS Total, NUM_PedidoCompra AS [P.Compra], TAG_Pago,
(case when T_NS_MedicaoServ.Tag_Pago = 0 then 'Não' else 'Sim' end) AS Pago
FROM T_NS_MedicaoServ
WHERE (NUM_ID_NS = 53200)
ORDER BY NUM_DTMedicao DESC
abraco!
-
-
Ivanenko,
segue um exemplo do próprio BOL, utilizando o banco Pubs...
USE pubs
GO
SELECT Category =
CASE type
WHEN 'popular_comp' THEN 'Popular Computing'
WHEN 'mod_cook' THEN 'Modern Cooking'
WHEN 'business' THEN 'Business'
WHEN 'psychology' THEN 'Psychology'
WHEN 'trad_cook' THEN 'Traditional Cooking'
ELSE 'Not yet categorized'
END,
CAST(title AS varchar(25)) AS 'Shortened Title',
price AS PriceFROM titles
WHERE price IS NOT NULL
ORDER BY type, price
COMPUTE AVG(price) BY type
qquer coisa, retorne..
abraco!