• yes I want get changed raw in new table

    my 3 table struc. is:

    CREATE TABLE [dbo].[BedriddenBed2](

    [ID] [bigint] IDENTITY(1,1) NOT NULL,

    [ReferralCode] [char](8) NOT NULL,

    [BedDate] [char](10) NOT NULL,

    [BedTime] [char](8) NOT NULL,

    [BedCode] [char](5) NULL,

    [BedDays] [numeric](18, 0) NULL,

    [UserCode] [char](7) NULL,

    [ISVirtual] [bit] NULL,

    [FirstName] [nvarchar](50) NULL,

    [LastName] [nvarchar](50) NULL,

    [BeneficiaryName] [nvarchar](50) NULL,

    [ReferralDate] [char](10) NULL,

    CONSTRAINT [PK_BedriddenBed2] PRIMARY KEY CLUSTERED

    (

    [ReferralCode] ASC,

    [BedDate] ASC,

    [BedTime] ASC

    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

    ) ON [PRIMARY]