KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a table that has the following columns Id ForeignKeyId AttributeName AttributeValue Created Some of the data may look like this: 1, 1, 'EmailPreference', 'Text', 1/1/2010 2, 1, 'EmailPreference', 'Html', 1/3/2010 3, 1, 'EmailPreference', 'Text', 1/10/2010 4, 2, 'EmailPreference', 'Text', 1/2/2010 5, 2, 'EmailPreference', 'Html', 1/8/2010 I'd like to run a query that pulls the most recent value of the AttributeValue column for each distinct ForeignKeyId andAttributeName, using the Created column to determine the most recent value. Example output would be: ForeignKeyId AttributeName AttributeValue Created ------------------------------------------------------- 1 'EmailPreference' 'Text' 1/10/2010 2 'EmailPreference' 'Html' 1/8/2010 How can I do this using SQL Server 2005?
Tags (comma-separated)
Save Edits
Cancel