Всем привет,
Есть процедура:

ALTER PROCEDURE dbo.sprRowSource8
AS DECLARE @Par varchar(9)
SET @Par='2'

SELECT dbo.tblObject.Object_ID, dbo.tblObject.Object_Tag, dbo.tblObject.Object_Type
FROM dbo.tblObject LEFT OUTER JOIN
(SELECT dbo.tblGroup.Group_ID, dbo.tblObject.Object_ID, dbo.tblObject.Object_Tag, dbo.tblObject.Object_Type
FROM dbo.tblObject INNER JOIN
dbo.tblObjectArray ON dbo.tblObject.Object_ID = dbo.tblObjectArray.Object_ID INNER JOIN
dbo.tblGroup ON dbo.tblObjectArray.Group_ID = dbo.tblGroup.Group_ID
WHERE CONVERT(varchar, dbo.tblGroup.Group_ID) LIKE @Par) myView ON
dbo.tblObject.Object_ID = myView.Object_ID
WHERE (dbo.tblObject.Object_Type LIKE N'F%') AND (myView.Object_ID IS NULL)

Возможно ли в данном случае програмно задавать значение @Par?

(ADP, Office XP)

Всем спасибо

2 Incold:
Спасибо огромное!