add header to the web api globally

 builder.Services.AddSwaggerGen(c =>

{ c.OperationFilter<AddRegionCodeHeaderParameter>(); c.EnableAnnotations(); c.SwaggerDoc("v1", new OpenApiInfo { Title = "Patient Web API", Version = "v1" }); c.OperationFilter<AddRegionCodeHeaderParameter>(); });

Same EMployee have 5 recrods to get only one record.

 

WITH RankedRecords AS (

    SELECT 

        *,

        ROW_NUMBER() OVER (PARTITION BY AppraisalID ORDER BY ModifiedDate) AS RowNum

    FROM 

        tbl_EmpCompetencies

)

SELECT *

FROM RankedRecords

WHERE RowNum = 1;