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 |
|
qman
Constraint Violating Yak Guru
442 Posts |
 Posted - 2009-09-09 : 08:55:30
|
| Does anyone see anything wrone with my delete query?I get the following error when running the below query:Msg 102, Level 15, State 1, Line 1Incorrect syntax near 'scc'.delete from dbo.Study_Contribution_Contacts sccinner join dbo.Study_Contributions sc on sc.study_contributions_id = scc.contribution_idwhere sc.study_id = 0x0000000000000122 |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-09-09 : 08:58:35
|
| delete scc from dbo.Study_Contribution_Contacts sccinner join dbo.Study_Contributions sc on sc.study_contributions_id = scc.contribution_idwhere sc.study_id = 0x0000000000000122 |
 |
|
|
qman
Constraint Violating Yak Guru
442 Posts |
Posted - 2009-09-09 : 09:46:13
|
| Thanks, told you it was simple! |
|
|
|
Nageswar9
Aged Yak Warrior
600 Posts |
Posted - 2009-09-10 : 00:20:22
|
| Hi, also use thisdelete from Study_Contribution_Contactswhere study_contributions_id in ( select study_contributions_id from Study_Contributionswhere study_id = 0x0000000000000122 ) |
|
|
|
qman
Constraint Violating Yak Guru
442 Posts |
Posted - 2009-09-10 : 07:40:07
|
| Thanks for the other approach. |
|
|
|
Nageswar9
Aged Yak Warrior
600 Posts |
Posted - 2009-09-10 : 07:56:24
|
quote:
Originally posted by qman
Thanks for the other approach.
Welcome |
|
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
|
|
|
|
|
Problems with a Simple Delete Query