Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT TOP (1) [t0].[sysid], [t0].[ACDGroupNumber], [t0].[WorkGroupID], [t0].[IsSpecial], [t0].[Description], [t0].[CreatedOn], [t0].[CreatedByID], [t0].[UpdatedOn], [t0].[UpdatedByID], [t0].[SkillName], [t0].[RoutingPolicy], [t0].[SkillCode], [t0].[Priority], [t0].[ATT], [t0].[ACW], [t0].[ASA], [t0].[Threshold], [t0].[Probability], [t0].[Tolerance], [t0].[AbandonPercentage], [t0].[SkillLevel], [t0].[ImportID], [t0].[SiteID], [t0].[HandleOverflowCalls], [t0].[OverflowQueueTime], [t0].[Outbound]
- FROM [dbo].[ACDGroups] AS [t0]
- WHERE ([t0].[sysid]) = @p0
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT [t0].[sysid], [t0].[WorkGroupName], [t0].[TimeIncriments], [t0].[BusinessWeekEnding], [t0].[HoursOfOperationStart], [t0].[HoursOfOperationEnd], [t0].[ASA], [t0].[Threshold], [t0].[Probability], [t0].[ATT], [t0].[ACW], [t0].[Smoothing], [t0].[FullTimeShift], [t0].[SUNDAY], [t0].[MONDAY], [t0].[TUESDAY], [t0].[WEDNESDAY], [t0].[THURSDAY], [t0].[FRIDAY], [t0].[SATURDAY], [t0].[MaxHrBetweenSchedule], [t0].[Tolerance], [t0].[Abandon], [t0].[AHT], [t0].[Efficiency], [t0].[PrimaryMembersOnly], [t0].[SUNDAYFrom], [t0].[SUNDAYTo], [t0].[MONDAYFrom], [t0].[MONDAYTo], [t0].[TUESDAYFrom], [t0].[TUESDAYTo], [t0].[WEDNESDAYFrom], [t0].[WEDNESDAYTo], [t0].[THURSDAYFrom], [t0].[THURSDAYTo], [t0].[FRIDAYFrom], [t0].[FRIDAYTo], [t0].[SATURDAYFrom], [t0].[SATURDAYTo], [t0].[GroupCode], [t0].[PilotID], [t0].[CreatedOn], [t0].[CreatedByID], [t0].[UpdatedOn], [t0].[UpdatedByID], [t0].[StartUpSiteID], [t0].[PrimarySiteID], [t0].[SUNDAY1], [t0].[SUNDAY2], [t0].[SUNDAY3], [t0].[MONDAY1], [t0].[MONDAY2], [t0].[MONDAY3], [t0].[TUESDAY1], [t0].[TUESDAY2], [t0].[TUESDAY3], [t0].[WEDNESDAY1], [t0].[WEDNESDAY2], [t0].[WEDNESDAY3], [t0].[THURSDAY1], [t0].[THURSDAY2], [t0].[THURSDAY3], [t0].[FRIDAY1], [t0].[FRIDAY2], [t0].[FRIDAY3], [t0].[SATURDAY1], [t0].[SATURDAY2], [t0].[SATURDAY3]
- FROM [dbo].[WorkGroups] AS [t0]
- WHERE [t0].[sysid] = @p0
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [8]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM (
- SELECT [t2].[sysid]
- FROM [dbo].[CallHistoryDaily] AS [t0]
- LEFT OUTER JOIN (
- SELECT 1 AS [test], [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[ACDGroups] AS [t1]
- ) AS [t2] ON [t2].[sysid] = [t0].[ACDGroupID]
- LEFT OUTER JOIN [dbo].[WorkGroups] AS [t3] ON [t3].[sysid] = [t2].[WorkGroupID]
- WHERE ([t0].[ACDGroupID] IN (@p0, @p1)) AND ([t0].[CallDate] >= @p2) AND ([t0].[CallDate] < @p3) AND (((CONVERT(Int,(CONVERT(Float,CONVERT(BigInt,(((CONVERT(BigInt,DATEDIFF(DAY, [t0].[CallDate], @p4))) * 86400000) + DATEDIFF(MILLISECOND, DATEADD(DAY, DATEDIFF(DAY, [t0].[CallDate], @p4), [t0].[CallDate]), @p4)) * 10000))) / 864000000000)) % @p5) = @p6)
- GROUP BY [t2].[test], [t2].[sysid], [t2].[ACDGroupNumber], [t2].[WorkGroupID], [t2].[IsSpecial], [t2].[Description], [t2].[CreatedOn], [t2].[CreatedByID], [t2].[UpdatedOn], [t2].[UpdatedByID], [t2].[SkillName], [t2].[RoutingPolicy], [t2].[SkillCode], [t2].[Priority], [t2].[ATT], [t2].[ACW], [t2].[ASA], [t2].[Threshold], [t2].[Probability], [t2].[Tolerance], [t2].[AbandonPercentage], [t2].[SkillLevel], [t2].[ImportID], [t2].[SiteID], [t2].[HandleOverflowCalls], [t2].[OverflowQueueTime], [t2].[Outbound]
- ) AS [t4]
- WHERE @p7 = [t4].[sysid]
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input DateTime (Size = 0; Prec = 0; Scale = 0) [1/1/2007 12:00:00 AM]
- -- @p3: Input DateTime (Size = 0; Prec = 0; Scale = 0) [1/2/2011 12:00:00 AM]
- -- @p4: Input DateTime (Size = 0; Prec = 0; Scale = 0) [5/14/2010 12:00:00 AM]
- -- @p5: Input Int (Size = 0; Prec = 0; Scale = 0) [7]
- -- @p6: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p7: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM (
- SELECT [t2].[sysid]
- FROM [dbo].[CallHistoryDaily] AS [t0]
- LEFT OUTER JOIN (
- SELECT 1 AS [test], [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[ACDGroups] AS [t1]
- ) AS [t2] ON [t2].[sysid] = [t0].[ACDGroupID]
- LEFT OUTER JOIN [dbo].[WorkGroups] AS [t3] ON [t3].[sysid] = [t2].[WorkGroupID]
- WHERE ([t0].[ACDGroupID] IN (@p0, @p1)) AND ([t0].[CallDate] >= @p2) AND ([t0].[CallDate] < @p3) AND (((CONVERT(Int,(CONVERT(Float,CONVERT(BigInt,(((CONVERT(BigInt,DATEDIFF(DAY, [t0].[CallDate], @p4))) * 86400000) + DATEDIFF(MILLISECOND, DATEADD(DAY, DATEDIFF(DAY, [t0].[CallDate], @p4), [t0].[CallDate]), @p4)) * 10000))) / 864000000000)) % @p5) = @p6)
- GROUP BY [t2].[test], [t2].[sysid], [t2].[ACDGroupNumber], [t2].[WorkGroupID], [t2].[IsSpecial], [t2].[Description], [t2].[CreatedOn], [t2].[CreatedByID], [t2].[UpdatedOn], [t2].[UpdatedByID], [t2].[SkillName], [t2].[RoutingPolicy], [t2].[SkillCode], [t2].[Priority], [t2].[ATT], [t2].[ACW], [t2].[ASA], [t2].[Threshold], [t2].[Probability], [t2].[Tolerance], [t2].[AbandonPercentage], [t2].[SkillLevel], [t2].[ImportID], [t2].[SiteID], [t2].[HandleOverflowCalls], [t2].[OverflowQueueTime], [t2].[Outbound]
- ) AS [t4]
- WHERE @p7 = [t4].[sysid]
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input DateTime (Size = 0; Prec = 0; Scale = 0) [1/1/2007 12:00:00 AM]
- -- @p3: Input DateTime (Size = 0; Prec = 0; Scale = 0) [1/2/2011 12:00:00 AM]
- -- @p4: Input DateTime (Size = 0; Prec = 0; Scale = 0) [5/14/2010 12:00:00 AM]
- -- @p5: Input Int (Size = 0; Prec = 0; Scale = 0) [7]
- -- @p6: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p7: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT [t5].[test], [t5].[sysid], [t5].[ACDGroupNumber], [t5].[WorkGroupID], [t5].[IsSpecial], [t5].[Description], [t5].[CreatedOn], [t5].[CreatedByID], [t5].[UpdatedOn], [t5].[UpdatedByID], [t5].[SkillName], [t5].[RoutingPolicy], [t5].[SkillCode], [t5].[Priority], [t5].[ATT], [t5].[ACW], [t5].[ASA], [t5].[Threshold], [t5].[Probability], [t5].[Tolerance], [t5].[AbandonPercentage], [t5].[SkillLevel], [t5].[ImportID], [t5].[SiteID], [t5].[HandleOverflowCalls], [t5].[OverflowQueueTime], [t5].[Outbound], [t5].[value] * @p24 AS [AvgAttemptsPerHour], [t5].[value2] * @p25 AS [AvgContactsPerHour], [t5].[value3] * @p26 AS [AvgCompletesPerHour]
- FROM (
- SELECT AVG(
- (CASE
- WHEN [t4].[value4] > @p18 THEN [t4].[value] / [t4].[value4]
- ELSE CONVERT(Decimal(33,4),@p19)
- END)) AS [value], AVG(
- (CASE
- WHEN [t4].[value2] > @p20 THEN [t4].[value2] / [t4].[value4]
- ELSE CONVERT(Decimal(33,4),@p21)
- END)) AS [value2], AVG(
- (CASE
- WHEN [t4].[value3] > @p22 THEN [t4].[value3] / [t4].[value4]
- ELSE CONVERT(Decimal(33,4),@p23)
- END)) AS [value3], [t4].[test], [t4].[sysid], [t4].[ACDGroupNumber], [t4].[WorkGroupID], [t4].[IsSpecial], [t4].[Description], [t4].[CreatedOn], [t4].[CreatedByID], [t4].[UpdatedOn], [t4].[UpdatedByID], [t4].[SkillName], [t4].[RoutingPolicy], [t4].[SkillCode], [t4].[Priority], [t4].[ATT], [t4].[ACW], [t4].[ASA], [t4].[Threshold], [t4].[Probability], [t4].[Tolerance], [t4].[AbandonPercentage], [t4].[SkillLevel], [t4].[ImportID], [t4].[SiteID], [t4].[HandleOverflowCalls], [t4].[OverflowQueueTime], [t4].[Outbound]
- FROM (
- SELECT [t2].[test], [t2].[sysid], [t2].[ACDGroupNumber], [t2].[WorkGroupID], [t2].[IsSpecial], [t2].[Description], [t2].[CreatedOn], [t2].[CreatedByID], [t2].[UpdatedOn], [t2].[UpdatedByID], [t2].[SkillName], [t2].[RoutingPolicy], [t2].[SkillCode], [t2].[Priority], [t2].[ATT], [t2].[ACW], [t2].[ASA], [t2].[Threshold], [t2].[Probability], [t2].[Tolerance], [t2].[AbandonPercentage], [t2].[SkillLevel], [t2].[ImportID], [t2].[SiteID], [t2].[HandleOverflowCalls], [t2].[OverflowQueueTime], [t2].[Outbound], CONVERT(Decimal(29,4),COALESCE([t0].[NumCalls],@p0)) AS [value], (CONVERT(Decimal(29,4),COALESCE([t0].[NumContacts],@p1))) + (CONVERT(Decimal(29,4),COALESCE([t0].[NumCompletes],@p2))) AS [value2], CONVERT(Decimal(29,4),COALESCE([t0].[NumCompletes],@p3)) AS [value3], (CONVERT(Decimal(33,4),((COALESCE([t0].[ATT],@p4)) * (CONVERT(Float,COALESCE([t0].[CallsHandled],@p5)))) + ((COALESCE([t0].[ACW],@p6)) * (CONVERT(Float,COALESCE([t0].[CallsHandled],@p7)))) + (COALESCE([t0].[TotalWaitTime],@p8)))) / ((COALESCE([t3].[TimeIncriments],@p9)) * @p10) AS [value4], [t0].[ACDGroupID], [t0].[CallDate]
- FROM [dbo].[CallHistoryDaily] AS [t0]
- LEFT OUTER JOIN (
- SELECT 1 AS [test], [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[ACDGroups] AS [t1]
- ) AS [t2] ON [t2].[sysid] = [t0].[ACDGroupID]
- LEFT OUTER JOIN [dbo].[WorkGroups] AS [t3] ON [t3].[sysid] = [t2].[WorkGroupID]
- ) AS [t4]
- WHERE ([t4].[ACDGroupID] IN (@p11, @p12)) AND ([t4].[CallDate] >= @p13) AND ([t4].[CallDate] < @p14) AND (((CONVERT(Int,(CONVERT(Float,CONVERT(BigInt,(((CONVERT(BigInt,DATEDIFF(DAY, [t4].[CallDate], @p15))) * 86400000) + DATEDIFF(MILLISECOND, DATEADD(DAY, DATEDIFF(DAY, [t4].[CallDate], @p15), [t4].[CallDate]), @p15)) * 10000))) / 864000000000)) % @p16) = @p17)
- GROUP BY [t4].[test], [t4].[sysid], [t4].[ACDGroupNumber], [t4].[WorkGroupID], [t4].[IsSpecial], [t4].[Description], [t4].[CreatedOn], [t4].[CreatedByID], [t4].[UpdatedOn], [t4].[UpdatedByID], [t4].[SkillName], [t4].[RoutingPolicy], [t4].[SkillCode], [t4].[Priority], [t4].[ATT], [t4].[ACW], [t4].[ASA], [t4].[Threshold], [t4].[Probability], [t4].[Tolerance], [t4].[AbandonPercentage], [t4].[SkillLevel], [t4].[ImportID], [t4].[SiteID], [t4].[HandleOverflowCalls], [t4].[OverflowQueueTime], [t4].[Outbound]
- ) AS [t5]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p3: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p4: Input Float (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p5: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p6: Input Float (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p7: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p8: Input Float (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p9: Input Decimal (Size = 0; Prec = 29; Scale = 0) [15]
- -- @p10: Input Decimal (Size = 0; Prec = 29; Scale = 0) [60]
- -- @p11: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p12: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p13: Input DateTime (Size = 0; Prec = 0; Scale = 0) [1/1/2007 12:00:00 AM]
- -- @p14: Input DateTime (Size = 0; Prec = 0; Scale = 0) [1/2/2011 12:00:00 AM]
- -- @p15: Input DateTime (Size = 0; Prec = 0; Scale = 0) [5/14/2010 12:00:00 AM]
- -- @p16: Input Int (Size = 0; Prec = 0; Scale = 0) [7]
- -- @p17: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p18: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0]
- -- @p19: Input Decimal (Size = 0; Prec = 29; Scale = 0) [0]
- -- @p20: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0]
- -- @p21: Input Decimal (Size = 0; Prec = 29; Scale = 0) [0]
- -- @p22: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0]
- -- @p23: Input Decimal (Size = 0; Prec = 29; Scale = 0) [0]
- -- @p24: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0.5]
- -- @p25: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0.5]
- -- @p26: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0.5]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT [t5].[test], [t5].[sysid], [t5].[ACDGroupNumber], [t5].[WorkGroupID], [t5].[IsSpecial], [t5].[Description], [t5].[CreatedOn], [t5].[CreatedByID], [t5].[UpdatedOn], [t5].[UpdatedByID], [t5].[SkillName], [t5].[RoutingPolicy], [t5].[SkillCode], [t5].[Priority], [t5].[ATT], [t5].[ACW], [t5].[ASA], [t5].[Threshold], [t5].[Probability], [t5].[Tolerance], [t5].[AbandonPercentage], [t5].[SkillLevel], [t5].[ImportID], [t5].[SiteID], [t5].[HandleOverflowCalls], [t5].[OverflowQueueTime], [t5].[Outbound], [t5].[SequenceNumber] AS [Segment], ([t5].[value] * @p51) / [t12].[value] AS [AttemptsFactor], ([t5].[value2] * @p52) / [t12].[value2] AS [ContactsFactor], ([t5].[value3] * @p53) / [t12].[value3] AS [CompletesFactor]
- FROM (
- SELECT AVG(
- (CASE
- WHEN [t4].[value4] > @p18 THEN [t4].[value] / [t4].[value4]
- ELSE CONVERT(Decimal(33,4),@p19)
- END)) AS [value], AVG(
- (CASE
- WHEN [t4].[value4] > @p20 THEN [t4].[value2] / [t4].[value4]
- ELSE CONVERT(Decimal(33,4),@p21)
- END)) AS [value2], AVG(
- (CASE
- WHEN [t4].[value4] > @p22 THEN [t4].[value3] / [t4].[value4]
- ELSE CONVERT(Decimal(33,4),@p23)
- END)) AS [value3], [t4].[test], [t4].[sysid], [t4].[ACDGroupNumber], [t4].[WorkGroupID], [t4].[IsSpecial], [t4].[Description], [t4].[CreatedOn], [t4].[CreatedByID], [t4].[UpdatedOn], [t4].[UpdatedByID], [t4].[SkillName], [t4].[RoutingPolicy], [t4].[SkillCode], [t4].[Priority], [t4].[ATT], [t4].[ACW], [t4].[ASA], [t4].[Threshold], [t4].[Probability], [t4].[Tolerance], [t4].[AbandonPercentage], [t4].[SkillLevel], [t4].[ImportID], [t4].[SiteID], [t4].[HandleOverflowCalls], [t4].[OverflowQueueTime], [t4].[Outbound], [t4].[SequenceNumber]
- FROM (
- SELECT [t2].[test], [t2].[sysid], [t2].[ACDGroupNumber], [t2].[WorkGroupID], [t2].[IsSpecial], [t2].[Description], [t2].[CreatedOn], [t2].[CreatedByID], [t2].[UpdatedOn], [t2].[UpdatedByID], [t2].[SkillName], [t2].[RoutingPolicy], [t2].[SkillCode], [t2].[Priority], [t2].[ATT], [t2].[ACW], [t2].[ASA], [t2].[Threshold], [t2].[Probability], [t2].[Tolerance], [t2].[AbandonPercentage], [t2].[SkillLevel], [t2].[ImportID], [t2].[SiteID], [t2].[HandleOverflowCalls], [t2].[OverflowQueueTime], [t2].[Outbound], [t0].[SequenceNumber], CONVERT(Decimal(29,4),COALESCE([t0].[NumCalls],@p0)) AS [value], (CONVERT(Decimal(29,4),COALESCE([t0].[NumContacts],@p1))) + (CONVERT(Decimal(29,4),COALESCE([t0].[NumCompletes],@p2))) AS [value2], CONVERT(Decimal(29,4),COALESCE([t0].[NumCompletes],@p3)) AS [value3], (CONVERT(Decimal(33,4),((COALESCE([t0].[ATT],@p4)) * (CONVERT(Float,COALESCE([t0].[CallsHandled],@p5)))) + ((COALESCE([t0].[ACW],@p6)) * (CONVERT(Float,COALESCE([t0].[CallsHandled],@p7)))) + (COALESCE([t0].[TotalWaitTime],@p8)))) / ((COALESCE([t3].[TimeIncriments],@p9)) * @p10) AS [value4], [t0].[ACDGroupID], [t0].[CallDate]
- FROM [dbo].[CallHistoryDaily] AS [t0]
- LEFT OUTER JOIN (
- SELECT 1 AS [test], [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[ACDGroups] AS [t1]
- ) AS [t2] ON [t2].[sysid] = [t0].[ACDGroupID]
- LEFT OUTER JOIN [dbo].[WorkGroups] AS [t3] ON [t3].[sysid] = [t2].[WorkGroupID]
- ) AS [t4]
- WHERE ([t4].[ACDGroupID] IN (@p11, @p12)) AND ([t4].[CallDate] >= @p13) AND ([t4].[CallDate] < @p14) AND (((CONVERT(Int,(CONVERT(Float,CONVERT(BigInt,(((CONVERT(BigInt,DATEDIFF(DAY, [t4].[CallDate], @p15))) * 86400000) + DATEDIFF(MILLISECOND, DATEADD(DAY, DATEDIFF(DAY, [t4].[CallDate], @p15), [t4].[CallDate]), @p15)) * 10000))) / 864000000000)) % @p16) = @p17)
- GROUP BY [t4].[test], [t4].[sysid], [t4].[ACDGroupNumber], [t4].[WorkGroupID], [t4].[IsSpecial], [t4].[Description], [t4].[CreatedOn], [t4].[CreatedByID], [t4].[UpdatedOn], [t4].[UpdatedByID], [t4].[SkillName], [t4].[RoutingPolicy], [t4].[SkillCode], [t4].[Priority], [t4].[ATT], [t4].[ACW], [t4].[ASA], [t4].[Threshold], [t4].[Probability], [t4].[Tolerance], [t4].[AbandonPercentage], [t4].[SkillLevel], [t4].[ImportID], [t4].[SiteID], [t4].[HandleOverflowCalls], [t4].[OverflowQueueTime], [t4].[Outbound], [t4].[SequenceNumber]
- ) AS [t5]
- INNER JOIN (
- SELECT [t11].[sysid], [t11].[value] * @p48 AS [value], [t11].[value2] * @p49 AS [value2], [t11].[value3] * @p50 AS [value3]
- FROM (
- SELECT AVG(
- (CASE
- WHEN [t10].[value4] > @p42 THEN [t10].[value] / [t10].[value4]
- ELSE CONVERT(Decimal(33,4),@p43)
- END)) AS [value], AVG(
- (CASE
- WHEN [t10].[value2] > @p44 THEN [t10].[value2] / [t10].[value4]
- ELSE CONVERT(Decimal(33,4),@p45)
- END)) AS [value2], AVG(
- (CASE
- WHEN [t10].[value3] > @p46 THEN [t10].[value3] / [t10].[value4]
- ELSE CONVERT(Decimal(33,4),@p47)
- END)) AS [value3], [t10].[sysid]
- FROM (
- SELECT [t8].[test], [t8].[sysid], [t8].[ACDGroupNumber], [t8].[WorkGroupID], [t8].[IsSpecial], [t8].[Description], [t8].[CreatedOn], [t8].[CreatedByID], [t8].[UpdatedOn], [t8].[UpdatedByID], [t8].[SkillName], [t8].[RoutingPolicy], [t8].[SkillCode], [t8].[Priority], [t8].[ATT], [t8].[ACW], [t8].[ASA], [t8].[Threshold], [t8].[Probability], [t8].[Tolerance], [t8].[AbandonPercentage], [t8].[SkillLevel], [t8].[ImportID], [t8].[SiteID], [t8].[HandleOverflowCalls], [t8].[OverflowQueueTime], [t8].[Outbound], CONVERT(Decimal(29,4),COALESCE([t6].[NumCalls],@p24)) AS [value], (CONVERT(Decimal(29,4),COALESCE([t6].[NumContacts],@p25))) + (CONVERT(Decimal(29,4),COALESCE([t6].[NumCompletes],@p26))) AS [value2], CONVERT(Decimal(29,4),COALESCE([t6].[NumCompletes],@p27)) AS [value3], (CONVERT(Decimal(33,4),((COALESCE([t6].[ATT],@p28)) * (CONVERT(Float,COALESCE([t6].[CallsHandled],@p29)))) + ((COALESCE([t6].[ACW],@p30)) * (CONVERT(Float,COALESCE([t6].[CallsHandled],@p31)))) + (COALESCE([t6].[TotalWaitTime],@p32)))) / ((COALESCE([t9].[TimeIncriments],@p33)) * @p34) AS [value4], [t6].[ACDGroupID], [t6].[CallDate]
- FROM [dbo].[CallHistoryDaily] AS [t6]
- LEFT OUTER JOIN (
- SELECT 1 AS [test], [t7].[sysid], [t7].[ACDGroupNumber], [t7].[WorkGroupID], [t7].[IsSpecial], [t7].[Description], [t7].[CreatedOn], [t7].[CreatedByID], [t7].[UpdatedOn], [t7].[UpdatedByID], [t7].[SkillName], [t7].[RoutingPolicy], [t7].[SkillCode], [t7].[Priority], [t7].[ATT], [t7].[ACW], [t7].[ASA], [t7].[Threshold], [t7].[Probability], [t7].[Tolerance], [t7].[AbandonPercentage], [t7].[SkillLevel], [t7].[ImportID], [t7].[SiteID], [t7].[HandleOverflowCalls], [t7].[OverflowQueueTime], [t7].[Outbound]
- FROM [dbo].[ACDGroups] AS [t7]
- ) AS [t8] ON [t8].[sysid] = [t6].[ACDGroupID]
- LEFT OUTER JOIN [dbo].[WorkGroups] AS [t9] ON [t9].[sysid] = [t8].[WorkGroupID]
- ) AS [t10]
- WHERE ([t10].[ACDGroupID] IN (@p35, @p36)) AND ([t10].[CallDate] >= @p37) AND ([t10].[CallDate] < @p38) AND (((CONVERT(Int,(CONVERT(Float,CONVERT(BigInt,(((CONVERT(BigInt,DATEDIFF(DAY, [t10].[CallDate], @p39))) * 86400000) + DATEDIFF(MILLISECOND, DATEADD(DAY, DATEDIFF(DAY, [t10].[CallDate], @p39), [t10].[CallDate]), @p39)) * 10000))) / 864000000000)) % @p40) = @p41)
- GROUP BY [t10].[test], [t10].[sysid], [t10].[ACDGroupNumber], [t10].[WorkGroupID], [t10].[IsSpecial], [t10].[Description], [t10].[CreatedOn], [t10].[CreatedByID], [t10].[UpdatedOn], [t10].[UpdatedByID], [t10].[SkillName], [t10].[RoutingPolicy], [t10].[SkillCode], [t10].[Priority], [t10].[ATT], [t10].[ACW], [t10].[ASA], [t10].[Threshold], [t10].[Probability], [t10].[Tolerance], [t10].[AbandonPercentage], [t10].[SkillLevel], [t10].[ImportID], [t10].[SiteID], [t10].[HandleOverflowCalls], [t10].[OverflowQueueTime], [t10].[Outbound]
- ) AS [t11]
- ) AS [t12] ON [t5].[sysid] = [t12].[sysid]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p3: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p4: Input Float (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p5: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p6: Input Float (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p7: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p8: Input Float (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p9: Input Decimal (Size = 0; Prec = 29; Scale = 0) [15]
- -- @p10: Input Decimal (Size = 0; Prec = 29; Scale = 0) [60]
- -- @p11: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p12: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p13: Input DateTime (Size = 0; Prec = 0; Scale = 0) [1/1/2007 12:00:00 AM]
- -- @p14: Input DateTime (Size = 0; Prec = 0; Scale = 0) [1/2/2011 12:00:00 AM]
- -- @p15: Input DateTime (Size = 0; Prec = 0; Scale = 0) [5/14/2010 12:00:00 AM]
- -- @p16: Input Int (Size = 0; Prec = 0; Scale = 0) [7]
- -- @p17: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p18: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0]
- -- @p19: Input Decimal (Size = 0; Prec = 29; Scale = 0) [0]
- -- @p20: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0]
- -- @p21: Input Decimal (Size = 0; Prec = 29; Scale = 0) [0]
- -- @p22: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0]
- -- @p23: Input Decimal (Size = 0; Prec = 29; Scale = 0) [0]
- -- @p24: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p25: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p26: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p27: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p28: Input Float (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p29: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p30: Input Float (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p31: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p32: Input Float (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p33: Input Decimal (Size = 0; Prec = 29; Scale = 0) [15]
- -- @p34: Input Decimal (Size = 0; Prec = 29; Scale = 0) [60]
- -- @p35: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p36: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p37: Input DateTime (Size = 0; Prec = 0; Scale = 0) [1/1/2007 12:00:00 AM]
- -- @p38: Input DateTime (Size = 0; Prec = 0; Scale = 0) [1/2/2011 12:00:00 AM]
- -- @p39: Input DateTime (Size = 0; Prec = 0; Scale = 0) [5/14/2010 12:00:00 AM]
- -- @p40: Input Int (Size = 0; Prec = 0; Scale = 0) [7]
- -- @p41: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p42: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0]
- -- @p43: Input Decimal (Size = 0; Prec = 29; Scale = 0) [0]
- -- @p44: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0]
- -- @p45: Input Decimal (Size = 0; Prec = 29; Scale = 0) [0]
- -- @p46: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0]
- -- @p47: Input Decimal (Size = 0; Prec = 29; Scale = 0) [0]
- -- @p48: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0.5]
- -- @p49: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0.5]
- -- @p50: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0.5]
- -- @p51: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0.5]
- -- @p52: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0.5]
- -- @p53: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0.5]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT [t5].[test], [t5].[sysid], [t5].[ACDGroupNumber], [t5].[WorkGroupID], [t5].[IsSpecial], [t5].[Description], [t5].[CreatedOn], [t5].[CreatedByID], [t5].[UpdatedOn], [t5].[UpdatedByID], [t5].[SkillName], [t5].[RoutingPolicy], [t5].[SkillCode], [t5].[Priority], [t5].[ATT], [t5].[ACW], [t5].[ASA], [t5].[Threshold], [t5].[Probability], [t5].[Tolerance], [t5].[AbandonPercentage], [t5].[SkillLevel], [t5].[ImportID], [t5].[SiteID], [t5].[HandleOverflowCalls], [t5].[OverflowQueueTime], [t5].[Outbound], [t5].[value] * @p24 AS [AvgAttemptsPerHour], [t5].[value2] * @p25 AS [AvgContactsPerHour], [t5].[value3] * @p26 AS [AvgCompletesPerHour]
- FROM (
- SELECT AVG(
- (CASE
- WHEN [t4].[value4] > @p18 THEN [t4].[value] / [t4].[value4]
- ELSE CONVERT(Decimal(33,4),@p19)
- END)) AS [value], AVG(
- (CASE
- WHEN [t4].[value2] > @p20 THEN [t4].[value2] / [t4].[value4]
- ELSE CONVERT(Decimal(33,4),@p21)
- END)) AS [value2], AVG(
- (CASE
- WHEN [t4].[value3] > @p22 THEN [t4].[value3] / [t4].[value4]
- ELSE CONVERT(Decimal(33,4),@p23)
- END)) AS [value3], [t4].[test], [t4].[sysid], [t4].[ACDGroupNumber], [t4].[WorkGroupID], [t4].[IsSpecial], [t4].[Description], [t4].[CreatedOn], [t4].[CreatedByID], [t4].[UpdatedOn], [t4].[UpdatedByID], [t4].[SkillName], [t4].[RoutingPolicy], [t4].[SkillCode], [t4].[Priority], [t4].[ATT], [t4].[ACW], [t4].[ASA], [t4].[Threshold], [t4].[Probability], [t4].[Tolerance], [t4].[AbandonPercentage], [t4].[SkillLevel], [t4].[ImportID], [t4].[SiteID], [t4].[HandleOverflowCalls], [t4].[OverflowQueueTime], [t4].[Outbound]
- FROM (
- SELECT [t2].[test], [t2].[sysid], [t2].[ACDGroupNumber], [t2].[WorkGroupID], [t2].[IsSpecial], [t2].[Description], [t2].[CreatedOn], [t2].[CreatedByID], [t2].[UpdatedOn], [t2].[UpdatedByID], [t2].[SkillName], [t2].[RoutingPolicy], [t2].[SkillCode], [t2].[Priority], [t2].[ATT], [t2].[ACW], [t2].[ASA], [t2].[Threshold], [t2].[Probability], [t2].[Tolerance], [t2].[AbandonPercentage], [t2].[SkillLevel], [t2].[ImportID], [t2].[SiteID], [t2].[HandleOverflowCalls], [t2].[OverflowQueueTime], [t2].[Outbound], CONVERT(Decimal(29,4),COALESCE([t0].[NumCalls],@p0)) AS [value], (CONVERT(Decimal(29,4),COALESCE([t0].[NumContacts],@p1))) + (CONVERT(Decimal(29,4),COALESCE([t0].[NumCompletes],@p2))) AS [value2], CONVERT(Decimal(29,4),COALESCE([t0].[NumCompletes],@p3)) AS [value3], (CONVERT(Decimal(33,4),((COALESCE([t0].[ATT],@p4)) * (CONVERT(Float,COALESCE([t0].[CallsHandled],@p5)))) + ((COALESCE([t0].[ACW],@p6)) * (CONVERT(Float,COALESCE([t0].[CallsHandled],@p7)))) + (COALESCE([t0].[TotalWaitTime],@p8)))) / ((COALESCE([t3].[TimeIncriments],@p9)) * @p10) AS [value4], [t0].[ACDGroupID], [t0].[CallDate]
- FROM [dbo].[CallHistoryDaily] AS [t0]
- LEFT OUTER JOIN (
- SELECT 1 AS [test], [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[ACDGroups] AS [t1]
- ) AS [t2] ON [t2].[sysid] = [t0].[ACDGroupID]
- LEFT OUTER JOIN [dbo].[WorkGroups] AS [t3] ON [t3].[sysid] = [t2].[WorkGroupID]
- ) AS [t4]
- WHERE ([t4].[ACDGroupID] IN (@p11, @p12)) AND ([t4].[CallDate] >= @p13) AND ([t4].[CallDate] < @p14) AND (((CONVERT(Int,(CONVERT(Float,CONVERT(BigInt,(((CONVERT(BigInt,DATEDIFF(DAY, [t4].[CallDate], @p15))) * 86400000) + DATEDIFF(MILLISECOND, DATEADD(DAY, DATEDIFF(DAY, [t4].[CallDate], @p15), [t4].[CallDate]), @p15)) * 10000))) / 864000000000)) % @p16) = @p17)
- GROUP BY [t4].[test], [t4].[sysid], [t4].[ACDGroupNumber], [t4].[WorkGroupID], [t4].[IsSpecial], [t4].[Description], [t4].[CreatedOn], [t4].[CreatedByID], [t4].[UpdatedOn], [t4].[UpdatedByID], [t4].[SkillName], [t4].[RoutingPolicy], [t4].[SkillCode], [t4].[Priority], [t4].[ATT], [t4].[ACW], [t4].[ASA], [t4].[Threshold], [t4].[Probability], [t4].[Tolerance], [t4].[AbandonPercentage], [t4].[SkillLevel], [t4].[ImportID], [t4].[SiteID], [t4].[HandleOverflowCalls], [t4].[OverflowQueueTime], [t4].[Outbound]
- ) AS [t5]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p3: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p4: Input Float (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p5: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p6: Input Float (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p7: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p8: Input Float (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p9: Input Decimal (Size = 0; Prec = 29; Scale = 0) [15]
- -- @p10: Input Decimal (Size = 0; Prec = 29; Scale = 0) [60]
- -- @p11: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p12: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p13: Input DateTime (Size = 0; Prec = 0; Scale = 0) [1/1/2007 12:00:00 AM]
- -- @p14: Input DateTime (Size = 0; Prec = 0; Scale = 0) [1/2/2011 12:00:00 AM]
- -- @p15: Input DateTime (Size = 0; Prec = 0; Scale = 0) [5/14/2010 12:00:00 AM]
- -- @p16: Input Int (Size = 0; Prec = 0; Scale = 0) [7]
- -- @p17: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p18: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0]
- -- @p19: Input Decimal (Size = 0; Prec = 29; Scale = 0) [0]
- -- @p20: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0]
- -- @p21: Input Decimal (Size = 0; Prec = 29; Scale = 0) [0]
- -- @p22: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0]
- -- @p23: Input Decimal (Size = 0; Prec = 29; Scale = 0) [0]
- -- @p24: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0.5]
- -- @p25: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0.5]
- -- @p26: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0.5]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [27]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM (
- SELECT DISTINCT [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE ([t0].[sysID] = @p0) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) AS [t3]
- WHERE [t3].[sysid] = @p1
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [27]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [27]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM (
- SELECT DISTINCT [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE ([t0].[sysID] = @p0) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) AS [t3]
- WHERE [t3].[sysid] = @p1
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [27]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [27]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM (
- SELECT DISTINCT [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE ([t0].[sysID] = @p0) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) AS [t3]
- WHERE [t3].[sysid] = @p1
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [27]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [27]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [27]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [27]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [27]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [27]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [28]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [28]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [28]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [28]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [28]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [23]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [23]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [23]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [23]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [23]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [23]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [23]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [23]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [23]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [23]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [23]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [23]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [23]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM (
- SELECT DISTINCT [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE ([t0].[sysID] = @p0) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) AS [t3]
- WHERE [t3].[sysid] = @p1
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM (
- SELECT DISTINCT [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE ([t0].[sysID] = @p0) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) AS [t3]
- WHERE [t3].[sysid] = @p1
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM (
- SELECT DISTINCT [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE ([t0].[sysID] = @p0) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) AS [t3]
- WHERE [t3].[sysid] = @p1
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM (
- SELECT DISTINCT [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE ([t0].[sysID] = @p0) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) AS [t3]
- WHERE [t3].[sysid] = @p1
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM (
- SELECT DISTINCT [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE ([t0].[sysID] = @p0) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) AS [t3]
- WHERE [t3].[sysid] = @p1
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM (
- SELECT DISTINCT [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE ([t0].[sysID] = @p0) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) AS [t3]
- WHERE [t3].[sysid] = @p1
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [29]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [29]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [29]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [29]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [29]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [29]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [29]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [29]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM (
- SELECT DISTINCT [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE ([t0].[sysID] = @p0) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) AS [t3]
- WHERE [t3].[sysid] = @p1
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM (
- SELECT DISTINCT [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE ([t0].[sysID] = @p0) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) AS [t3]
- WHERE [t3].[sysid] = @p1
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM (
- SELECT DISTINCT [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE ([t0].[sysID] = @p0) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) AS [t3]
- WHERE [t3].[sysid] = @p1
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM (
- SELECT DISTINCT [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE ([t0].[sysID] = @p0) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) AS [t3]
- WHERE [t3].[sysid] = @p1
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM (
- SELECT DISTINCT [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE ([t0].[sysID] = @p0) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) AS [t3]
- WHERE [t3].[sysid] = @p1
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM (
- SELECT DISTINCT [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE ([t0].[sysID] = @p0) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) AS [t3]
- WHERE [t3].[sysid] = @p1
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT [t5].[test], [t5].[sysid], [t5].[ACDGroupNumber], [t5].[WorkGroupID], [t5].[IsSpecial], [t5].[Description], [t5].[CreatedOn], [t5].[CreatedByID], [t5].[UpdatedOn], [t5].[UpdatedByID], [t5].[SkillName], [t5].[RoutingPolicy], [t5].[SkillCode], [t5].[Priority], [t5].[ATT], [t5].[ACW], [t5].[ASA], [t5].[Threshold], [t5].[Probability], [t5].[Tolerance], [t5].[AbandonPercentage], [t5].[SkillLevel], [t5].[ImportID], [t5].[SiteID], [t5].[HandleOverflowCalls], [t5].[OverflowQueueTime], [t5].[Outbound], [t5].[value] * @p24 AS [AvgAttemptsPerHour], [t5].[value2] * @p25 AS [AvgContactsPerHour], [t5].[value3] * @p26 AS [AvgCompletesPerHour]
- FROM (
- SELECT AVG(
- (CASE
- WHEN [t4].[value4] > @p18 THEN [t4].[value] / [t4].[value4]
- ELSE CONVERT(Decimal(33,4),@p19)
- END)) AS [value], AVG(
- (CASE
- WHEN [t4].[value2] > @p20 THEN [t4].[value2] / [t4].[value4]
- ELSE CONVERT(Decimal(33,4),@p21)
- END)) AS [value2], AVG(
- (CASE
- WHEN [t4].[value3] > @p22 THEN [t4].[value3] / [t4].[value4]
- ELSE CONVERT(Decimal(33,4),@p23)
- END)) AS [value3], [t4].[test], [t4].[sysid], [t4].[ACDGroupNumber], [t4].[WorkGroupID], [t4].[IsSpecial], [t4].[Description], [t4].[CreatedOn], [t4].[CreatedByID], [t4].[UpdatedOn], [t4].[UpdatedByID], [t4].[SkillName], [t4].[RoutingPolicy], [t4].[SkillCode], [t4].[Priority], [t4].[ATT], [t4].[ACW], [t4].[ASA], [t4].[Threshold], [t4].[Probability], [t4].[Tolerance], [t4].[AbandonPercentage], [t4].[SkillLevel], [t4].[ImportID], [t4].[SiteID], [t4].[HandleOverflowCalls], [t4].[OverflowQueueTime], [t4].[Outbound]
- FROM (
- SELECT [t2].[test], [t2].[sysid], [t2].[ACDGroupNumber], [t2].[WorkGroupID], [t2].[IsSpecial], [t2].[Description], [t2].[CreatedOn], [t2].[CreatedByID], [t2].[UpdatedOn], [t2].[UpdatedByID], [t2].[SkillName], [t2].[RoutingPolicy], [t2].[SkillCode], [t2].[Priority], [t2].[ATT], [t2].[ACW], [t2].[ASA], [t2].[Threshold], [t2].[Probability], [t2].[Tolerance], [t2].[AbandonPercentage], [t2].[SkillLevel], [t2].[ImportID], [t2].[SiteID], [t2].[HandleOverflowCalls], [t2].[OverflowQueueTime], [t2].[Outbound], CONVERT(Decimal(29,4),COALESCE([t0].[NumCalls],@p0)) AS [value], (CONVERT(Decimal(29,4),COALESCE([t0].[NumContacts],@p1))) + (CONVERT(Decimal(29,4),COALESCE([t0].[NumCompletes],@p2))) AS [value2], CONVERT(Decimal(29,4),COALESCE([t0].[NumCompletes],@p3)) AS [value3], (CONVERT(Decimal(33,4),((COALESCE([t0].[ATT],@p4)) * (CONVERT(Float,COALESCE([t0].[CallsHandled],@p5)))) + ((COALESCE([t0].[ACW],@p6)) * (CONVERT(Float,COALESCE([t0].[CallsHandled],@p7)))) + (COALESCE([t0].[TotalWaitTime],@p8)))) / ((COALESCE([t3].[TimeIncriments],@p9)) * @p10) AS [value4], [t0].[ACDGroupID], [t0].[CallDate]
- FROM [dbo].[CallHistoryDaily] AS [t0]
- LEFT OUTER JOIN (
- SELECT 1 AS [test], [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[ACDGroups] AS [t1]
- ) AS [t2] ON [t2].[sysid] = [t0].[ACDGroupID]
- LEFT OUTER JOIN [dbo].[WorkGroups] AS [t3] ON [t3].[sysid] = [t2].[WorkGroupID]
- ) AS [t4]
- WHERE ([t4].[ACDGroupID] IN (@p11, @p12)) AND ([t4].[CallDate] >= @p13) AND ([t4].[CallDate] < @p14) AND (((CONVERT(Int,(CONVERT(Float,CONVERT(BigInt,(((CONVERT(BigInt,DATEDIFF(DAY, [t4].[CallDate], @p15))) * 86400000) + DATEDIFF(MILLISECOND, DATEADD(DAY, DATEDIFF(DAY, [t4].[CallDate], @p15), [t4].[CallDate]), @p15)) * 10000))) / 864000000000)) % @p16) = @p17)
- GROUP BY [t4].[test], [t4].[sysid], [t4].[ACDGroupNumber], [t4].[WorkGroupID], [t4].[IsSpecial], [t4].[Description], [t4].[CreatedOn], [t4].[CreatedByID], [t4].[UpdatedOn], [t4].[UpdatedByID], [t4].[SkillName], [t4].[RoutingPolicy], [t4].[SkillCode], [t4].[Priority], [t4].[ATT], [t4].[ACW], [t4].[ASA], [t4].[Threshold], [t4].[Probability], [t4].[Tolerance], [t4].[AbandonPercentage], [t4].[SkillLevel], [t4].[ImportID], [t4].[SiteID], [t4].[HandleOverflowCalls], [t4].[OverflowQueueTime], [t4].[Outbound]
- ) AS [t5]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p3: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p4: Input Float (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p5: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p6: Input Float (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p7: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p8: Input Float (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p9: Input Decimal (Size = 0; Prec = 29; Scale = 0) [15]
- -- @p10: Input Decimal (Size = 0; Prec = 29; Scale = 0) [60]
- -- @p11: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p12: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p13: Input DateTime (Size = 0; Prec = 0; Scale = 0) [1/1/2007 12:00:00 AM]
- -- @p14: Input DateTime (Size = 0; Prec = 0; Scale = 0) [1/2/2011 12:00:00 AM]
- -- @p15: Input DateTime (Size = 0; Prec = 0; Scale = 0) [5/14/2010 12:00:00 AM]
- -- @p16: Input Int (Size = 0; Prec = 0; Scale = 0) [7]
- -- @p17: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p18: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0]
- -- @p19: Input Decimal (Size = 0; Prec = 29; Scale = 0) [0]
- -- @p20: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0]
- -- @p21: Input Decimal (Size = 0; Prec = 29; Scale = 0) [0]
- -- @p22: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0]
- -- @p23: Input Decimal (Size = 0; Prec = 29; Scale = 0) [0]
- -- @p24: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0.5]
- -- @p25: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0.5]
- -- @p26: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0.5]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [27]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM (
- SELECT DISTINCT [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE ([t0].[sysID] = @p0) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) AS [t3]
- WHERE [t3].[sysid] = @p1
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [27]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [27]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM (
- SELECT DISTINCT [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE ([t0].[sysID] = @p0) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) AS [t3]
- WHERE [t3].[sysid] = @p1
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [27]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [27]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM (
- SELECT DISTINCT [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE ([t0].[sysID] = @p0) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) AS [t3]
- WHERE [t3].[sysid] = @p1
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [27]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [27]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [27]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [27]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [27]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [27]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [28]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [28]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [28]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [28]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [28]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [23]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [23]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [23]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [23]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [23]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [23]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [23]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [23]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [23]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [23]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [23]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [23]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [23]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM (
- SELECT DISTINCT [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE ([t0].[sysID] = @p0) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) AS [t3]
- WHERE [t3].[sysid] = @p1
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM (
- SELECT DISTINCT [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE ([t0].[sysID] = @p0) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) AS [t3]
- WHERE [t3].[sysid] = @p1
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM (
- SELECT DISTINCT [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE ([t0].[sysID] = @p0) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) AS [t3]
- WHERE [t3].[sysid] = @p1
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM (
- SELECT DISTINCT [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE ([t0].[sysID] = @p0) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) AS [t3]
- WHERE [t3].[sysid] = @p1
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM (
- SELECT DISTINCT [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE ([t0].[sysID] = @p0) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) AS [t3]
- WHERE [t3].[sysid] = @p1
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM (
- SELECT DISTINCT [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE ([t0].[sysID] = @p0) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) AS [t3]
- WHERE [t3].[sysid] = @p1
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [29]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [29]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [29]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [29]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [29]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [29]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [29]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [29]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM (
- SELECT DISTINCT [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE ([t0].[sysID] = @p0) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) AS [t3]
- WHERE [t3].[sysid] = @p1
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM (
- SELECT DISTINCT [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE ([t0].[sysID] = @p0) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) AS [t3]
- WHERE [t3].[sysid] = @p1
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM (
- SELECT DISTINCT [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE ([t0].[sysID] = @p0) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) AS [t3]
- WHERE [t3].[sysid] = @p1
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM (
- SELECT DISTINCT [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE ([t0].[sysID] = @p0) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) AS [t3]
- WHERE [t3].[sysid] = @p1
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM (
- SELECT DISTINCT [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE ([t0].[sysID] = @p0) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) AS [t3]
- WHERE [t3].[sysid] = @p1
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM (
- SELECT DISTINCT [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE ([t0].[sysID] = @p0) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) AS [t3]
- WHERE [t3].[sysid] = @p1
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t0], [dbo].[ACDGroups] AS [t1]
- WHERE (([t1].[sysid]) IN (@p0, @p1)) AND ([t0].[sysID] = @p2) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- ) THEN 1
- ELSE 0
- END) AS [value]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [26]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT [t0].[sysid], [t0].[WorkGroupID], [t0].[ShiftID], [t0].[FNAME], [t0].[StartTime], [t0].[EndTime], [t0].[MinimumStaff], [t0].[NumberOfBreaks], [t0].[LunchMinutes], [t0].[EarliestLunch], [t0].[LATELNCH], [t0].[IsLateNightShift], [t0].[COST], [t0].[CreatedOn], [t0].[CreatedByID], [t0].[UpdatedOn], [t0].[UpdatedByID], [t0].[FirstBreakMinutes], [t0].[SecondBreakMinutes], [t0].[Teamid],
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t1]
- WHERE [t0].[Teamid] = ([t1].[sysID])
- ) THEN 1
- ELSE 0
- END) AS [value]
- FROM [dbo].[ShiftFiles] AS [t0]
- WHERE ([t0].[FNAME] IN (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7)) AND ([dbo].[ToSegment]([t0].[StartTime], @p8) < [dbo].[ToSegment]([t0].[EndTime], @p9))
- -- @p0: Input NVarChar (Size = 8; Prec = 0; Scale = 0) [FullTime]
- -- @p1: Input NVarChar (Size = 5; Prec = 0; Scale = 0) [PT AM]
- -- @p2: Input NVarChar (Size = 5; Prec = 0; Scale = 0) [PT PM]
- -- @p3: Input NVarChar (Size = 6; Prec = 0; Scale = 0) [Shift1]
- -- @p4: Input NVarChar (Size = 6; Prec = 0; Scale = 0) [Shift2]
- -- @p5: Input NVarChar (Size = 6; Prec = 0; Scale = 0) [Shift3]
- -- @p6: Input NVarChar (Size = 5; Prec = 0; Scale = 0) [Tour1]
- -- @p7: Input NVarChar (Size = 7; Prec = 0; Scale = 0) [Weekend]
- -- @p8: Input Int (Size = 0; Prec = 0; Scale = 0) [30]
- -- @p9: Input Int (Size = 0; Prec = 0; Scale = 0) [30]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT [t0].[sysid], [t0].[WorkGroupID], [t0].[ShiftID], [t0].[FNAME], [t0].[StartTime], [t0].[EndTime], [t0].[MinimumStaff], [t0].[NumberOfBreaks], [t0].[LunchMinutes], [t0].[EarliestLunch], [t0].[LATELNCH], [t0].[IsLateNightShift], [t0].[COST], [t0].[CreatedOn], [t0].[CreatedByID], [t0].[UpdatedOn], [t0].[UpdatedByID], [t0].[FirstBreakMinutes], [t0].[SecondBreakMinutes], [t0].[Teamid],
- (CASE
- WHEN EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[Teams] AS [t1]
- WHERE [t0].[Teamid] = ([t1].[sysID])
- ) THEN 1
- ELSE 0
- END) AS [value]
- FROM [dbo].[ShiftFiles] AS [t0]
- WHERE ([t0].[FNAME] IN (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7)) AND ([dbo].[ToSegment]([t0].[StartTime], @p8) < [dbo].[ToSegment]([t0].[EndTime], @p9))
- -- @p0: Input NVarChar (Size = 8; Prec = 0; Scale = 0) [FullTime]
- -- @p1: Input NVarChar (Size = 5; Prec = 0; Scale = 0) [PT AM]
- -- @p2: Input NVarChar (Size = 5; Prec = 0; Scale = 0) [PT PM]
- -- @p3: Input NVarChar (Size = 6; Prec = 0; Scale = 0) [Shift1]
- -- @p4: Input NVarChar (Size = 6; Prec = 0; Scale = 0) [Shift2]
- -- @p5: Input NVarChar (Size = 6; Prec = 0; Scale = 0) [Shift3]
- -- @p6: Input NVarChar (Size = 5; Prec = 0; Scale = 0) [Tour1]
- -- @p7: Input NVarChar (Size = 7; Prec = 0; Scale = 0) [Weekend]
- -- @p8: Input Int (Size = 0; Prec = 0; Scale = 0) [30]
- -- @p9: Input Int (Size = 0; Prec = 0; Scale = 0) [30]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT [t0].[sysID]
- FROM [dbo].[Teams] AS [t0]
- WHERE EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[ACDGroups] AS [t1]
- WHERE ([t1].[sysid] = @p0) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- )
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT [t5].[test], [t5].[sysid], [t5].[ACDGroupNumber], [t5].[WorkGroupID], [t5].[IsSpecial], [t5].[Description], [t5].[CreatedOn], [t5].[CreatedByID], [t5].[UpdatedOn], [t5].[UpdatedByID], [t5].[SkillName], [t5].[RoutingPolicy], [t5].[SkillCode], [t5].[Priority], [t5].[ATT], [t5].[ACW], [t5].[ASA], [t5].[Threshold], [t5].[Probability], [t5].[Tolerance], [t5].[AbandonPercentage], [t5].[SkillLevel], [t5].[ImportID], [t5].[SiteID], [t5].[HandleOverflowCalls], [t5].[OverflowQueueTime], [t5].[Outbound], [t5].[value] * @p24 AS [AvgAttemptsPerHour], [t5].[value2] * @p25 AS [AvgContactsPerHour], [t5].[value3] * @p26 AS [AvgCompletesPerHour]
- FROM (
- SELECT AVG(
- (CASE
- WHEN [t4].[value4] > @p18 THEN [t4].[value] / [t4].[value4]
- ELSE CONVERT(Decimal(33,4),@p19)
- END)) AS [value], AVG(
- (CASE
- WHEN [t4].[value2] > @p20 THEN [t4].[value2] / [t4].[value4]
- ELSE CONVERT(Decimal(33,4),@p21)
- END)) AS [value2], AVG(
- (CASE
- WHEN [t4].[value3] > @p22 THEN [t4].[value3] / [t4].[value4]
- ELSE CONVERT(Decimal(33,4),@p23)
- END)) AS [value3], [t4].[test], [t4].[sysid], [t4].[ACDGroupNumber], [t4].[WorkGroupID], [t4].[IsSpecial], [t4].[Description], [t4].[CreatedOn], [t4].[CreatedByID], [t4].[UpdatedOn], [t4].[UpdatedByID], [t4].[SkillName], [t4].[RoutingPolicy], [t4].[SkillCode], [t4].[Priority], [t4].[ATT], [t4].[ACW], [t4].[ASA], [t4].[Threshold], [t4].[Probability], [t4].[Tolerance], [t4].[AbandonPercentage], [t4].[SkillLevel], [t4].[ImportID], [t4].[SiteID], [t4].[HandleOverflowCalls], [t4].[OverflowQueueTime], [t4].[Outbound]
- FROM (
- SELECT [t2].[test], [t2].[sysid], [t2].[ACDGroupNumber], [t2].[WorkGroupID], [t2].[IsSpecial], [t2].[Description], [t2].[CreatedOn], [t2].[CreatedByID], [t2].[UpdatedOn], [t2].[UpdatedByID], [t2].[SkillName], [t2].[RoutingPolicy], [t2].[SkillCode], [t2].[Priority], [t2].[ATT], [t2].[ACW], [t2].[ASA], [t2].[Threshold], [t2].[Probability], [t2].[Tolerance], [t2].[AbandonPercentage], [t2].[SkillLevel], [t2].[ImportID], [t2].[SiteID], [t2].[HandleOverflowCalls], [t2].[OverflowQueueTime], [t2].[Outbound], CONVERT(Decimal(29,4),COALESCE([t0].[NumCalls],@p0)) AS [value], (CONVERT(Decimal(29,4),COALESCE([t0].[NumContacts],@p1))) + (CONVERT(Decimal(29,4),COALESCE([t0].[NumCompletes],@p2))) AS [value2], CONVERT(Decimal(29,4),COALESCE([t0].[NumCompletes],@p3)) AS [value3], (CONVERT(Decimal(33,4),((COALESCE([t0].[ATT],@p4)) * (CONVERT(Float,COALESCE([t0].[CallsHandled],@p5)))) + ((COALESCE([t0].[ACW],@p6)) * (CONVERT(Float,COALESCE([t0].[CallsHandled],@p7)))) + (COALESCE([t0].[TotalWaitTime],@p8)))) / ((COALESCE([t3].[TimeIncriments],@p9)) * @p10) AS [value4], [t0].[ACDGroupID], [t0].[CallDate]
- FROM [dbo].[CallHistoryDaily] AS [t0]
- LEFT OUTER JOIN (
- SELECT 1 AS [test], [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[ACDGroups] AS [t1]
- ) AS [t2] ON [t2].[sysid] = [t0].[ACDGroupID]
- LEFT OUTER JOIN [dbo].[WorkGroups] AS [t3] ON [t3].[sysid] = [t2].[WorkGroupID]
- ) AS [t4]
- WHERE ([t4].[ACDGroupID] IN (@p11, @p12)) AND ([t4].[CallDate] >= @p13) AND ([t4].[CallDate] < @p14) AND (((CONVERT(Int,(CONVERT(Float,CONVERT(BigInt,(((CONVERT(BigInt,DATEDIFF(DAY, [t4].[CallDate], @p15))) * 86400000) + DATEDIFF(MILLISECOND, DATEADD(DAY, DATEDIFF(DAY, [t4].[CallDate], @p15), [t4].[CallDate]), @p15)) * 10000))) / 864000000000)) % @p16) = @p17)
- GROUP BY [t4].[test], [t4].[sysid], [t4].[ACDGroupNumber], [t4].[WorkGroupID], [t4].[IsSpecial], [t4].[Description], [t4].[CreatedOn], [t4].[CreatedByID], [t4].[UpdatedOn], [t4].[UpdatedByID], [t4].[SkillName], [t4].[RoutingPolicy], [t4].[SkillCode], [t4].[Priority], [t4].[ATT], [t4].[ACW], [t4].[ASA], [t4].[Threshold], [t4].[Probability], [t4].[Tolerance], [t4].[AbandonPercentage], [t4].[SkillLevel], [t4].[ImportID], [t4].[SiteID], [t4].[HandleOverflowCalls], [t4].[OverflowQueueTime], [t4].[Outbound]
- ) AS [t5]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p3: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p4: Input Float (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p5: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p6: Input Float (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p7: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p8: Input Float (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p9: Input Decimal (Size = 0; Prec = 29; Scale = 0) [15]
- -- @p10: Input Decimal (Size = 0; Prec = 29; Scale = 0) [60]
- -- @p11: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p12: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p13: Input DateTime (Size = 0; Prec = 0; Scale = 0) [1/1/2007 12:00:00 AM]
- -- @p14: Input DateTime (Size = 0; Prec = 0; Scale = 0) [1/2/2011 12:00:00 AM]
- -- @p15: Input DateTime (Size = 0; Prec = 0; Scale = 0) [5/14/2010 12:00:00 AM]
- -- @p16: Input Int (Size = 0; Prec = 0; Scale = 0) [7]
- -- @p17: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p18: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0]
- -- @p19: Input Decimal (Size = 0; Prec = 29; Scale = 0) [0]
- -- @p20: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0]
- -- @p21: Input Decimal (Size = 0; Prec = 29; Scale = 0) [0]
- -- @p22: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0]
- -- @p23: Input Decimal (Size = 0; Prec = 29; Scale = 0) [0]
- -- @p24: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0.5]
- -- @p25: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0.5]
- -- @p26: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0.5]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT [t0].[sysID]
- FROM [dbo].[Teams] AS [t0]
- WHERE EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[ACDGroups] AS [t1]
- WHERE ([t1].[sysid] = @p0) AND (EXISTS(
- SELECT NULL AS [EMPTY]
- FROM [dbo].[TeamSkills] AS [t2]
- WHERE ([t2].[TeamID] = [t0].[sysID]) AND ([t2].[ACDGroupID] = [t1].[sysid])
- ))
- )
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT [t5].[test], [t5].[sysid], [t5].[ACDGroupNumber], [t5].[WorkGroupID], [t5].[IsSpecial], [t5].[Description], [t5].[CreatedOn], [t5].[CreatedByID], [t5].[UpdatedOn], [t5].[UpdatedByID], [t5].[SkillName], [t5].[RoutingPolicy], [t5].[SkillCode], [t5].[Priority], [t5].[ATT], [t5].[ACW], [t5].[ASA], [t5].[Threshold], [t5].[Probability], [t5].[Tolerance], [t5].[AbandonPercentage], [t5].[SkillLevel], [t5].[ImportID], [t5].[SiteID], [t5].[HandleOverflowCalls], [t5].[OverflowQueueTime], [t5].[Outbound], [t5].[value] * @p24 AS [AvgAttemptsPerHour], [t5].[value2] * @p25 AS [AvgContactsPerHour], [t5].[value3] * @p26 AS [AvgCompletesPerHour]
- FROM (
- SELECT AVG(
- (CASE
- WHEN [t4].[value4] > @p18 THEN [t4].[value] / [t4].[value4]
- ELSE CONVERT(Decimal(33,4),@p19)
- END)) AS [value], AVG(
- (CASE
- WHEN [t4].[value2] > @p20 THEN [t4].[value2] / [t4].[value4]
- ELSE CONVERT(Decimal(33,4),@p21)
- END)) AS [value2], AVG(
- (CASE
- WHEN [t4].[value3] > @p22 THEN [t4].[value3] / [t4].[value4]
- ELSE CONVERT(Decimal(33,4),@p23)
- END)) AS [value3], [t4].[test], [t4].[sysid], [t4].[ACDGroupNumber], [t4].[WorkGroupID], [t4].[IsSpecial], [t4].[Description], [t4].[CreatedOn], [t4].[CreatedByID], [t4].[UpdatedOn], [t4].[UpdatedByID], [t4].[SkillName], [t4].[RoutingPolicy], [t4].[SkillCode], [t4].[Priority], [t4].[ATT], [t4].[ACW], [t4].[ASA], [t4].[Threshold], [t4].[Probability], [t4].[Tolerance], [t4].[AbandonPercentage], [t4].[SkillLevel], [t4].[ImportID], [t4].[SiteID], [t4].[HandleOverflowCalls], [t4].[OverflowQueueTime], [t4].[Outbound]
- FROM (
- SELECT [t2].[test], [t2].[sysid], [t2].[ACDGroupNumber], [t2].[WorkGroupID], [t2].[IsSpecial], [t2].[Description], [t2].[CreatedOn], [t2].[CreatedByID], [t2].[UpdatedOn], [t2].[UpdatedByID], [t2].[SkillName], [t2].[RoutingPolicy], [t2].[SkillCode], [t2].[Priority], [t2].[ATT], [t2].[ACW], [t2].[ASA], [t2].[Threshold], [t2].[Probability], [t2].[Tolerance], [t2].[AbandonPercentage], [t2].[SkillLevel], [t2].[ImportID], [t2].[SiteID], [t2].[HandleOverflowCalls], [t2].[OverflowQueueTime], [t2].[Outbound], CONVERT(Decimal(29,4),COALESCE([t0].[NumCalls],@p0)) AS [value], (CONVERT(Decimal(29,4),COALESCE([t0].[NumContacts],@p1))) + (CONVERT(Decimal(29,4),COALESCE([t0].[NumCompletes],@p2))) AS [value2], CONVERT(Decimal(29,4),COALESCE([t0].[NumCompletes],@p3)) AS [value3], (CONVERT(Decimal(33,4),((COALESCE([t0].[ATT],@p4)) * (CONVERT(Float,COALESCE([t0].[CallsHandled],@p5)))) + ((COALESCE([t0].[ACW],@p6)) * (CONVERT(Float,COALESCE([t0].[CallsHandled],@p7)))) + (COALESCE([t0].[TotalWaitTime],@p8)))) / ((COALESCE([t3].[TimeIncriments],@p9)) * @p10) AS [value4], [t0].[ACDGroupID], [t0].[CallDate]
- FROM [dbo].[CallHistoryDaily] AS [t0]
- LEFT OUTER JOIN (
- SELECT 1 AS [test], [t1].[sysid], [t1].[ACDGroupNumber], [t1].[WorkGroupID], [t1].[IsSpecial], [t1].[Description], [t1].[CreatedOn], [t1].[CreatedByID], [t1].[UpdatedOn], [t1].[UpdatedByID], [t1].[SkillName], [t1].[RoutingPolicy], [t1].[SkillCode], [t1].[Priority], [t1].[ATT], [t1].[ACW], [t1].[ASA], [t1].[Threshold], [t1].[Probability], [t1].[Tolerance], [t1].[AbandonPercentage], [t1].[SkillLevel], [t1].[ImportID], [t1].[SiteID], [t1].[HandleOverflowCalls], [t1].[OverflowQueueTime], [t1].[Outbound]
- FROM [dbo].[ACDGroups] AS [t1]
- ) AS [t2] ON [t2].[sysid] = [t0].[ACDGroupID]
- LEFT OUTER JOIN [dbo].[WorkGroups] AS [t3] ON [t3].[sysid] = [t2].[WorkGroupID]
- ) AS [t4]
- WHERE ([t4].[ACDGroupID] IN (@p11, @p12)) AND ([t4].[CallDate] >= @p13) AND ([t4].[CallDate] < @p14) AND (((CONVERT(Int,(CONVERT(Float,CONVERT(BigInt,(((CONVERT(BigInt,DATEDIFF(DAY, [t4].[CallDate], @p15))) * 86400000) + DATEDIFF(MILLISECOND, DATEADD(DAY, DATEDIFF(DAY, [t4].[CallDate], @p15), [t4].[CallDate]), @p15)) * 10000))) / 864000000000)) % @p16) = @p17)
- GROUP BY [t4].[test], [t4].[sysid], [t4].[ACDGroupNumber], [t4].[WorkGroupID], [t4].[IsSpecial], [t4].[Description], [t4].[CreatedOn], [t4].[CreatedByID], [t4].[UpdatedOn], [t4].[UpdatedByID], [t4].[SkillName], [t4].[RoutingPolicy], [t4].[SkillCode], [t4].[Priority], [t4].[ATT], [t4].[ACW], [t4].[ASA], [t4].[Threshold], [t4].[Probability], [t4].[Tolerance], [t4].[AbandonPercentage], [t4].[SkillLevel], [t4].[ImportID], [t4].[SiteID], [t4].[HandleOverflowCalls], [t4].[OverflowQueueTime], [t4].[Outbound]
- ) AS [t5]
- -- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p3: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p4: Input Float (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p5: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p6: Input Float (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p7: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p8: Input Float (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p9: Input Decimal (Size = 0; Prec = 29; Scale = 0) [15]
- -- @p10: Input Decimal (Size = 0; Prec = 29; Scale = 0) [60]
- -- @p11: Input Int (Size = 0; Prec = 0; Scale = 0) [24]
- -- @p12: Input Int (Size = 0; Prec = 0; Scale = 0) [25]
- -- @p13: Input DateTime (Size = 0; Prec = 0; Scale = 0) [1/1/2007 12:00:00 AM]
- -- @p14: Input DateTime (Size = 0; Prec = 0; Scale = 0) [1/2/2011 12:00:00 AM]
- -- @p15: Input DateTime (Size = 0; Prec = 0; Scale = 0) [5/14/2010 12:00:00 AM]
- -- @p16: Input Int (Size = 0; Prec = 0; Scale = 0) [7]
- -- @p17: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
- -- @p18: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0]
- -- @p19: Input Decimal (Size = 0; Prec = 29; Scale = 0) [0]
- -- @p20: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0]
- -- @p21: Input Decimal (Size = 0; Prec = 29; Scale = 0) [0]
- -- @p22: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0]
- -- @p23: Input Decimal (Size = 0; Prec = 29; Scale = 0) [0]
- -- @p24: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0.5]
- -- @p25: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0.5]
- -- @p26: Input Decimal (Size = 0; Prec = 33; Scale = 4) [0.5]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
- SELECT [t0].[sysid], [t0].[SessionLength], [t0].[EARLIEST], [t0].[LATEST], [t0].[CreatedOn], [t0].[CreatedByID], [t0].[UpdatedOn], [t0].[UpdatedByID]
- FROM [dbo].[Breaks] AS [t0]
- -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.4926
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement