python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - sql-merge

Why does a merge into a temporal table with a nonclustered index in the history table throw an error

I get the following error when I try to merge under a few conditions. Is someone able to explain why? Seems like it's a problem with SQL Server itself, but I wanted to post it here to confirm. Attemp...
test-img

CSharpFiasco

sql-server

azure-sql-database

sql-server-2017

sql-merge

temporal-tables

Votes: 0

Answers: 0

Update multiple columns based off another table in DB2 V5R4M0

I am working on an update statement for an AS400 DB/2 table. It needs to have multiple rows updated using data from another table with matching fields. Our version of the driver displays is: 05.04.000...
test-img

eaglei22

sql

sql-update

common-table-expression

db2-400

sql-merge

Votes: 0

Answers: 1

Latest Answer

you'll need something like so update TBL1 t1 set STS = (select sts from TBL1CPY cp where cp.prj = t1.prj AND cp.PN = t1.PN AND cp.IN = t1.IN ) where LDT = '20220104' A...
test-img

Charles

Posts

Questions

Blogs

Jobs