PHP Classes

File: SqlFunc/OrganizationTree.sql

Recommend this page to a friend!
  Classes of Andras Toth  >  SQL Proc Func  >  SqlFunc/OrganizationTree.sql  >  Download  
File: SqlFunc/OrganizationTree.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: SQL Proc Func
Run stored procedures and queries read from files
Author: By
Last change:
Date: 2 years ago
Size: 404 bytes


Class file image Download
 * This is a demo function using AdventureWorks2012 database
 * @SalariedFlag bit
 * @OrganizationLevel int
SELECT e.JobTitle
FROM HumanResources.Employee e
INNER JOIN Person.Person p ON e.BusinessEntityID = p.BusinessEntityID
WHERE e.SalariedFlag = ?
	AND e.OrganizationLevel >= ?
ORDER BY e.BusinessEntityID