Sunday 6 October 2013

09. Write a query to display the total amount due for all the orders in the AdventureWorks database in the following format:







select 'Order value'=
'The total amount due for the sales Order ID:'+
Convert(varchar(10),salesOrderID)+
'is $'+ Convert(varchar(10),TotalDue)
from sales.salesOrderHeadre

No comments:

Post a Comment