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???