Datasets
Query(s)
SELECT s.BusinessEntityID, s.Name AS Store, ct.Name AS Title, p.FirstName, p.LastName, ph.PhoneNumber
FROM Sales.Store AS s INNER JOIN
Person.BusinessEntityContact AS bec ON bec.BusinessEntityID = s.BusinessEntityID INNER JOIN
Person.ContactType AS ct ON ct.ContactTypeID = bec.ContactTypeID INNER JOIN
Person.Person AS p ON p.BusinessEntityID = bec.PersonID INNER JOIN
Person.PersonPhone AS ph ON p.BusinessEntityID = ph.BusinessEntityID
WHERE (s.BusinessEntityID = @StoreID)
Query(s)
SELECT DISTINCT BusinessEntityID, Name as Store
FROM Sales.Store