select "Happy Birthday ", EpiUser, “#”, Row_Number() over (partition by EpiUsers)
where birthday = getdate().
Happy Birthday @Banderson #1
6 Likes
I think you’ve got a problem with you’re query somewhere, it didn’t pickup that my birthday is also today.
Funnily enough, I actually watched the video @Banderson posted from his Insights presentation on windowing this morning, then saw this one and his post about string_agg next to each other on the home page.
6 Likes
1 Like
Congrats… and 21 again…
1 Like