I don't know 5hit from Shinola in Powershell and so I tried something different... here's the link to the thread I worked through...

https://www.perplexity.ai/search/using-powershell-how-to-search-hGZTTLw2Rmi4v81v3IwqEA#2

I'm not...

I don't know 5hit from Shinola in Powershell and so I tried something different... here's the link to the thread I worked through...

https://www.perplexity.ai/search/using-powershell-how-to-search-hGZTTLw2Rmi4v81v3IwqEA#2

I'm not testing...

Thanks for the reply, Frederico.

I don't know about folks being "trolls" but I've never seen anywhere on this...

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...

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?

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.

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...

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...

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...

Ah... My apologies, Chrissy.  When you said you could "guarantee the order", I mistook...

It's frequently obvious when code is not written by such folks when the OP comes back in a few months saying that,...

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...

Yes.  It sounds to me that you're using the "Developer" Edisition to do "production work"... which goes against the licensing...

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...

@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...