Search results for query: *

Great, thanks for the help! I've got what i need now. a star for the spot on help...

thanks, i didn't think of that. can you explain exactly what happen when you run a Truncate sql on a table? Specifically, does it delete the rows AND free up all space previously used? (whereas simply deleting rows does not free up the space, apparently)?

I have an application that tracks a weekly SLA for something, and resets at the end of the week. the table used is ONLY used for that, and so, we need to essentially empty the table at the end of the week. (Sunday midnight) Question - which is better (for size and performance) a) - just...

Responses inline... >If John Smith is in the database twice with one email, you want him 1 time? YES >If John Smith is in the database twice with two emails you want him twice, once for each email? YES >If Larry Smith and John Smith (brothers that share a computer) are both in the database...

Thats interesting, I got back both values when i used that SQL (thats the sql i used in my first try) I read up on it, and it said that because the SQL saw the ROW as different based on the three columns, it returned both. So, your example was returning both of those larryjones@yahoo.com rows...

I'm wondering if this is set up in the best way. Basically I need contact_email, contact_name, contact_id, but no duplicates for contact_email ONLY. IE - I WANT the record if it has the same NAME as another, but has a different email...and so on... msql = "SELECT distinct contact_email...

I have an input box where the user enters a sku. When this has been entered, and the cursor leaves the input box, I need to pop up a window with a new url that includes the sku Any ideas?

Hello Everyone, I need to build a query and I'm having a terrible time getting my head around it. Here are the details of the tables: Table1: MESSAGES Table2: FOLDERS Each message, in the messages table is assigned a folder by FOLDER_ID. I want to count messages in the MESSAGES table that...

That didn't do it...now i get an SQL error: ORA-00933: SQL command not properly ended

didn't quite work..i get an sql err now sql = "select count(*) from kc_message inner join kc_folders on kc_Messages.folderid = kc_folders.folderid where kc_messages.completedate is null and (kc_messages.createdate >= to_date('" & hours_ago & "','mm/dd/yyyy hh:mi:ss " & am_or_pm(1) & "')) and...

Hello Everyone, I need to build a query and I'm having a terrible time getting my head around it. Here are the details of the tables: Table1: MESSAGES Table2: FOLDERS Each message, in the messages table is assigned a folder by FOLDER_ID. I want to count messages in the MESSAGES table that...