Hi,

how much is it???

Hi,

I've given your recommendations to my DBA... Thanks so much...

How do I query with the cmdShell to get the file Name, Modified Date, and Created Date...

Thanks,

John

Would love it if you shared them for sure... Thanks

I like your idea of building the stored procedure to have the privs...

Can the trigger have the privs?

Hi,

Your code would need to co-exist in my trigger l posted earlier...

I could use your to create and inline table function and pass in the location and file name... I...

This DB is proprietary, so we can't make any changes to the code behind the GUI!.. I can place triggers on the table...

So the form, is showing what files...

Jeff,

The user is in the DB via GUI, they click a button on the form the basically says, "Lets look at new faxes that came in", and this form reads...

Well, hello!!!!

Big fan of yours...

I'll explain what I'm doing, or why... I inherted a commercial database, that isn't so great... lot's of redundant data, seems no real normilization...

So, the...

Ah, the Table-Valued Functions... yes, I can do that...

I haven't heard of CLR, do you have any examples I can borrow???

Dwain,

Thats perfect... I never ever thought to divide by 2... Genius you are!!! lol

I appreciate everyones reply's as well!!!

Thank you,

John

I will for sure be trying this...

I have to fix code that extract's the date from the text; so I can try my example data I posted and see how...

Thanks for the code Bill... Works great when there's a date, but think it broke when it runs into text or some other format that i didn't provide as an...

Yes.... I assume you used my code as well? Difference is I have 800 records and you have 20... this is my max value 23:59:47.8000000

Thanks

Thank you guys...

Geoff,

I'm getting the error "Arithmetic overflow error converting expression to data type int."

Is it because the column is a Data Type of Time?