Will your statements support something in the nature of :
SELECT
... ,
a.PID
, ...
FROM (
SELECT
... ,
substring(colname ,charindex('|',colname)+1, charindex('|',colname,
charindex('|',colname)+1) - charindex('|',colname) -1) as "PID"
, ...
FROM dbo.table
) a
WHERE PID = Selection cri
Is there an easy way to determine if a record is empty?
I have a saved list of a thousand or more records that have record ID's that
interfere with our Ellusian database.
If they are truly empty, I can do house cleaning on them. If they contain any
data, I have to do a different process.
When
Of Wjhonson
Sent: Friday, August 31, 2012 4:49 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Friday type of question
In the DICT, in an I-descriptor you can specify LEN(@RECORD) If the record has
zero length it's empty.
-----Original Message-
From: Morelli, David W.
To:
Thank you. The "'word'..." format is the answer to a question that had
me banging my head yesterday.
David Morelli, UIS/Datatel Team
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Andre Meij
Sent: Wednesday, May 30, 2007 5:10 PM
To: u2-users@listserver
Is the audit trail allowed to keep a sorted list of rollback numbers?
Open a process
Request a number
...
If rollback Insert the number into the Rollback List
Else save record
Close process
Or if the goal is to consume all sequential numbers.
Open a process
Request the lowest number f