I'm new to adp w/ sql server but I have to use it on a project i'm
doing...
One of the MUSTS for this project is the ability to update a 00 - 09
text value with the appropriate text description from another table...
Easy as pie in .mdb. Of course In the stored procedure it barks at me
and tells me that an update query can only have one table.. ouch that
hurts...
I'm currently reading on the subject but this group has been very
helpful in the past.....
I found this link...
http://www.sqlservercentral.com/colu...theeasyway.asp
Unfortunetly I'm using MSDE not Enterprise so I don't think I can use
the query analyser.. But I tryed it in my Access ADP anyway
it barked at me..
I tried to go from this....
SELECT dbo.LU_SEX.SEX_ CODE, dbo.TEST.DEFECT S_DP1
FROM dbo.TEST INNER JOIN
dbo.LU_SEX ON dbo.TEST.SEX_DP 1 =
dbo.LU_SEX.SEX_ DEC
To this...
UPDATE dbo.TEST.SEX_DP 1
SET dbo.TEST.SEX_DP 1 = dbo.LU_SEX.SEX_ CODE
FROM dbo.LU_SEX INNER JOIN
dbo.TEST ON dbo.LU_SEX.SEX_ DEC =
dbo.TEST.SEX_DP 1
Maybe I need a good book on this?
Thanks,
Charles