I'm all for empowering the user. As long as it is in a controlled environment.

Since corrections have been made in the past I always check the answer I give in the newsletter is the same in the forum, maybe I missed this one

quote:

---

I suggest a big points bonus for answering on the day. Any comments?

---

Would be...

I could see this generating some interesting comments.

I cannot say which I prefer.

A previous employee built a database to hold info about our dealer network. This database has a...

I agree.

quote:

---

At what memory point must you set the /PAE ...

---

The important word...

See if this works using a temp table.

CREATE TABLE #A(ID1 int,ID2 INT, 

RowID nvarchar(15), 

Created Datetime,CreatedBy nvarchar(25), 

Field nvarchar(25), 

OldValue nvarchar(25),NewValue nvarchar(25)) 



INSERT INTO #A...

Managers who think I am a f*****g fireman. You tell them 'disk nearly full', 'disk is really nearly full', 'disk is full', 'disk is f*****g full'. Then a user tells...

Try this, it may do it.

SELECTa.RowID, 

a.Created, 

a.CreatedBy, 

a.Field, 

a.OldValue, 

a.NewValue 

FROMAuditTbl a 

ORDER BY a.RowID, 

a.Created, 

a.Field, 

(CASE WHEN (SELECT TOP 1 NewValue 

FROM...

I think your problems occur from the structure of the event data and it being on multiple lines. The following script which you can use to preprocess the comma separated...

If that is the windows event log then I see your problem. The only thing I can suggest is to preprocess the file with an application or ActiveX script and...

Not sure what your question is but presume the problem is with identical datetime's. If you want to guarantee sequence of events in AuditTbl and BaseTbl then add an IDENTITY...

I cannot reproduce the error and without the table definition,dts and data it is difficult to see what the problem is. If the data may contains extra columns you could...