 --------------------------Ali 2021-03-03--------------------------------

   INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'ApiWorked',N'Api Worked',N'يعمل بــ Api',N'false',1,15,1,1,Null,Null,Null)
Go
 --------------------------End 2021-03-03--------------------------------
 
 --------------------------Ali 2021-03-09--------------------------------
 INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3974, N'اظهار كل الطلبات', N'display All Requests', 399, 2)
 Go
 --------------------------End 2021-03-09--------------------------------
 ------------------------Mahmoud Elsayed 2021-03-21----------------------
 WF_TypeResidencyFeesARHeaders
 
SELECT '29' AS [RequestTypeCode],  [1], [2], [3], [4]  ,[5]  
FROM  (SELECT [TypeResidencyFeeCode], [Arabic_Name]   
    FROM [dbo].[WF_TypeResidencyFees]) AS SourceTable  
PIVOT  
(  
max ( [Arabic_Name])  
FOR [TypeResidencyFeeCode] IN ( [1], [2], [3], [4]  ,[5] )  
) AS PivotTable;
-----------------------End 2021-03-09---------------------------------