1, Customer table [TBLMEMBER] 's structure
2, I've created a table with following structure
CREATE TABLE [dbo].[TBLMEMBER](
[TRANNO] [int] IDENTITY(1,1) NOT NULL,
[PARENTID] [nvarchar](10) NULL,
[ACID] [nvarchar](10) NULL,
[MEMBERID] [nvarchar](10) NOT NULL,
[MEMNAME] [nvarchar](70) NULL,
[PRINTNAME] [nvarchar](50) NULL,
[GENDER] [nchar](10) NULL,
[ADDRESS] [varchar](30) NULL,
[DOB] [varchar](20) NULL,
[PROV] [int] NULL,
[GROUP] [nchar](2) NULL,
[USERID] [nvarchar](15) NULL,
[DISTRICT] [int] NULL,
[PWD] [nvarchar](100) NOT NULL,
[MOBILE] [nchar](10) NULL,
[PANNO] [varchar](20) NULL,
[PATH] [nvarchar](max) NULL,
[varchar](30) NULL,
[CITIZENSHIP] [varchar](50) NULL,
[STATUS] [char](2) NULL,
[REFERRBY] [varchar](10) NULL,
[REFERBY] [varchar](10) NULL,
[DATEJOIN] [datetime] NULL,
[DIPO] [varchar](5) NULL,
[CTEAM] [nvarchar](max) NULL,
[CSTATUS] [char](2) NULL,
CONSTRAINT [PK_TBLMEMBER_1] PRIMARY KEY CLUSTERED
(
[MEMBERID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
CREATE TABLE [dbo].[TBLMBUSINESS](
[TRNDATE] [date] NOT NULL,
[DATETIME] [datetime] NOT NULL,
[VCHRNO] [nvarchar](10) NOT NULL,
[BILAMT] [money] NOT NULL,
[BVAMT] [money] NOT NULL,
[DISCOUNT] [money] NULL,
[AMOUNT] [money] NULL,
[BILLCAT] [money] NULL,
[MEMBERID] [nvarchar](15) NOT NULL,
[STATUS] [char](2) NULL,
) ON [PRIMARY]