I think this really depends.

My first step would be to determine what output format is required by the end user.  If they require it to be a comma separated list...

First - I have not seen this issue before, but we are a fully SQL Server shop where I work without any Oracle boxes.

When you say it works correctly in...

jcarranza's solution will also work; my preference is still to create a role and use that role to assign permissions.  What happens to that user/login when they quit  and a...

My guess is you have system restore turned on for that drive.

Setting a limit for VSS likely won't make a difference, but reducing the limit for system restore or turning...

Can you provide some sample data where it is not ordered correctly?  All of my testing on my system indicates that it should  be ordered correctly EXCEPT if you go...

Offhand, I am not sure why they can see all of the databases if they only have permissions on the one.  A quick check online, it sounds like this isn't...

EDIT - I misunderstood the request.  My response was wrong.  Deleted.

• This reply was modified 5 years, 2 months ago by Mr. Brian Gale.
• This reply was modified 5 years, 2 months ago by Mr. Brian Gale.

That is odd that it is only system databases that are causing the slowness.  My first thought would be to get an estimated execution plan on the system databases and...

This query is close.  The only thing it isn't doing QUITE right is the ordering for the Quarters:

USE [Admin];
GO
CREATE TABLE [#temp]
(
[country]  VARCHAR(20)
, [ship]   VARCHAR(20)
,...

• This reply was modified 5 years, 2 months ago by Mr. Brian Gale.
• This reply was modified 5 years, 2 months ago by Mr. Brian Gale.
• This reply was modified 5 years, 2 months ago by Mr. Brian Gale.

Pretty sure that is baked into SSRS.  If you want to change it, you'd need to build a custom report wrapper page.

Source:

https://stackoverflow.com/questions/13922932/how-to-set-ssrs-parameter-panel-on-the-top

Phil got you most of the way there and your attempts were close.

In the first one, your REPLACE call is missing the values that should be replaced.  If you count...

• This reply was modified 5 years, 2 months ago by Mr. Brian Gale.

Your watch has more features than mine.  And mine does have some limitations (screen brightness isn't that bright so it is hard to read on sunny days, is a black...

I read that your watch lasts 4-5 days.  That's crazy.  My smartwatch gets me a month on average.

I think part of the problem is if battery life improves, device manufacturers...

SELECT name, SUSER_SNAME(owner_sid)
FROM [sys].databases

That query should do it.   Is that what you were looking for?

So, to fix your JSON, you need [ ] around the whole thing as it is an array.

Something like this:

SET @SampleJSON = '[
{
    "name":...