@skeleton567 It's just a dumb play on the "auto-increment" feature many databases have for numeric PK fields. And you know, "ex" is the opposite of "in", and... 😉

@jeff Moden for what it's worth, I saw your original post both before and after your follow-up, without issue. I am NOT missing a Jeff Moden post. That's...

@skeleton567 Sure, are you asking about my screen name or my comments? 🙂

I totally agree that relational databases will continue to be used for decades. Used wisely, they are far more utile and efficient than many people realize. However, as I'm sadly...

Man, this piece hit hard. Really hard. Thank you, Grant, for saying what probably a lot of us have been thinking. SQL is such a powerful and beautiful problem-solving tool.

But...

Thank you for explaining without being a dick.

I stand guilty as accused, I am a common man.

Is the title supposed to be AI or IA? Also there's a typo in the code: textbblob. Interesting article though, thanks.

Off-topic, but awesome to SEE Jeff Moden after all these years! The YT vid was a bit over my head but still fascinating.

Maybe this post would fare better in the ADMINISTRATION category.

https://www.sqlservercentral.com/forums/forum/sql-server-2022/sql-server-2022-administration

• This reply was modified 1 year, 6 months ago by  autoexcrement.

None of us have any idea what your stored procedure or your tables look like. But here's an idea:

DECLARE @MyList VARCHAR(MAX);

SET @MyList = 'S0,T0,t0,W0,';

WITH CTE AS
(
SELECT Warehouse...

@frederico_fonseca I apologize, I missed that you were doing a recursive loop there. My bad.

@frederico_fonseca I had the same idea as you initially, but your solution will not work either. What if there were 20 groups instead of 3? What if the...

We really just need a way to view/export the results of the reconstituted queries. Thanks for your thoughts on this project though, I think I will pursue a non-SQL approach...

Thanks for the reply, Phil! I think I could handle a simple query like that as well. Where it starts getting rough for me is when there are [x] number...