It's certainly interesting, if nothing else. At home it's really useful, as I'm a Linux user, so I don't have to rely on VS Code with the MS SQL extension,...

So, with the data provided, what results are you expecting?

You'll need licences for the Server that is hosting the databases (and running the data engine) AND licences for the Server that is running the Reporting Services Service. The Web...

I have to agree with Steve, I'm not a fan of XQuery. I (normally) have to look up the syntax each and every time I have to use it.

Hi Kapil,

When posting T-SQL questions, please avoid supplying your data and expected results in an excel Document; you'll find many people will not be happy to open the...

Microsoft SQL Operations Studio (MSOS) preview is out. Gave it a quick install before I headed out. Looks very much like VSCode. Shall see what I think, but at least...

The logic is the same as above, but instead set your value to that of your RN. This suggests you don't quite understand what the solution I supplied does; do...

How about using a CROSS APPLY:

This is a a bit of guess work, as your table as a PRIMARY_KEY and Version column with the same values. As we only have 1 example, guessing that the...