Apr
22
awarded Famous Question
Apr
9
awarded Notable Question
Apr
8
comment How do I fill a temp table iteratively and stuff() the result into columns?
@RuslanK. - No it must not. The only input is a date. The function retrieves a distinct list of users that were logged in on that day first, and then retrieves the total time spent on the website from another table :)
Apr
8
asked How do I fill a temp table iteratively and stuff() the result into columns?
Apr
4
comment How can I run my custom function and query in a loop for different time frames?
I will query another table for distinct dates. Then, every two dates are input for this SQL. So: date1 (=begin) date2 (=end), date3 (=begin) date4 (=end) etc.
Apr
1
comment How can I run my custom function and query in a loop for different time frames?
[JamesZ] - I have to do this in SQL because I have to run it in a dashboard tool for management that only supports queries [Tom H] ranges are defined as 2 timestamps (dateBegin and dateEnd) [Sean Lange] correct, dynamic pivot. The pivot part I can do; i have read the other posts but the dynamic query is something i am struggling with.
Apr
1
asked How can I run my custom function and query in a loop for different time frames?
Apr
1
comment Checking for inconsistent values within groups
My bad. I forgot in the OP...many times, level will be NULL. If there is a group with documents that have NULL, these should also be displayed. By coincidence, @Gordons answer returns this result. Agreed, it was not in the specification. Took away the accepted answer. However, how would your solution look like to also display NULLs?
Apr
1
comment Checking for inconsistent values within groups
this only returns the deviating rows. I was looking for the full inconsisten group to be displayed. upvote for helping me out though!
Apr
1
comment Checking for inconsistent values within groups
this only returns the deviating rows. I was looking for the full inconsisten group to be displayed. upvote for helping me out though!
Apr
1
comment Checking for inconsistent values within groups
marking this answer as correct one as this one returns the full groups, instead of the deviating rows :)
Apr
1
asked Checking for inconsistent values within groups
Apr
1
accepted Display resultset in tabular format -- in SQL
Mar
31
comment Display resultset in tabular format -- in SQL
@alessalessio SQL scripts, yes. I mean, no other scripts. Usually, I would loop through the resultset in Powershell for instance, and write the table to a file.
Mar
31
comment Display resultset in tabular format -- in SQL
No it's not. The number of dates and users are unlimited.
Mar
31
asked Display resultset in tabular format -- in SQL
Mar
31
accepted Documents read per user per day
Mar
31
revised Documents read per user per day
added 616 characters in body
Mar
31
asked Documents read per user per day
Mar
25
accepted Check address voor 2 properties and display in same row
1 2 3 4 5