CREATE PROCEDURE [dbo].[spContracts]    
    @ID int = Null,
    @CustomerName nvarchar(255) = Null,
    @Customernumber int = Null,
    @Type nvarchar(255) = Null,
    @Model nvarchar(255) = Null,
    @Serialnumber nvarchar(255) = Null,
    @PhoneNumber nvarchar(255) = Null,
    @Email nvarchar(255) = Null,
    @Country nvarchar(255) = Null,
    @SOW nvarchar(255) = Null,
    @Qty

CREATE TABLE SPLITName 
( 
	Name NVARCHAR(50) 
);
GO
INSERT INTO SPLITName (Name) VALUES ('SIVA')
INSERT INTO SPLITName (Name) VALUES ('KUMAR')
INSERT INTO SPLITName (Name) VALUES ('SAI')
INSERT INTO SPLITName (Name) VALUES ('PRADEEP')
INSERT INTO SPLITName (Name) VALUES ('VIRAT')

GO

CREATE PROCEDURE spSplitName 
(
	@Name nvarchar(50)
)
AS