JackNBox

Received working answer from "Will Kong" TechNet: create table tblProjectSnapshot ( [ProjectUniqueID] varchar(30), [SnapshotDate] date, [SnapshotID] int, [ProjectName] varchar(64), [Status] varchar(64) ) insert into tblProjectSnapshot values ('A','1/1/2020',1,'Orange','Open'), ('B','1/1/2020',2,'Apple','Open'), ('C','1/1/2020',3,'Carrot','In Progress'), ('A','2/1/2020',1,'Orange','Open'), ('B','2/1/2020',2,'Apple','Closed'), ('C','2/1/2020',3,'Carrot','In Progress') GO create table tblMilestoneSnapshot ( [SnapshotDate] date, [SnapshotID] int, [ProjectName] varchar(64), [MilestoneS

Is my above post not created properly or is it an overly difficult question?

Hello, I need help writing a query for SQL Server 2008 (SP2). The purpose of the query is to show changes to specific fields being tracked over time using table snapshots taken multiple times a month. The database table looks like this: Source tblProjectSnapshot: [ProjectUniqueID], [SnapshotDate], [SnapshotID], [ProjectName], [Status] A, 1/1/2020, 1, Orange, Open B, 1/1/2020, 2, Apple, Open C, 1/1/2020, 3, Carrot, In Progress A, 2/1/2020, 1, Orange, Open B, 2/1/2020, 2, Apple, Closed C, 2/1/2020, 3, Carrot, In Progress Source tb