hi all
i am doing a mlm project.
my client request is that for every parent having 3 childs then we give commission 500/-INR. so loop continues for every time while child increases.and my structure is.
as shown in below.
CREATE TABLE [dbo].[re](
[id] [int] IDENTITY(1,1) NOT NULL,
[sponserid] [varchar](50) NULL,
[introducerid] [bigint] NULL,
[placedunderid] [varchar](50) NULL,
[name] [varchar](50) NULL,
[so] [varchar](50) NULL,
[position] [int] NOT NULL,
[gender] [int] NOT NULL,
[occupation] [varchar](50) NULL,
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO