Welcome to EMC Consulting Blogs

In my current day job I’m doing a lot of work against an Oracle back-end and I’ve just come across a situation where I need to do some string aggregation. Effectively I needed to turn this: Parent Child Charles William Charles Harry Anne Peter Anne Zara Andrew Beatrice Andrew Eugenie into ...

Hi, following on from my previous two posts about Analytic Functions, and specifically about the lack of a T-SQL equivalent to the LAG and LEAD functions I demonstrated, there is a SQL Server feedback vote currently active which you can participate in if you are interested in seeing these functions incorporated into a future update. The vote can ...