Database Reference
In-Depth Information
dbo .[GetCLabel](dbo.[D3-s].CSalary)
CSalary, dbo.[GetCLabel]([dbo].
[GetTCLabel](4, dbo.[D2-u].CName, dbo.
[D2-u].CDept, dbo.[D3-s].CSalary)) TC
FROM dbo.[D2-u] JOIN
dbo.[D3-s] ON dbo.[D2-u].Name = dbo.[D3-s].Name
UNION
SELECT d b o.[D2-u].n am e, d b o.[G etCLa b el](d b o.[D2-u].C Nam e)
CName, dbo.[D2-u].Department, dbo.[GetCLabel](dbo.
[D2-u].C D ept) C D ept, d b o.[D3-ts].Salar y,
dbo .[GetCLabel](dbo.[D3-ts].CSalary)
CSalary, dbo.[GetCLabel]([dbo].
[GetTCLabel](4, dbo.[D2-u].CName, dbo.
[D2-u].CDept, dbo.[D3-ts].CSalary)) TC
FROM dbo.[D2-u] JOIN
dbo.[D3-ts] ON dbo.[D2-u].Name = dbo.
[D3-ts].Name
UNION
SELECT d b o.[D2-c].n am e, d b o.[G etCLa b el](d b o.[D2-c].C Nam e)
CName, dbo.[D2-c].Department, dbo.[GetCLabel](dbo.
[D2-c].C D ept) C D ept, d b o.[D3-u].Salar y,
dbo .[GetCLabel](dbo.[D3-u].CSalary)
CSalary, dbo.[GetCLabel]([dbo].
[GetTCLabel](4, dbo.[D2-c].CName, dbo.
[D2-c].CDept, dbo.[D3-u].CSalary)) TC
FROM dbo.[D2-c] JOIN
dbo.[D3-u] ON dbo.[D2-c].Name = dbo.
[D3-u].Name
UNION
SELECT d b o.[D2-c].n am e, d b o.[G etCLa b el](d b o.[D2-c].C Nam e)
CName, dbo.[D2-c].Department, dbo.[GetCLabel](dbo.
[D2-c].C D ept) C D ept, d b o.[D3-c].Salar y,
dbo .[GetCLabel](dbo.[D3-c].CSalary)
CSalary, dbo.[GetCLabel]([dbo].
[GetTCLabel](4, dbo.[D2-c].CName, dbo.
[D2-c].CDept, dbo.[D3-c].CSalary)) TC
FROM dbo.[D2-c] JOIN
dbo.[D3-c] ON dbo.[D2-c].Name = dbo.
[D3-c].Name
UNION
SELECT d b o.[D2-c].n am e, d b o.[G etCLa b el](d b o.[D2-c].C Nam e)
C Nam e, d b o.[D2-c].Depar tm e nt, d b o.[G etCLa b el]
(d b o.[D2-c].C D ept) C D ept, d b o.[D3-s].Salar y,
dbo .[GetCLabel](dbo.[D3-s].CSalary)
CSalary, dbo.[GetCLabel]([dbo].
Search WWH ::




Custom Search