Viewing 15 posts - 181 through 195 (of 59,078 total)
not me (and many of the prior replies are trolls I believe)
Thanks for the reply, Frederico.
I don't know about folks being "trolls" but I've never seen anywhere on this...
January 20, 2025 at 2:35 am
The SQL Server documentation says that "global temporary tables are visible to all sessions" and it doesn't seem to identify a work around. That also means that you cannot assign...
January 19, 2025 at 5:23 am
I'm curious... have any of you that said that you'd be happy to do reviews of articles ever been asked to do an article review?
January 16, 2025 at 10:09 pm
It's better to NOT drop TempTables. The "schema" can be reused even though they go out of scope and "disappear" at the end of each session.
January 16, 2025 at 10:06 pm
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
Viewing 15 posts - 181 through 195 (of 59,078 total)