The values in the Availability of Product column can be Available or Not Available. (Use the
AdventureWorks database)
select productID,iif(makeflag=1,'Available','NotAvailable')
as
AvailabilityOfProduct from Production.product
Thursday, 10 October 2013
17. Write a query to display a report that contains the Product ID and its availability status in the following format.
The values in the Availability of Product column can be Available or Not Available. (Use the
AdventureWorks database)
select productID,iif(makeflag=1,'Available','NotAvailable')
as
AvailabilityOfProduct from Production.product
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment