@Client int = NULL,
@LandlordID int = NULL

AS

DECLARE @UserType TABLE
(
	LandlordID int,
	Client int
)

INSERT INTO @UserType EXEC CurrentUser @User

USE [SCMdb]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[CustomerSearch]

@User varchar(20),
@NameNumb varchar(20) = NULL,
@Address varchar(20) = NULL,
@Postcode varchar(20) = NULL,
@Client int = NULL,
@LandlordID int = NULL

AS

DECLARE @UserType TABLE
(
	LandlordID int,
	Client int
)

INSERT INTO @UserType EXEC CurrentUser @User

@LandlordID = SELECT LandlordID FROM @UserType
@Client = SELECT Client FROM @UserType

IF (@Client = 0)
Begin
SET @LandlordID = NULL
END

IF (@NameNumb IS NULL) AND (@Address IS NULL) AND (@Postcode IS NULL)

	BEGIN
	WAITFOR DELAY '00:00:01' 
	END

ELSE

	BEGIN

	SELECT     CustomerID, NameNumb, BillingAddress, PostalCode, Owner
	FROM         Customers
	WHERE 
	(Owner = ISNULL (@LandlordID,Owner)) AND
	(NameNumb Like ISNULL ('%' + @NameNumb,NameNumb) + '%') AND
	(BillingAddress Like ISNULL ('%' + @Address,BillingAddress) + '%') AND
	(PostalCode Like ISNULL ('%' + @Postcode,PostalCode) + '%')
	ORDER BY BillingAddress, NameNumb

	END

@LandlordID = SELECT LandlordID FROM @UserType
@Client = SELECT Client FROM @UserType

quote:

---

Originally posted by pbguy

It should be like

SELECT @LandlordID = LandlordID FROM @UserType
SELECT @Client = Client FROM @UserType


--------------------------------------------------
S.Ahamed

---