no dice... :(
anything else I should try? Here is the entire code I've entered in from your suggestion..
create table integers (i integer);
insert into integers (i) values (0);
insert into integers (i) values (1);
insert into integers (i) values (2);
insert into integers (i) values (3)...
rudy
i plugged in what you suggested, however I'm getting an error message stating i'm missing a closing paren...
***it's stating that it's missing in line2, after the date--- did I miss something in the syntax???
***I also added a "from" statement to identify the table I am...
The ranges will between start_dt and end_dt will probably be no more than 90 days, the typical range is 30 days. The total range (from the first start_dt to the last end_dt will be no greater than 1 year-30 days)
Thank you for looking into this...
I'm having some difficulty with a query and hoping someone out there can provide me with assistance. What I am attempting to do is create one row, per id, and calculate the number of days (excluding gaps)
table_data:
id start_dt end_dt
1 1/23/2004 2/22/2004
1 2/17/2004...
I've been having a problem with the structure of a simple 'no-match' query. For example, I have two tables... Table 1 and Table 2. I want to pull all the records from table 1 that are not in table two.
Table 1 Table 2
Id Id
Here's what I've written, but I'm a bit stuck...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.