Ankitware is a platform where you get NIIT dumps fully solved!!!!! NIIT Lab At Home ;
NIIT Pmr ,NIIT cycle test, Window app.
Contact:ankitware@gmail.com.
Monday 7 October 2013
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 SalesPersonID as 'Sales Person ID',
TerritoryID as 'Territory ID',
SalesQuota as 'Sales Quota' from Sales.SalesPerson
show sales person ID,sales quota,bonus,commission, saled this year,last year name, territory name, --counrty region code for all sales persons. Hint: use tables Sales.SalesPerson & Sales.SalesTerritory
show sales person ID,sales quota,bonus,commission, saled this year,last year name, territory name,
ReplyDelete--counrty region code for all sales persons. Hint: use tables Sales.SalesPerson & Sales.SalesTerritory
Great tips and very easy to understand. This will definitely be very useful for me when I get a chance to start my blog. קורס מכירות
ReplyDelete