Oh, one final question though, I'm trying to add paging to this query, so I now have the following, but I'm unsure where the "WHERE RowNum > 0 AND RowNum...

Thanks!!!

A little explanation:

[giftregistry] is the general description of the list, the bridal couple in this is the only owner. They can add a text they want to send to the...

First of all: thank you for your extensive explanation, awesome! 🙂

A lot of feedback, which to be honest is going to require a lot of redesign of my DB, as...

Whoops! Here you go! You good now? 🙂

SET IDENTITY_INSERT [dbo].[giftregistry] ON

GO

INSERT [dbo].[giftregistry] ([id], [listuuid], [userid], [title], [description], [invitetext], [createdate]) VALUES (2, N'83875b62-3cc1-4516-b932-6e60a116cbff', N'32DD30EB-1691-457B-9FF5-FC41D687E579', N'my list', N'my descr', N'hey u...

Any idea already? 🙂

Done! 🙂 Thanks again

Ah, got it now 🙂

And could you have a look at my updated question?

Ok, not sure what you mean by pasting in into replay...it looks better now anyway.

However, my actual question is not answered yet, as I still don't have the desired results...

Thanks!

I forgot to add a critical component I see now, the data for table giftregistrypurchases.

I updated my question with that data and desired results.

btw: How do you get your samples...

Wow, I've misunderstood that all these years! Thanks! 🙂

I always thought it was best practice to add a columnname since * will slow performance in case of NULL values

So simple...thanks!

Thanks! All working now 🙂

Thanks! Also for the coding feedback, will add that later 🙂

But it turns out that I need one more thing: of all duplicates: keep the row where the column [population]...