Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kendo666
Starting Member
12 Posts |
 Posted - 2007-06-13 : 13:42:29
|
| Hi,I've got an insert that uses a select (see below) which works fine for me but my colleague (who is onsite...in another country) says the rest of the proc works fine except its not inserting into the security table. I run it on mine, i get the rows i expect. Before I have to get on a plane, is there any known issues regarding using a select to insert in a stored proc for sql server 2000?insert into DOCSADM.SECURITY (THING, PERSONORGROUP, ACCESSRIGHTS)select @v_doc_system_id, PERSONORGROUP, ACCESSRIGHTS from docsadm.security where thing = @v_folder_system_id and personorgroup not in (select personorgroup from docsadm.security where thing = @v_doc_system_id and ACCESSRIGHTS <> 255)ThanksKen |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-06-13 : 13:46:10
|
| As such there are no issues. You just have to check your logic. Sometimes IN doesnt always work as expected. If that is not an issue, you should be okay.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
Using SELECT to INSERT records in SP