699 reputation
519
bio website stackoverflow.com
location New York, NY
age 37
visits member for 3 years, 7 months
seen May 28 at 19:12

Jul
17
awarded  Popular Question
Jul
2
awarded  Curious
May
28
revised Finding duplicate data
added 79 characters in body
May
28
comment Finding duplicate data
duration of 2 minutes can be changes to 1 minute or 50 milli seconds. Body is nvarchar(max) and size is body plus attachments if any.
May
28
comment Finding duplicate data
you can copy past an email to someone a week later and recipients, subject, body... will all be the same. this is not a dup. I would consider a dup the same record of data where CrDate will be within 2 minutes of each record given the other fields are all identical.
May
28
asked Finding duplicate data
May
22
awarded  Notable Question
Apr
1
awarded  Popular Question
Feb
19
awarded  Popular Question
Jan
24
awarded  Yearling
Dec
28
awarded  Notable Question
Nov
7
awarded  Popular Question
Oct
7
awarded  Popular Question
Oct
3
awarded  Popular Question
May
30
awarded  Popular Question
Feb
1
asked Get counts grouped by month and year
Jan
24
awarded  Yearling
Dec
27
awarded  Popular Question
Dec
3
comment Can this SQL be made more efficient and combined into one select?
fyi; i up-voded the answer as it was pretty helpful. (question poster)
Nov
29
comment Can this SQL be made more efficient and combined into one select?
nice solution, and the bullet points are most helpful! thanks