Hi mates, I have a table defining ranges, e.g.: START | END | MAP 1 | 10 | A 11 | 15 | B ... how do I query into that table so the result will be ID | MAP 1 | A 2 | A 3 | A 4 | A 5 | A 6 | A 7 | A 8 | A 9 | A 10 | A 11 | B 12 | B 13 | B 14 | B 15 | B ... I bet its a easy one... Thanks for the help f. ...
Are there any techniques that would allow a row set like this WITH base AS ( SELECT 1 N FROM DUAL UNION ALL SELECT 2 N FROM DUAL UNION ALL SELECT 3 N FROM DUAL UNION ALL SELECT 6 N FROM DUAL UNION ALL SELECT 7 N FROM DUAL UNION ALL SELECT 17 N FROM DUAL UNION ALL SELECT 18 N FROM DUAL UNION ALL SE...
Does VBA support using an array of range variables? dim rangeArray() as range dim count as integer dim i as integer count = 3 redim rangeArray(1 to count) for i = 1 to count msgbox rangeArray(i).cells(1,1).value next I can't get it to work in this type of application. I want to store a series of ranges in a certain order as a "ma...
I'd like to write a VBA function that has a Range as an optional parameter. For instance something like: Public Function testfunc(S As String, Optional R As Range) As String testfunc = S For Each cell In R testfunc = testfunc + cell Next cell End Function I tried the function above, but I get a #VALUE! error. I also tried wrapping the...
Possible Duplicate: 90 days range using SQL server I am trying to get the counts 90 days prior to the operational date and the counts 90 days after the operational date. For example, my operational date is 4/1/2004. So,90 days prior to 4/1/2004 is (1/2/2004 to 3/31/2004) and 90 days after (including 4/1/2004) is 6/29/2004. I ...