"Vern" wrote:

> I'm using user defined data types in my stored procedures and they seem to
> work fine. However, if I use the query analyzer to call the stored
> procedure, and try to define the parameters using the user defined data type,
> it says that data type doesn't exist. Is there something special to
> specifying the UDF?
>
> Here's the SQL in the query analyzer I'm trying to run.
>
> CREATE TABLE #Address2 (AddressId int, Address1 char(50) )
> INSERT #Address2 (AddressId, Address1 )
> EXEC dbo.prWS_Address_Select 11, 0
> SELECT * FROM #Address2
> DROP TABLE #Address2
>
> It works fine like that, but doesn't work if I change the first line to this:
>
> CREATE TABLE #Address2 (AddressId AddressId, Address1 Address )
>
> The stored procedure looks like this:
>
> CREATE PROC [dbo].prWS_Address_Select
> @AddressId int,
> @err INT OUT
> AS
> SET NOCOUNT ON
> SET @err = 0
>
>
> SELECT AddressId,
> Address1
> FROM Address
> WHERE AddressId = @AddressId
> SELECT @err = @@error IF @err <> 0 RETURN -1
> RETURN
>
>