خطأ عندما يزيد عدد الشروط الخاصة بــ Case when

الاخوة الزملاء

السلام عليكم ورحمة الله وبركاتة

الاسكريبت المرفق يعمل بشكل طبيعي جداً لكن المشكلة عندما يزيد عدد أسطر المعادلة Case when عن 10 أسطر تظهر هذه الرسالة فهل هناك من طريقة لتجاوز هذه المشكلة ؟

select Dataareaid,createdby,count (createdby) as Total,

(Case when ledgerjournaltable.createdby = 'AAshr' then 'Ahmed Ashraf' else
Case when ledgerjournaltable.createdby = 'AEdri' then 'Ahmed Edriess' else
Case when ledgerjournaltable.createdby = 'Aelsa' then 'Ahmed elsahhar' else
Case when ledgerjournaltable.createdby = 'Ahabd' then 'Ahmed Abdel Naby' else
Case when ledgerjournaltable.createdby = 'aibra' then 'Aymen Ibrahim' else
Case when ledgerjournaltable.createdby = 'AKama' then 'Amr Kamal' else
Case when ledgerjournaltable.createdby = 'amahe' then 'Ahmed Maher Saad' else
Case when ledgerjournaltable.createdby = 'AmFat' then 'Amr Fathy' else
Case when ledgerjournaltable.createdby = 'arabi' then 'AAshraf rabie'else
Case when ledgerjournaltable.createdby = 'ATaha' then 'Ahmed Taha'else
Case when ledgerjournaltable.createdby = 'ausam' then 'Ahmed Usama Salama'
end
end
end
end
end
end
end
end
end
end
end)
from ledgerjournaltable

where  
ledgerjournaltable.createdby = 'AAshr' 
or ledgerjournaltable.createdby = 'AEdri'
or ledgerjournaltable.createdby = 'Aelsa'
or ledgerjournaltable.createdby = 'Ahabd'
or ledgerjournaltable.createdby = 'aibra'
or ledgerjournaltable.createdby = 'AKama'
or ledgerjournaltable.createdby = 'amahe'
or ledgerjournaltable.createdby = 'AmFat'
or ledgerjournaltable.createdby = 'arabi'
or ledgerjournaltable.createdby = 'ATaha'
or ledgerjournaltable.createdby = 'ausam'

group by createdby,Dataareaid

Msg 125, Level 15, State 4, Line 13
Case expressions may only be nested to level 10.

خطأ عندما يزيد عدد الشروط الخاصة بــ Case when

مواضيع مشابهة