Hi,
I have to select data from one table where "load date" is max and then i have to paste that data into another table where "load date" is max. but the condition is, data will be available everywhere in the other columns.
Note: load date is a column name.
Please suggest on the same.
Thanks in advance.
-----------------------------------------------------------
Please find table structure below:
CREATE TCREATE TABLE [dbo].[table1](
[ACCT_ID] [char](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SYS_NM] [char](9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[RPT_DT] [smalldatetime] NOT NULL,
[CYCLE_CUT_DT] [smalldatetime] NOT NULL,
[HI_SPEND_AM] [decimal](15, 2) NOT NULL,
[LOC_LMT_AM] [decimal](15, 2) NOT NULL,
[LOAD_TS] [smalldatetime] NOT NULL CONSTRAINT [DF_t0705_HI_SPEND_ACCT2_LOAD_TS] DEFAULT (getutcdate()),
CONSTRAINT [XUZAG01] PRIMARY KEY CLUSTERED
(
[ACCT_ID] ASC,
[CYCLE_CUT_DT] ASC,
[SYS_NM] ASC,
[RPT_DT] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
CREATE TABLE [dbo].[table2](
[ACCT_ID] [char](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PREV_LOC_AM] [decimal](15, 2) NOT NULL,
[LOC_CHNG_AM] [decimal](15, 2) NOT NULL,
[NEW_LOC_AM] [decimal](15, 2) NOT NULL,
[CHNG_DT] [datetime] NOT NULL,
[SYS_NM] [char](9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[WEB_SRVC_STA_CD] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ALLOC_ACT_CD] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[LOC_CHNG_TYPE_CD] [char](2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[OTHER_PTCP_ACCT_RISK_ROLLUP_CD] [char](2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CYC_CUT_DT] [smalldatetime] NOT NULL,
[RPT_IN] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[LOAD_TS] [smalldatetime] NOT NULL
) ON [PRIMARY]
I have to pickup the data of "LOC_LMT_AMT" column from table 1 where "CYCLE_CUT_DT" is max and have to paste the same data into second table where [CHNG_DT] is max.
I have to paste data , where "CHNG_DT" is max, remaining columns should not be pasted.