Database Reference
In-Depth Information
and u.principal_id = m.
member_principal_id
and u.name = CURRENT_USER
return @Label
END
GO
Create FUNCTION [dbo].[GetTCLabel](@CID int,@CName
int,@CDept int,@CSalary int)
RETURNS int
AS
BEGIN
declare @TC int
select @TC = LabelID from dbo.SortLabels()
where Sort in (select min(Sort) from dbo.SortLabels()
where LabelID in (@CID,@CName,@CDept,@CSalary))
return @TC
END
GO
CREATE FUNCTION [dbo].[GetlBCLabe](@label int)
RETURNS nvarchar(10)
AS
BEGIN
declare @NewLabel nvarchar(10)
declare @ULabel nvarchar(1)
declare @CLabel nvarchar(1)
declare @SLabel nvarchar(1)
declare @TLabel nvarchar(1)
set @NewLabel = ''
set @ULabel = ''
set @CLabel = ''
set @SLabel = ''
set @TLabel = ''
set @ULabel = Cast(@label% 4 as nvarchar(1))
set @label = @label/4
set @CLabel = Cast(@label% 4 as nvarchar(1))
set @label = @label/4
set @SLabel = Cast(@label% 4 as nvarchar(1))
set @label = @label/4
set @TLabel = Cast(@label% 4 as nvarchar(1))
if @ULabel = '1'
set @NewLabel = @NewLabel+'-U'
else if @ULabel = '2'
set @NewLabel = @NewLabel+'U'
if @CLabel = '1'
set @NewLabel = @NewLabel+'-C'
Search WWH ::




Custom Search