Look at unpivot

https://www.sqlservercentral.com/articles/an-alternative-better-method-to-unpivot-sql-spackle

Great point, Ralph. Note that PowerShell and Python are also great text processing utilities as well. Learning some of the Unix, PoSh, or Python skills can be very handy for...

I'm not judging you, at least, I don't think I am. I'm really pointing out a reality that occurs often. Many people get complacent in their jobs, and they become...

We all think of speech, but text to AI works as well. I think things could work well, but we have so much ambiguity in communication, not sure that an...

Thanks

You don't need an insert, you need an update. However, your update needs to include a concatenation of the previous contents.

Something like:

create table #mytable(myid int, mycomment varchar(200))
insert...

Thanks for the votes. I'll note this in the ticket.

I would agree with Grant. This is a "for the job" question. You also leave out some of the factors with regard to price. For many applications, either works great....

Agree with Grant.This is a short sighted request  and isn't a requirement. What a requirement would be is to present the data in this way. The way to store this...

Closing. Visit the other thread for an answer.

Thanks for the effort. I've posted a bug and tagged it high priority. Everyone's out now, but we'll follow up tomorrow.

Below the "Your account" is the toolbar. This is supposed to be visible for everyone. If I log in with a test account, I see this for this thread:

Bug filed to add the TOC back

Do you want the same object visible in each schema? Meaning I create foo.TableA and bar.TableA and it's the same table with the same data? If so, no. An object...

Copying text from a post Dear Experts, i need help in calculating time difference between two dates portion by Date, the difference will be calculated with the first day...