StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
3453947
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2010-08-10T22:23:40.557
FavoriteCount
0
LastActivityDate
2010-08-11T02:18:36.457
LastEditDate
2010-08-11T02:18:36.457
LastEditorUserId
334849
OwnerUserId
334849
ParentId
3453758
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
Assuming your table is named Contacts: <pre><code>SELECT RecordId, C1.PersonId, 'Initial Record' AS RecordStatus FROM Contacts C1 INNER JOIN (SELECT PersonId, COUNT(PersonId) as PersonCount FROM Contacts GROUP BY PersonId) C2 ON C1.PersonId = C2.PersonId WHERE SentDate IS NULL AND PersonCount = 1 UNION SELECT RecordId, C1.PersonId, 'Follow Up Record' AS RecordStatus FROM Contacts C1 INNER JOIN (SELECT PersonId, COUNT(PersonId) as PersonCount FROM Contacts GROUP BY PersonId) C2 ON C1.PersonId = C2.PersonId WHERE SentDate IS NULL AND PersonCount > 1 ORDER BY RecordId </code></pre> The query works by assuming that if a PersonId only exists once in the table, it's an initial record; otherwise, it is a Follow Up Record. EDIT By popular demand, now with 100% less UNION! <pre><code>SELECT RecordId, C1.PersonId, CASE WHEN PersonCount > 1 THEN 'Follow Up Record' WHEN PersonCount = 1 THEN 'Initial Record' END AS RecordStatus FROM Contacts C1 INNER JOIN (SELECT PersonId, COUNT(PersonId) as PersonCount FROM Contacts GROUP BY PersonId) C2 ON C1.PersonId = C2.PersonId WHERE SentDate IS NULL </code></pre> EDIT 2 It's probably overkill, but here's my first shot at a CTE version: <pre><code>With PersonCountCTE (PersonId, PersonCount) AS ( SELECT PersonId, COUNT(PersonId) AS PersonCount FROM Contacts GROUP BY PersonId ) SELECT RecordId, C1.PersonId, CASE WHEN PersonCount > 1 THEN 'Follow Up Record' WHEN PersonCount = 1 THEN 'Initial Record' END AS RecordStatus FROM Contacts C1 INNER JOIN PersonCountCTE C2 ON C1.PersonId = C2.PersonId WHERE SentDate IS NULL </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. PONeed help creating complex T-SQL SELECT statement
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USLittleBobbyTables
UserOwnerUserId
1. USLittleBobbyTables
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. PONeed help creating complex T-SQL SELECT statement
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.