J
Jason V
Can I use stored procedures in INNER JOINs?
IE:
Alter Procedure sp_SQLProvDirInc
AS
SELECT dbo.tblSQL_Include_Criteria.IncludeProvOff
FROM dbo.tblSQL_Include_Criteria INNER JOIN dbo.sp_SQLProvCrit ON
dbo.tblSQL_Include_Criteria.SQLID = dbo.sp_SQLProvCrit.ID
IE:
Alter Procedure sp_SQLProvDirInc
AS
SELECT dbo.tblSQL_Include_Criteria.IncludeProvOff
FROM dbo.tblSQL_Include_Criteria INNER JOIN dbo.sp_SQLProvCrit ON
dbo.tblSQL_Include_Criteria.SQLID = dbo.sp_SQLProvCrit.ID