Search results for query: *

still couldn't get past that error... Thanks for all your help though, I appreciate it!

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)...

thanks again, I made the changes to the reflect the source table. any idea why i am getting the error message regarding the close paren?

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 count I would be looking to (in this case) would be 55 days. Is that helpful?

Yes, I need to count 2/17 in the range. The ranges will overlap, but I need to count them only once.

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...

Thanks Rudy! Have a great holiday!

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...