Community Member Profile
- Profile: /members/5117-Dennis.htm
- Comments: 3
- Points: 35
Recent Blog Comments By Dennis
-
Using A SQL JOIN In A SQL UPDATE Statement (Thanks John Eric!)
Posted on Jan 8, 2010 at 10:11 AM
My goal in using the Update From syntax is to write select statements and then turn them into update statements without changing the code. So i usually set them up like this: UPDATE cr SET cr.CreatedBy = 'jsmith' --SELECT * FROM CompletedRequirement cr INNER JOIN... read more »
-
Using A SQL JOIN In A SQL UPDATE Statement (Thanks John Eric!)
Posted on Jan 7, 2010 at 12:32 PM
In regards to the above, i think if has to do with joining on a view since i cannot reproduce it when joining on a table.... read more »
-
Using A SQL JOIN In A SQL UPDATE Statement (Thanks John Eric!)
Posted on Jan 7, 2010 at 12:00 PM
This is academic as we got the data updated another way but were we're wondering why something works the way it does: Given these two SQL statements, we get the following results: --This pulls 1 row SELECT * FROM CompletedRequirement cr INNER JOIN vwRequir... read more »
