T-SQL Common Table Expression (CTE) to get Last Value on Max Date, Use a Particion Over -- 2
Budget: $10 – $30 USD
T-SQL to get the Max Earnings value for each ID_NUM. My attempt is to use the last date SAL_RWV_DTE. I don't want to use the APP_ID identity column. It might need a window over particion on [ORG_POS] [varchar] to determine the last row number for that column . The test script and data are attached. Please look at those to determine if you have all of the information you need to complete. Reply with when you can complete the project. Project needed in 12 hours. Sql Server 2016 SP1
Conversion failed when converting date and/or time from character string.
Warning: Null value is eliminated by an aggregate or other SET operation.
Table
[IND_SAL_HIST](
[APP_ID] [int] IDENTITY(1,1) NOT NULL,
[ID_NUM] [int] NOT NULL,
[ORG_POS] [varchar](9) NOT NULL,
[POS_SEQ] [int] NOT NULL,
[SAL_RVW_SEQ] [int] NOT NULL,
[SAL_RWV_DTE] [varchar](23) NULL,
[EARNINGS] [numeric](8, 2) NOT NULL,
Please reply with:
The time of day that you are available. I am available 7am to 10pm UTC-06:00 Central Time US & Canada. Will you require contact by voice and do you speak English? When you can complete the project.
Confidentiality.
a) No Use. Recipient agrees not to use the Confidential Information in any way, or to manufacture or test any product embodying Confidential Information, except for the purpose set forth above.
b) No Disclosure. Recipient agrees to use its best efforts to prevent and protect the Confidential Information, or any part thereof, from disclosure to any person other than Recipient's employees having a need for disclosure in connection with Recipient's authorized use of the Confidential Information.
c) Protection of Secrecy. Recipient agrees to take all steps reasonably necessary to protect the secrecy of the Confidential Information, and to prevent the Confidential Information from falling into the public domain or into the possession of unauthorized persons.
d) Scope. The scope of Confidentiality is deemed to be in all contracts present past and future with the Parties to this request
Conversion failed when converting date and/or time from character string.
Warning: Null value is eliminated by an aggregate or other SET operation.
Table
[IND_SAL_HIST](
[APP_ID] [int] IDENTITY(1,1) NOT NULL,
[ID_NUM] [int] NOT NULL,
[ORG_POS] [varchar](9) NOT NULL,
[POS_SEQ] [int] NOT NULL,
[SAL_RVW_SEQ] [int] NOT NULL,
[SAL_RWV_DTE] [varchar](23) NULL,
[EARNINGS] [numeric](8, 2) NOT NULL,
Please reply with:
The time of day that you are available. I am available 7am to 10pm UTC-06:00 Central Time US & Canada. Will you require contact by voice and do you speak English? When you can complete the project.
Confidentiality.
a) No Use. Recipient agrees not to use the Confidential Information in any way, or to manufacture or test any product embodying Confidential Information, except for the purpose set forth above.
b) No Disclosure. Recipient agrees to use its best efforts to prevent and protect the Confidential Information, or any part thereof, from disclosure to any person other than Recipient's employees having a need for disclosure in connection with Recipient's authorized use of the Confidential Information.
c) Protection of Secrecy. Recipient agrees to take all steps reasonably necessary to protect the secrecy of the Confidential Information, and to prevent the Confidential Information from falling into the public domain or into the possession of unauthorized persons.
d) Scope. The scope of Confidentiality is deemed to be in all contracts present past and future with the Parties to this request