Siegfried Heintze wrote:
Sorry, I accidentally pasted some garbage at the beginning of that last
email message. Here is what I intended:
I first check to see if the record exists:
SELECT cJobTitle FROM jobtitlecount WHERE fkJobPosting = 209689 AND
dtSnapShot = '2005-06-26'
When I don't find an
Sorry, I accidentally pasted some garbage at the beginning of that last
email message. Here is what I intended:
I first check to see if the record exists:
SELECT cJobTitle FROM jobtitlecount WHERE fkJobPosting = 209689 AND
dtSnapShot = '2005-06-26'
When I don't find an entry, I try an insert:
IN
"Siegfried Heintze" <[EMAIL PROTECTED]> wrote on 06/29/2005 03:09:28
PM:
> 671 Did not find any old versions with SELECT cJobTitle FROM
jobtitlecount
> WHERE fkJobPosting = 209689 AND dtSnapShot = '2005-06-26', attempt to
insert
> one: INSERT INTO jobtitlecount (fkJobPosting, dtSnapShot, cJobTi
671 Did not find any old versions with SELECT cJobTitle FROM jobtitlecount
WHERE fkJobPosting = 209689 AND dtSnapShot = '2005-06-26', attempt to insert
one: INSERT INTO jobtitlecount (fkJobPosting, dtSnapShot, cJobTitle) VALUES
(209689,'2005-06-26',1)
671 Did not find any old versions with SELECT