Oh no, it's got diarrhoea, I'm drowning in emails......

glug glug .....

Hi Frank,

Thanks a lot mate. I have just received a posting notification email

Hi Frank,

quote:

---

It happened to me that all of a sudden all my subscription seems to be dropped. You can easily check...

Still not getting any

quote:

---

edwin_fredrick: generally when I'm saying something I mean as a joke or not to be taken seriously I stick a smiley at...

Can you post small sample of initial data and a list of results you expect after the update.

Can you be more explicit in your requirements. Table ddl, sample data and any output that is expected.

Edited by - davidburrows on 10/23/2003 06:36:53 AM

The error is an access denied/permissions error. Is sql running under system account or domain account? If system account, I believe you cannot access files across network, if domain account...

Do not know anything about Baan (ERP) but can you convert 01/01/0001 dates to 01/01/1900 which would be sql server equivalent.

In your example you are trying to run the procedure not create it. What you need to do is create a text file containing the create procedure and associated details...

Yeh pat yourself on the back, sycophants united. No one likes a smart a$$

Besides, the higher your pedestal the further you fall.

Is there still a problem with 'emails for postings'? I haven't received any for weeks

I do get the newsletter though

The only way to stop the error is not to let it happen by checking for constraint violations before insert/update. This however could cause you to write a lot of...

Studying the file, 2 problems. One is that there are 7 records per painting with the 7th line either missing or blank. Second the file does not contain CR/LF at...