What were the most difficult things you had to code in SQL?

1

What were the most difficult things you had to code in SQL?

Thanks!

2

Mine was coding a stored procedure to be used with SSRS and be able to accept a cascading parameter in either order (date first and projects associated with that date second or project first and dates associated with that project second). It was pretty intense.

1 Like
3

The first time I had to solve a "gaps and islands" problem was pretty challenging. We had a system that would create a new row representing a customer's enrollment (like a subscription) any time a change was made, significant or not. But for almost every reporting purpose, we really only needed to see when they started and when they ended in a single record for every contiguous period of time. Learning how to do that 3-4 different ways in different scenarios opened my mind up to a whole world of problem solving.

1 Like