353 reputation
211
bio website smelser.net/Blog
location Ireland
age
visits member for 2 years, 3 months
seen Mar 19 '13 at 22:08

Yet another person contributing to the World Wide Parking Lot... I am a software engineer, blogger, and all around Star Wars nerd.


Mar
29
awarded  Popular Question
Jan
23
awarded  Notable Question
Nov
7
awarded  Popular Question
Aug
1
awarded  Nice Question
May
22
awarded  Popular Question
Mar
19
awarded  Popular Question
Jan
21
awarded  Yearling
Nov
5
accepted Pivoting row contents to produce one dimensional result
Nov
5
asked Pivoting row contents to produce one dimensional result
Oct
25
accepted Calculating Median Value within a Group By
Oct
25
comment Calculating Median Value within a Group By
SQL Server 2008 and SQL Azure
Oct
25
asked Calculating Median Value within a Group By
Oct
2
accepted Detecting if bit set in numeric value
Oct
2
asked Detecting if bit set in numeric value
May
10
accepted Grouping records based on intervals of time
May
10
comment Grouping records based on intervals of time
This provided a nice framework for the answer, but I am still having a little trouble understanding how this works. When I tried to change the offset from a 1 minute interval to a 5 minute interval I still get a 1 minute interval with the whole result starting at a different beginning point. This is very likely because I am misunderstanding how this works. Could you provide one more sample showing an interval other then 1 minute? Thanks...
May
9
asked Grouping records based on intervals of time
Apr
22
accepted Implementing an encrypted table in SQL Azure
Apr
14
asked Implementing an encrypted table in SQL Azure
Apr
13
asked What is the name of this schema pattern