network profile
| bio | website | dublintech.blogspot.com |
|---|---|---|
| location | Dublin, Ireland | |
| age | 38 | |
| visits | member for | 1 year, 4 months |
| seen | Feb 15 at 10:29 | |
| stats | profile views | 36 |
|
11h |
awarded | Notable Question |
|
Apr 25 |
awarded | Popular Question |
|
Mar 5 |
awarded | Popular Question |
|
Mar 1 |
awarded | Popular Question |
|
Feb 14 |
awarded | Popular Question |
|
Feb 9 |
awarded | Yearling |
|
Aug 16 |
asked | Architectural Question about Data analytics |
|
Jul 31 |
accepted | creating an index for varchar column greater than 900 bytes |
|
Jul 24 |
accepted | List Prepared Statements |
|
Jul 24 |
asked | List Prepared Statements |
|
Jun 21 |
accepted | Group by minute and two minute intervals |
|
Jun 20 |
comment |
Passing in the table into a stored procedure @Cade Roux super help. Thanks. I use your approach. I end up passing the table function to a stored procedure. The table function can take a variable so it works ok. |
|
Jun 20 |
accepted | Passing in the table into a stored procedure |
|
Jun 20 |
comment |
Passing in the table into a stored procedure @Cade Roux thanks. Why do you include the bit... INNER JOIN Ranges ON LogData.Dt >= Ranges.DtStart AND LogData.Dt < Ranges.DtEnd |
|
Jun 20 |
comment |
Passing in the table into a stored procedure @Cade Roux Sorry just a bit confused. Where is the itvf in the code sample? |
|
Jun 20 |
comment |
Passing in the table into a stored procedure Thanks for all comments. I have created separate question regarding passing in a range of date ranges into procedure as I think it is a valid question in its own right. |
|
Jun 20 |
comment |
Passing in the table into a stored procedure @Cade Roux can you elaborate on the idea of a table with date ranges? What happens if one set of ranges contains 4 begin / end dates and another 5? Should each column be a datetime or what? Many thanks. |
|
Jun 20 |
comment |
Passing in the table into a stored procedure I am just doing some analysis of logfiles from a website. Every row in a table represents a HTTP request. The views give me important time periods. I have one very fancy join which gives me a load of information and then I run this fancy join for various HTTP URLs. |
|
Jun 20 |
comment |
Passing in the table into a stored procedure Is it possible to express a set of datetime ranges as single variable? For example, I create the views as: create view myview1 as select * from allrequests where datetimesent between '2012-06-11 05:00:00.000' and '2012-06-11 10:07:00.000' or datetimesent between '2012-06-12 05:00:00.000' and '2012-06-12 11:07:00.000' or datetimesent between '2012-06-13 05:00:00.000' and '2012-06-13 10:03:00.000' or datetimesent between '2012-06-14 05:00:00.000' and '2012-06-14 14:19:00.000' or datetimesent between '2012-06-15 05:00:00.000' and '2012-06-15 11:00:00.000' |
|
Jun 20 |
comment |
Passing in the table into a stored procedure expectation is date ranges are unlikely to change that much, but you might want to query different things from the various ranges. |
