CREATE TABLE [dbo].[binaryUser](
[id] [int] IDENTITY(1,1) NOT NULL,
[joiningDate] [date] NULL,
[placement] varchar NULL,
[pId] [int] NOT NULL,
[cId] [int] NOT NULL,
[referBy] [int] NOT NULL
)
insert into binaryuser values (2015-02-02 ,L ,4 ,5 ,4)
insert into binaryuser values(2015-02-02 ,R ,5 ,8 ,4)
insert into binaryuser values(2015-02-02 ,R ,4 ,11 ,4)
insert into binaryuser values(2015-02-02 ,L ,5 ,10 ,4)
insert into binaryuser values(2015-12-12 ,L ,8 ,9 ,4)
insert into binaryuser values(2015-08-21 ,R ,8 ,12 ,4)
insert into binaryuser values(2015-08-21 ,R ,12 ,13 ,4)
insert into binaryuser values(2015-08-21 ,R ,9 ,14 ,4)
insert into binaryuser values(2015-08-21 ,M ,9 ,15 ,4)
insert into binaryuser values(2015-08-21 ,L ,10 ,16 ,4)
insert into binaryuser values92015-08-21 ,M ,4 ,17 ,4)