Welcome to the World of SQLServer.........: Resource Governor: What, How to Configure and Monitor

Welcome to the World of SQLServer.........: Resource Governor: What, How to Configure and Monitor: "CREATE FUNCTION rgclassifier1() RETURNS SYSNAME
WITH SCHEMABINDING
AS
BEGIN
DECLARE @grp_name AS SYSNAME
IF (APP_NAME() = 'ME2ME')
SET @grp_Name = 'wrkgroupCritical'
ELSE if(App_name()='GKPRD')
set @grp_Name = 'wrkgroupCritical'
else if (App_name()='Kate_Audit')
set @grp_Name = 'wrkgroupCritical'
else
SET @grp_Name = 'wrkgroupNormal'
RETURN @grp_name
END;"

'via Blog this'