Search results for query: *

Thanks everyone for your help. I think the solution PHV provided will work for me. The query takes a little time to complete but its workable. Thank you

ok, TableA is 30,000 rows and TableB is 12,000 rows. This query is just locking up my machine. Any other suggestions?

Thanks - much simpler than expected. This is working right now with some dummy tables/data. I'll try it on the real thing and get back to you. I'm not sure but these tables may be quite large so I'm not sure how this will perform. Thanks again.

I'm using Access 2003 and here's my problem: I have a text field that contains a string of characters that I need to strip out. The string of characters could be anywhere in the text and may or may not be separated by spaces. I also have a table that contains all of the strings that I'm...

Yes, I believe this will work for most instances and for my example, but not every record change falls on the day after the previous value ended. For example, the name on a record could end and the record could be nameless for a period of time before a new name was appended to the record. How...

I'm querying a history table using Access 2000, and I'm having trouble getting the results in the format that I need. I can't seem to figure out how to build the query. Here's the issue: The history table is structured as follows: cust_num cust_name name start end 2184087...

My apologies - I just realized I posted this to the wrong forum. I will repost in the correct forum.

I'm querying a history table using Access 2000, and I'm having trouble getting the results in the format that I need. I can't seem to figure out how to build the query. Here's the issue: The history table is structured as follows: cust_num cust_name name start end 2184087 tbd jim...

Hello - I've been working on a project that involves manually importing a spreadsheet every day into Access. When I import the data, I append it to a single table. So ultimately, I end up with one table that grows every day. The spreadsheets that I import are automatically generated each day...

Sorry for the lack of information, here's a bit more... I'm not really using 'COLUMN' as a column name. When I posted the query to the forum, I changed some of the names to make it a little easier. I'm converting the Top N subquery to use the ROWNUM function in Oracle. This is what I have...

I'm trying to convert the following MS SQL to Oracle PS/SQL but not getting anywhere. I'm having problems converting the top N part of the query to use Oracle's ROWNUM function. That part of the query is already a sub-query and nesting 2 sub-queries is giving me a problem. Any suggestions...

This seems to work great! Thanks. Let me apply it to my "real world" example and see what problems I have with that.

Yes, I've been looking through these forums for a couple of days. I need to get the data the way Elegabalus described with his second bit of code.

This is exactly what I am trying to do but I'm running on SQL Server 2000 and can have a max of 4 columns returned. I don't think the ROW_COUNT() or PIVOT() functions are available. Any thoughts?

Wow, this is great! Thanks so much for the help. I just went through this and the results are what I'm looking for. I'll be sure to reply with any questions further down the road but this will get the job done. Thanks again!

Sorry, but I'm not seeing how I could easily get individual dates and number of records for each date. Can you elaborate? I'm not worried about the pivot part - I think I handle that as long as I can get counts for each date. Thanks for your help.

There isn't a calendar table that I know of. If that is what is needed, I could ask for it to be implemented. Would it basically be a table listing all dates? Could you let me know what the query would be like if I did have a calendar table?

I'm trying come up with a select statement to help report on the history of a record. I have a table like the following: Record Start End 123 2/26/2006 3/10/2006 123 3/15/2006 3/16/2006 145 3/04/2006 3/07/2006 154 3/20/2006 3/25/2006 154 3/27/2006 3/30/2006 135 3/01/2006 3/26/2006 178...

querying a MS SQL 2000 database I have a table with the following: Id Num Date Old Val New Val 20 1 12/22 nothing something 20 2 12/23 something nothing 20 3 12/29 nothing something 20 4 01/10 something nothing I'd like to have a query that returns the number of days that...

Thanks byundt - The formula works great!