Wednesday, 11 September 2013

11. Generate a report that contains the IDs of sales persons living in the territory with TerritoryID as 2 or 4. The report is required in the following format. (Use the AdventureWorks database)

select * from Sales.SalesOrderHeader
select 'sales person ID'=SalesPersonID,'Territory ID'=TerritoryID from Sales.SalesOrderHeader
where TerritoryID=2 or TerritoryID=4

No comments:

Post a Comment