Topic: update query
Table name : J_R
FNTrans FCOA FSeqTime FPostID
A0003 5100-001 0x000000000025CB4A 2435450
A0003 1104-001 0x000000000025522D 2435450
A0003 4100-001 0x00000000002599F9 2435450
A0003 1103-201 0x000000000025ABD5 2435450
A0004 5100-001 0x00000000002575DE 2435450
A0004 1104-001 0x0000000000257667 2435450
A0004 1103-201 0x0000000000257F37 2435450
A0004 4101-001 0x000000000025626D 2435450
A0005 1103-201 0x0000000000257AE3 2435450
A0005 4100-001 0x0000000000257B85 2435450
A0005 5100-001 0x000000000025CBE3 2435450
A0005 1104-001 0x000000000025CBE4 2435450
A0006 1104-001 0x000000000025CBE5 2435450
A0006 1103-301 0x000000000025CBE6 2435450
A0006 4100-001 0x00000000002579CF 2435450
A0006 5100-001 0x000000000025AFB1 2435450
A0019 4100-001 0x0000000000259080 2435450
A0019 5100-001 0x0000000000255B40 2435450
A0019 1104-003 0x0000000000255B41 2435450
A0019 1103-201 0x0000000000255B42 2435450
A0020 1104-001 0x000000000025A870 2435450
A0020 1103-201 0x000000000025A873 2435450
A0020 4100-001 0x000000000025CBAB 2435450FNTrans : varchar(30)
FCOA : varchar(30)
FSeqtime : Timestamp
FPostID : BigInt
saya punya data seperti di atas
saya ingin update FPostID dengan nilai dari FSeqtime,
dimana nilai FPostID sama utk FNtrans yg sama.
Ada yang bisa bantu?
saya coba query :
update J_R
set FPostID=select (convert(numeric(20,0), max(FSeqTime) + 0)) from J_R
data yg saya dapat seperti di atas, sama semua utk semua row.
