[Webinar] Streamline your web hosting managementRegister Today

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 247
  • Last Modified:

How can I convert this query to an SQL stored procedure?

I have the following coldfusion query that I've attached below.  Can anyone help me convert this into a stored procedure?  Thanks!!
<cfloop query="getAlerts">
    <cfquery name="delAlert" datasource="#Application.dsname#">
       DELETE FROM APAlerts WHERE d_lbxname = '#getAlerts.d_lbxname#' AND tranid not in (SELECT ID FROM #getAlerts.lbxdatatable#)

Open in new window

1 Solution
CashmgmtAuthor Commented:
I figured out the issue.  I just added the delete statement to a stored procedure I already had and it worked.

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now