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: first release

v.0.0.1
Date: 3 years ago
Size: 404 bytes
 

Contents

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