780 reputation
1618
bio website sblackler.net
location Bournemouth, United Kingdom
age 24
visits member for 2 years, 9 months
seen Mar 31 at 11:05

I am a self-taught programmer originating from the Isle of Wight. I have approximately 3 years commercial experience in developing LOB applications for a wide range of customers (local companies to FTSE 100). During this time, I have honed my development skills across a wide range of platforms and frameworks including C#, VB.net, T-SQL, Web Services and Android programming.

I am currently training towards my MCSA SQL Server 2012 qualification alongside my degree in Computing from Bournemouth University (Graduating 2013). During my time at Bournemouth University, I have built an extensive knowledge in core networking protocols and architecture including TCP, IP (v4 & v6), DNS, ARP, HTTP, EMAIL (SMTP, POP3 and IMAP), WiMAX (802.16) and WiFi (802.11).


Aug
19
comment Advice with date column SQL Server 2005
please may you see the updated question for my reasoning for CTE and clarification on the original question. I thank you for you work so far :)
Aug
19
comment Advice with date column SQL Server 2005
please may you see the updated question for my reasoning for CTE and clarification on the original question. I thank you again for you work so far :)
Aug
19
revised Advice with date column SQL Server 2005
added clarification
Aug
18
comment Advice with date column SQL Server 2005
Slight problem in that your table t only has one date column (sorry if i wasn't clear on this). Mine has a start date and an end date. So I don't think it would work ? i'll try it. I've added my CTE version of your two cte's to the OP. Check it out.
Aug
18
awarded  Editor
Aug
18
revised Advice with date column SQL Server 2005
Added actual recursive query
Aug
18
comment Advice with date column SQL Server 2005
Thanks Richard. I will see what I can do about posting sample data etc tomorrow. Basically, the start and end date would be say Jan to Aug. In the table, there will start dates and end dates of say 3 days, some might even start and end on the same day. Does that make sense?
Aug
18
comment Advice with date column SQL Server 2005
Could you expand on "It may depend on how you get the value into the computed column as to if it'll work." For clarity for people returning to this thread (and me in the morning :D) Cheers
Aug
18
comment Advice with date column SQL Server 2005
Thanks for the link, just spent a good time reading. I will try it tomorrow and let you know how I fair. :) +1'd
Aug
18
comment Advice with date column SQL Server 2005
Basically, I need to count something between a date range when all I have a date range. With this way, I guarantee that I don't miss any record. I have tried it with <= >= etc but I have found that I missed records (this could be me though). Does this make sense? The CTE and CROSS APPLY parts work fine as I have them in other sub-second queries. Subsequently, I am trying to focus on the date part of the query
Aug
18
asked Advice with date column SQL Server 2005
Aug
18
comment What is blocking and how does it happen?
Nice essay +1 :)
Aug
17
accepted A question on SARGability
Aug
16
asked A question on SARGability
Jul
22
awarded  Scholar
Jul
22
accepted The use of NOT logic in relation to indexes
Jul
21
awarded  Student
Jul
21
awarded  Supporter
Jul
21
asked The use of NOT logic in relation to indexes