create table call_req( [persid] [nvarchar](30) NULL, [ref_num] [nvarchar](30) NOT NULL, [type] [nvarchar](10) NULL, ); Insert into call_req (persid,ref_num,type) VALUES ('cr:400002',23,'I') Insert into call_req (persid,ref_num,type) VALUES ('cr:400051',24,'I')