Jun
23
comment SQL Server: Need query to get records by comparing one of it's field with different values
post your original working php code for that solution and i am sure it can be accomodated.. you only need to mess with where clauses, you could add more selects to the union to cover more cases
Jun
19
revised SQL Server: Need query to get records by comparing one of it's field with different values
typos
Jun
19
comment SQL Server: Need query to get records by comparing one of it's field with different values
Just DATEADD as far as i am aware.. msdn.microsoft.com/en-us/library/ms186819.aspx SELECT DATEADD(day,1,Now()) AS Tomorrow
Jun
19
awarded Supporter
Jun
19
revised Applying the count function within the case function
added 179 characters in body
Jun
19
answered Applying the count function within the case function
Jun
19
revised SQL Server: Need query to get records by comparing one of it's field with different values
added 900 characters in body
Jun
19
comment SQL Server: Need query to get records by comparing one of it's field with different values
you want a query to return what is showing now? - I think the above query does what you ask. except you have not specified a duration when i wrote it.
Jun
19
revised SQL Server: Need query to get records by comparing one of it's field with different values
added 399 characters in body
Jun
19
revised SQL Server: Need query to get records by comparing one of it's field with different values
added 399 characters in body
Jun
19
comment SQL Server: Need query to get records by comparing one of it's field with different values
how do you define a monthly schedule? same day of the month?
Jun
19
comment SQL Server: Need query to get records by comparing one of it's field with different values
maybe fixed.. hopefully someone knows a better way of comparing times that this :) do you know what you are asking for?
Jun
19
revised SQL Server: Need query to get records by comparing one of it's field with different values
added 399 characters in body
Jun
19
comment SQL Server: Need query to get records by comparing one of it's field with different values
sorry there is a really stupid bug in this.. fixing, its ignoring the date
Jun
19
answered SQL Server: Need query to get records by comparing one of it's field with different values
Jun
19
comment SQL Server: Need query to get records by comparing one of it's field with different values
do you mean you want to know wha tis on in the next say 30 mins based on repeating schedules starting at that date and time with that frequency?
Jun
16
comment String.Format in javascript?
@vittore thanks.. i managed to confuse my self trying to test too much too fast!
Jun
16
comment Javascript: something like string.format with property names
also you used double curly brackets which i was hoping to switch to but was not confident in regex modification ;)
Jun
16
comment Javascript: something like string.format with property names
Thanks very much.. turns out the example i posted worked but it was me being an idiot. however i prefer your solution as i actually understand how it works and can debug it :D
Jun
16
accepted Javascript: something like string.format with property names
1 2 3 4 5