I believe i have the code working now :

but it just seems too long

CREATE TABLE #temp

(

Row_Ndb INT ,

...

I am facing another challenge. I tried to make the code work with no success. the issue i am facing is, i need to fill gaps also,

if the year...

Thanks Erin, the code worked beautifully. I appreciate your help.

Thanks Edwards,

the SQL Server certification path road-map is very helpful.

Thank you for sharing the link.

Thank you David for your prompt response, and taking the time to answer my questions. I think i can pass the test, i just didn't know what exam i need...

This is what happened. The store procedure is returning the value with header name(column) is Link, there is another process that use this value based on the header name so...

Thanks Jeff,

I will repost it and remove the links.

Thanks again.