if recordcount = 0
BEGIN
	INSERT INTO CustomerDetails
		(Customer_ID,
		Customer_First_Name,
		Customer_Last_Name,
		Address,
		Telephone_Number)
	VALUES 
		('CD001',
		dbo.initcap('Fazna'),
		dbo.initcap('Hudah'),
		dbo.initcap('100, Shrubbery Gardens, Colombo - 04.'),
		'011 2625691')
	
END
ELSE
BEGIN
	INSERT INTO CustomerDetails
		(Customer_ID,
		Customer_First_Name,
		Customer_Last_Name,
		Address,
		Telephone_Number)
	--VALUES
	SELECT MAX(dbo.AutoIDWithString(Customer_ID)),
			dbo.initcap('Fazna'),
			dbo.initcap('Hudah'),
			dbo.initcap('100, Shrubbery Gardens, Colombo - 04.'),
			'011 2625691'
	FROM customerdetails
END

quote:

---

Originally posted by khtan

declare @recordcount  int

select @recordcount  = count(*)
from   sometable

if @recordcount = 0
begin 
    . . . 
end
else
begin
   . . . 
end

---

KH
[spoiler]Time is always against us[/spoiler]

---