I would like to follow this, but I don't understand the sentence "if they are use it to populate field Sort with the value". I don't see the Sort column...

thanks for this information and link.

Thank you.

Well, I hope to see you there!

truth is that I would be honored to meet you all at a SQL Pass summit one day. Each of you have been tremendously helpful to my SQL learning....

LP has soul? If you say so :pinch:.

I'll just make a temp table with the columns renamed, and un-pivot against the temp table instead of the original table.

Yes, except that David Webb-200187, good man that he is, answered the question I had, which is wonderful. Sometimes you just need a relevant answer, yes?

Thank you David Webb-200187,...

Yes, I agree. There's also an sp_msforeachdb function available....

But I needed to learn the cursor

Hi,

I would do two things:

Make sure there is a Projection_Date column in destination table. Then, on the last line of the merge statement I would add an additional SET statement...

Thank you Lowell. I still Still STILL must learn to utilize these temp tables and other tools! Thank you for showing me.

You were very helpful to me. I removed the two extra columns I don't need and ran cursor in a new window and now I have results. Thanks you.

what...

thanks for help. Yes, cursor will be find for this case. I removed 'GO' and now I get the following error.

Msg 16915, Level 16, State 1, Line 4

A cursor...

OK, I have re-examined my design and am doing away with the clustered PK....will introduce a lookup table instead. Thank you for not letting me hurt myself. 🙂

Lynn, I'm a DBA, it turns out. Does that mean that the list I am getting when I do select * from sys.database_principals is complete afterall?