The first UNION that you did filtered out the second row because it was identical to the first.  Your second UNION has rows which are not identical - so they...

Me neither - can't you just give them a longer description?  This is building complexity that seems over the top.  Are your users particularly (hmmm, what's a nice way of...

I don't think it's as simple as just clicking a 'process all files in folder' check box - unfortunately.

Here's an article that might be of use to you though -...

OK - I think I was on the right track except for the JOIN:

CREATE PROCEDURE sproc_getTestRequest

AS SELECT   tr.[TestRequestNo],

  tr.[TestFolderNo],

  tr.[TestRequestObjective],

  tr.[TestRequestDescription],

  tr.[RequestType],

  tr.[TestRequestSentDate],

  tr.[TestRequestReceivedDate],

  tr.[ExpectedPartsReceivedDate],

  tr.[RequestedStartDate],

  tr.[RequestedCompletionDate], p.*

FROM TestRequest tr...

IsNumeric is available in SQL Server:

select IsNumeric('Hello'), IsNumeric(42)

It sounds to me like you need something like this:

SELECT   tr.[TestRequestNo],

  tr.[TestFolderNo],

  tr.[TestRequestObjective],

  tr.[TestRequestDescription],

  tr.[RequestType],

  tr.[TestRequestSentDate],

  tr.[TestRequestReceivedDate],

  tr.[ExpectedPartsReceivedDate],

  tr.[RequestedStartDate],

  tr.[RequestedCompletionDate], p.*

FROM TestRequest tr left join Project P on tr.TestRequestNo =...

No problem - though this is a SQL Server place really.

I have a friend who is a Notes developer - I'll ask him & see whether he's got any ideas.

Phil

Hmmmm - if this is about SQL Server administration, I'm a chicken tikka massala.

But I've done some Notes in the past.  When you open the Notes connection, are you connecting...

15 seconds - on Big Blue maybe, but not on my laptop, where it ran like an arthritic dog!  Got bored and killed it before it finished!!  Thanks Jeff!

Try running

exec sp_who2

from Query Analyser and see whether the information displayed there identifies your users.

So you do not want to track the fact that a record (or records) have been...

The question does not state whether or not the GUID is a clustered PK - I therefore assumed it was not.

Triggers sound like the way to go - I'm assuming that you're thinking of creating two or three tables along the lines of:

AuditInsertDelete(AuditInsertID, Date, Action, Table, user, field1, field2, etc)

AuditUpdate(AudotUpdateID, date, table,...

Good.  You two have already had the discussion that I was about to get into!

Why did you need to use a cursor?  Perhaps we can find a (fast) set-based approach if you provide more info.

Me too!  Good idea.