I want to create a view that goes something like this:
Field1
FIELD2 = Exec StoredProcedure Field1AsParameter
Field1 is an ID
Field2 is calculated using a stored procedure and passing field1 as a parameter
this is what I have so far (doesn't work)
SELECT AccidentID,
NewCol AS EXEC GetClassification tblAccident.AccidentID
FROM dbo.tblAccident
any ideas???
