Recent content by marksmithy69

Hello everyone. I am brand new to mySQL, so I am not sure if this can be done. Is there a way to capture a schema. I am taking over a number of databases, and I'd like to get a better understanding of each database. Thanks in advance.

Works great. Thanks a lot everyone for your help.

Thanks for your reply. That takes care of the decimals, but I am not sure that the calculation is correct. For example, if I put in 6/8/2005 2:56:31 PM and 6/12/2005 12:23:23 PM, it says 1.89365741. That doesn't seem to be correct, since there are at least 2 work days between those 2 dates...

Well, for example if I wanted to get the difference between 6/8/2007 2:56:31 PM and 6/12/2007 12:23:23 PM. Thanks again.

I just wanted to thank you guys for the excellant code. It was a great help. How can I modify it to include decimal places as well. For example 3.69 days. Thanks again.

Hello everyone. Is there an easy way to get the get the difference between 2 dates, but exclude weekends from the difference? Thanks again.

Thanks everyone for your help!!

Hello everyone. I currently have a simple table, DAILY, containing various daily transactions. The table has a date column, transaction 1, transaction2, transaction3 etc. Example: DATE Transaction1 Transaction2 Transaction3 1-1-2007 5 3...

Hello everyone. I have a table with a DATE column, which defaults to the sysdate during inserts etc.. It's format is 4/26/2007 3:26:22 PM. How can I select all records from this table, where this DATE is between two prompted dates? I am a newbie, so I apologize for the simple question...

Hello everyone. I am a newbie to Oracle and I am hoping someone may be able to help me. We have a few local workstations which have a runtime installation of Oracle Client 9i on each. I have been given the task of investigating whether or not to apply patch CPU April2007. This patch fixes...

Thanks a lot guys. Both examples worked great. I appreciate your help.

I am a total newbie to SQL Server, so I apologize for the simple question. Is there a way to search through all stored procedures for a text string? Thanks a lot.

There is no slash. I tried with and without a slash, with the same result. The weird thing is, it executes fine on other databases, so the script is fine. We just have a handfull of databases where we get this error.

No...you can view the script in my original entry.

Following up with Beilstwh, if I run 'show errors', it says no errors: SQL> @p_chp_proc.sql SP2-0734: unknown command beginning "p_chp_proc..." - rest of line ignored. SQL> show errors No errors.