Viewing 15 posts - 166 through 180 (of 59,059 total)
This is a parent/child list. There's a whole lot more that can be done with it if it's recognized for what it can do including but not limited to "Nest...
January 16, 2025 at 9:32 pm
Wouldn't it be nice if Microsoft finally figured out that there's been math co-processors built into CPU chips since the mid-'90's??? Even the decimal datatype had issues with resetting the...
January 13, 2025 at 5:24 pm
Just so people can play if they want, here's all the code I played with.
My findings are that if you can have a Clustered Index on the RowNumber column of...
January 12, 2025 at 1:52 am
Thanks Jeff, Here is more realistic data. Won't work when there are more than 5 rows.
Ah... My apologies, Chrissy. When you said you could "guarantee the order", I mistook...
January 12, 2025 at 12:32 am
so many people here obsess over every microsecond
It's frequently obvious when code is not written by such folks when the OP comes back in a few months saying that,...
January 11, 2025 at 6:29 pm
My suggestion is that you need to stop taking chances and hire a consultant to set you up correctly because it sounds like you're not just storing personal data (which...
January 11, 2025 at 5:59 pm
Is there anything else I'm missing that I should consider?
Yes. It sounds to me that you're using the "Developer" Edisition to do "production work"... which goes against the licensing...
January 11, 2025 at 5:56 pm
It would be easier if the first row were numbered "0" instead of 1 so that we could use modulo all by itself to do this but, it can still...
January 10, 2025 at 10:32 pm
@jeffmoden I have not spent much time on SSC for a good few years. Searching for something else, I came across this article (and the follow up) written by...
January 10, 2025 at 4:36 pm
Hi, excellent post, I have taken it and put it into practice, and it works very well for me to redo the whole nested set, But I want...
January 10, 2025 at 4:34 pm
Just to ask the question, I haven't tested any of the solutions and so this question is directed at Reh23 ...
Do any of the solutions, so far, do what you...
January 10, 2025 at 4:18 pm
First of all, please stop posting graphics for the test data. See the article at the first link in my signature line below for why and one method for...
January 10, 2025 at 4:17 pm
Thanks Jeff. Its SQL Server 2017.
Your other post is on an SQL Server 2022 forum.
January 10, 2025 at 4:13 pm
Just to be sure, I would never obfuscate numeric data. If it's worth protecting, it's worth being properly encrypted.
January 10, 2025 at 4:11 pm
Hi SSC team,
I wanted to leave the answer here just in case anyone else needs it. This works. Only caveat is that you need to use dts.vaiables...
January 10, 2025 at 2:34 am
Viewing 15 posts - 166 through 180 (of 59,059 total)