I am using ColdFusion on a website hosting account and mssql (late version). I’m looking for all instances of the StoryID but I want to display only one record for each StoryID.  The storyid is a uniqueidentifier. Below is my query. It works but the problem is that  it shows multiple instances of the same storyid. Each unique storyid represents a news story where readers comment about that story. So I want to display only the first story comment but […]