nt is
[EMAIL PROTECTED]. Both may be listed because I frequently get
emails in duplicate.
Any help would be greatly appreciated.
Jodi Kanter
Original Message
Subject:
Majordomo results: unsubscribe
Date:
Wed, 15 Dec 2004 15:55:43
I have a field in one of my tables that has a path to a file listed. I
need to move those files and now have to update all those paths. Is
there a simply search and replace type option in sql? or do I need to
do an update using the entire new path name?
If so, I think the easier solution will b
I have a query that produces results similar to this:
run# rd_pk group#
0 9209 5
1 9209 8
0 9520 2
1 9520 5
0 9520 etc
0 8652
1 8652
2 8652
0 8895
1
Is there a straight forward way to pull out duplicates in a particular
field given a value in another field?
For example, I have a table that lists users and study names associated
with those users. Each user can have one or more study names. My goal
is to determine if any of these people have
Title:
Viorel
Thank you for responding and sorry to waste your time. I just realized my
stupid mistake after sending the message! It was an integer field.
Jodi
Viorel Dragomir wrote:
- Original Message -
From:
JodiKanter
Title:
We recently upgraded from version 7.2.3 to 7.3.3 and seem to have some code
that has broken. We were doing checks in various locations looking for nulls
and/or empty fields. To search for empty fields we said something like
select count(am_pk) from array
Title:
I have one table that has a date/time field in it. I'd like to identify the
records in the database where the date/time fields are the same. How can
I do this? Do I need to create a view or temp table? Is there a way to run
through one table multiple times
Title:
One of my colleagues has created a database where he has the same field name
in two tables and uses this field to link his tables rather than some arbitrary
value. For example, he has used "exp_id" in two tables. When writing his
joins he uses a syntax tha
