The thing that I would want to see is initiative. Listing the books read along with a professional certification as a plus  shows me this person is not only motivated,...

One of the great times in my career was when I was hired to complete a difficult task that took months and months of planning and building and testing. It...

Here the SQL solutions presented are just patchwork as this is really a design problem. Now you probably cannot go and change things in a table or a ETL process...

Im still stuck on the point that SSIS did not error out when the data in the source file did not match the expected meta data. IS there a configuration...

NTILE be incorporated in all versions to give a median, but the code is lengthy and not as clean as presented here.

Pl

Seems to me that it should be that each row is the column delimiter and the row delimiter is the start of the token '1H ...'. However the data presented...

Glad to hear it Patrick. Of course as is usually recommended when taking a solution from the Internet, take time to make sure that you understand the logic as you...