Information générale
Forum:
Microsoft SQL Server
Titre:
Iif statement in SQL 2000 select statement
Can this work?
the values in dbo.Made2ManageReport_v.antitip are R, L, B, N for right,
left, both, and none.
If this works can I use a case statement in a SQL statement.
SELECT
dbo.Made2ManageReport_v.fsono AS SalesOrderNumber,
dbo.Made2ManageReport_v.carriagetype,
dbo.Made2ManageReport_v.angle,
dbo.Made2ManageReport_v.channel,
dbo.Made2ManageReport_v.vendor,
dbo.Made2ManageReport_v.sections,
dbo.Made2ManageReport_v.passthrough,
dbo.Made2ManageReport_v.starter,
dbo.Made2ManageReport_v.adder,
dbo.Made2ManageReport_v.standar,
dbo.Made2ManageReport_v.xright,
=====> IIF(dbo.Made2ManageReport_v.antitip="R","RIGHT","LEFT") AS AntiTip,
dbo.Made2ManageReport_v.fcustpono,
dbo.Made2ManageReport_v.fenumber,
dbo.Made2ManageReport_v.fduedate,
dbo.Made2ManageReport_v.fbompart,
dbo.Made2ManageReport_v.fbomdesc AS Shaft
FROM
dbo.Made2ManageReport_v
LEFT OUTER JOIN
dbo.Shaft ON dbo.Made2ManageReport_v.fsono = dbo.Shaft.fsono
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement