SQL Server: Creating a Join between Two Table Valued Expressions (TABLE VARIABLE and TABLE VALUED FUNCTION)
In my never ending quest to completely phase out SQL cursors, I am truly discovering some truly awesome features about SQL Server that I have never looked deeply enough before to consider. My requirement: I need to determine the total value for a project based on a set of monthly deliverables. These deliverables each…