RE: [SQLQueriesNoCode] How to find non-sequential values in a table
- This table has 4 columns.
CID = collection ID (INT)
OID = Object ID (INT)
PID = property id (INT)
Value = value of property id (VARCHAR)
The data I need to evaluate is contained in two PID fields. The value
for the properties I need the value of is 20001 and 20002. These
property id's represent beginning and ending identification numbers.
The values for those fields are varchar. A mix of letters and numbers
that represent an identifying number for a document.
The alphanumeric values (i.e. ABC00001) are what I need a list of. But
only the non-sequential numbers. I can easily obtain a list of
alphanumeric values that are sequential but contain the non sequential
973-624-7055 ext. 3402
Williams Lea...at your service
[mailto:SQLQueriesNoCode@yahoogroups.com] On Behalf Of John Warner
Sent: Monday, December 31, 2007 12:38 PM
Subject: RE: [SQLQueriesNoCode] How to find non-sequential
values in a table
Before we can venture a reasonable guess we are likely going to
know more about the table and the data in question.
> -----Original Message-----<mailto:SQLQueriesNoCode%40yahoogroups.com>
> From: SQLQueriesNoCode@yahoogroups.com
> [mailto:SQLQueriesNoCode@yahoogroups.com<mailto:SQLQueriesNoCode%40yahoogroups.com> ] On Behalf Of studyhawk2002
> Sent: Monday, December 31, 2007 12:07 PM<mailto:SQLQueriesNoCode%40yahoogroups.com>
> To: SQLQueriesNoCode@yahoogroups.com
> Subject: [SQLQueriesNoCode] How to find non-sequential valuesin a table
> I need to find non-sequential values in a very large table.
> I can generate a complete list of the values I need, but the
> sequential alphanumeric values are mixed in. How can Igenerate a list
> of only the non-sequential values?This email message from the law firm of McCarter & English LLP is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email (or helpdesk@...) and destroy all copies of the original message.
> Yahoo! Groups Links
[Non-text portions of this message have been removed]