I have a bit of experience with T-SQL and have done a lot of things with it over the years. The one thing that I feel is most of need for me that I am missing is how to approach complex program requirements when designing queries, sprocs, functions etc...
Programmers use mock code to outline the steps to their programs but is there a systematic, step-by-step methodology that you use when designing and working out a SQL problem or can you provide reference to resources?
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))