How do I update multiple groups of records in a temp table?

(0) Share

Report

Posted on by LBP

180

In the example below I want to loop through all records and set the updateID to a numeric value of 1 for group A, 2 for group B, etc.. Not sure how to accomplish this in X++? Thanks for any help.

SalesID	Group	UpdateId
123	A
124	A
125	B
126	B

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Ajit 8,755 on at

Like (0)

Report

RE: How do I update multiple groups of records in a temp table?

It has to be run time as you are talking about run time and you can use while select and use sales id in where clause if you have update id per sales id.

Was this reply helpful? Yes No
LBP 180 on at

Like (0)

Report

RE: How do I update multiple groups of records in a temp table?

Yes, during runtime. I want to update based on group. So group A, updateId = 1, group B update = 2, etc.. How do i increment the UpdateId number?

SalesID Group UpdateId

123 A 1

124 A 1

125 B 2

126 B 2

Was this reply helpful? Yes No
LBP 180 on at

Like (0)

Report

RE: How do I update multiple groups of records in a temp table?

Thanks for the help. I would not know how many as it could be a large number of Groups, SalesIds.

Was this reply helpful? Yes No
Verified answer

LBP 180 on at

Like (0)

Report

RE: How do I update multiple groups of records in a temp table?

I have ended up grouping by group into a temp table then updating the main table with the while select. Thanks for the help.

Was this reply helpful? Yes No