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

Combine 2 stored Procedures into 1

I need to combine 2 stored procedures into 1 but it keeps giving me incorrect syntax errors


Create Proc sp_ImportIAInformation
 
AS
	sp_ImportIaComplianceTable
 
	sp_ImportADAccounts

Open in new window

0
kdeutsch
Asked:
kdeutsch
1 Solution
 
chapmandewCommented:
Create Proc sp_ImportIAInformation
 
AS
      execute sp_ImportIaComplianceTable
 
      execute sp_ImportADAccounts

go
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

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