/* Microsoft SQL Server - Scripting			*/
/* Server: WEBONYX					*/
/* Database: onyx					*/
/* Creation Date 9/28/2000 1:34:21 PM 			*/

/****** Object:  Stored Procedure dbo.cspIsNewCustomer    Script Date: 9/28/2000 1:34:22 PM ******/
if exists (select * from sysobjects where id = object_id('dbo.cspIsNewCustomer') and sysstat & 0xf = 4)
	drop procedure dbo.cspIsNewCustomer
GO

/****** Object:  Stored Procedure dbo.cspIsNewCustomer    Script Date: 9/28/2000 1:34:22 PM ******/
CREATE PROCEDURE cspIsNewCustomer
	@CreditCardNumber varchar(30),
	@EmailAddress varchar(100),
	@CustType varchar(20),
	@IsNew smallint OUTPUT
AS
IF @CustType = 'INDIVIDUAL'
	BEGIN
		SELECT @@ROWCOUNT
			FROM Individual
			WHERE vchUser6 = @CreditCardNumber 
				AND vchEmailAddress = @EmailAddress
		IF @@ROWCOUNT > 0
			SELECT @IsNew = 0
		ELSE
			SELECT @IsNew = 1
	END

IF @CustType = 'COMPANY'
	BEGIN
		SELECT @@ROWCOUNT
			FROM Company
			WHERE vchUser6 = @CreditCardNumber 
				AND vchEmailAddress = @EmailAddress
		IF @@ROWCOUNT > 0
			SELECT @IsNew = 0
		ELSE
			SELECT @IsNew = 1
	END
GO