Wednesday, 11 September 2013

3.Display the SalesPerson ID, the Territory ID, and the Sales Quota for those sales persons who have been assigned a sales quota. The data should be displayed in the following format. (Use the AdventureWorks database)






select * from Sales.SalesPerson
select 'sales Person Id'=salesPersonID,'Territory ID'=TerritoryID,'Sales Quota'=SalesQuota from Sales.SalesPerson
where SalesQuota is not Null




No comments:

Post a Comment