October 2, 2023 at 12:00 am
Comments posted to this topic are about the item A Reuseable Window
October 2, 2023 at 12:55 am
Heh... I was having too much fun with this post and thought that someone might take it too negatively, and so I deleted it.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 2, 2023 at 6:50 am
Sorry, but the answer is wrong! I ran the code in SQL 2022 got below error:
Msg 102, Level 15, State 1, Line 15
Incorrect syntax near 'WINDOW'.
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
October 2, 2023 at 3:58 pm
Sorry, but the answer is wrong! I ran the code in SQL 2022 got below error:
Msg 102, Level 15, State 1, Line 15 Incorrect syntax near 'WINDOW'.
You're probably not using the 2022 version of Adventureworks. Like Steve said in the question as a condition. "When I run this on a SQL Server 2022 database, what happens?".
Make sure that the Adventureworks database is set to the comparability level (16) for SQL Server 2022.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 2, 2023 at 4:13 pm
You can use an older ADW db, as I show here:
However, needs to be in 2022 compat mode
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy