Calculated Fields in a VIEW????

[crispin]

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

[JasonS]

Does the GetClassification sp pass back the value in an output variable?
If so, declare a variable to hold the return value and then run your select query using the variable.