I can't see any catastrophes on the horizon, but you should of course write the appropriate script and run it on a backup copy of the db just to make...

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.