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

Sep
5
awarded  Popular Question
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)