I can understand how that would make things a little easier, but I'm not sure how that would help in rebuilding the People_Positions table in terms of the PositionID which...
I realized that I cannot use the MERGE function as we are running SQL Server 2005, so let me throw another question out there. Let's say I have three tables:...
It seems when using PIVOT, you have to specify the column names, but given that I will have many different dates in my table, how can I specify those column...