Virginia C

Virginia C

  • 2.2k
  • 37
  • 315

Iterate Through Array Of Data In SQL Query

May 10 2023 6:02 PM

I'm trying to apply an update to a very wide table. It has 250+ columns. My update statement works if I execute it in a sql window, but it's not working when I tried to implement it with iterating through an array.   I used the article below as my guide.   I feel like I'm very close, but I'm not sure what I'm missing.

I used Sarvesh Shinde's example article:  iterate-through-array-of-data-in-sql-query.  (Sorry, I haven't earned the reputation to post hyperlinks.  lol)

Answers (2)