Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Help with sproc syntax (DELETE)

Posted on 2011-09-28
2
Medium Priority
?
365 Views
Last Modified: 2012-05-12
Hi All,

I think its a pretty simple sproc but cannot get it right. any help?

--------------------------------------

BEGIN
DELETE From Bd_StuCrs bd

Inner Join Tbl_Student st On
bd.StuCrs_Stu_UserID = st.Student_UserID

WHERE bd.StuCrs_Stu_UserID = st.Student_UserID
AND st.Student_ISPurged = 1

END

-----------------------------------------------------

Kind regards

A
0
Comment
Question by:Abiel de Groot
2 Comments
 
LVL 15

Accepted Solution

by:
Anuj earned 2000 total points
ID: 36716068
BEGIN
DELETE From Bd_StuCrs
FROM Bd_StuCrs  bd
Inner Join Tbl_Student st On
bd.StuCrs_Stu_UserID = st.Student_UserID
WHERE bd.StuCrs_Stu_UserID = st.Student_UserID
AND st.Student_ISPurged =1
END
0
 
LVL 5

Author Comment

by:Abiel de Groot
ID: 36716108
Many Thanks...

A.
0

Featured Post

[Webinar] Cloud Security

In this webinar you will learn:

-Why existing firewall and DMZ architectures are not suited for securing cloud applications
-How to make your enterprise “Cloud Ready”, and fix your aging DMZ architecture
-How to transform your enterprise and become a Cloud Enabler

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question