>Hi
>
>I'm not suire hwo I do this.
>
>I have a stored procedure that I'm passing parameters to and I want to pass back a result.
>
>So I have
>
> EXEC @return_value = [dbo].[usp_Insert_Individual]
> @FamilyRef = NULL,
> @StatusRef = 87,
> @SoundexKey = NULL,
> @ExternalRef = NULL,
> @Title = @hf_in_title,
> @Forenames = @hf_in_forename,
> @Initials = @hf_in_initial,
> @Surname = @hf_in_surname,
> @Honours = NULL,
> @NewIndividualRef OUTPUT
>
>but I get an error
>
>Must pass parameter number 27 and subsequent parameters as '@name = value'. After the form '@name = value' has been used, all subsequent parameters must be passed in the form '@name = value'.
>
>So whats the best way to return the id of the new record inserted by usp_Insert_Individual.


Just a guess (since I'm useless at SQL): Put all the assingments with a @ on the right before any that do not ?