I have a simple way to remove multiple commas in the whole string.Here is the simple one to suffice all the below cases:

1> Removing multiple commas in starting of...

You could try this.

Identifying results meaning...

Given a sample database schema and DML query provided, I have to come up with the results of the sample query.

This is a section of the exam...

who ever posted this "

You can use BBCodes to format your content.

Available BBCodes include: code, b, i, u, s, center, right, left, justify, hr, sub, sup, color, pre, blockquote,...

XML parsing is a common one that is difficult to do for most, but for some people, XML parsing is trivial.

Trivial? Yikes.

hi

I am studying for 70-762 exam and am looking to practice Identifying results of some really good, complex practice queries.   Any good sites for this (besides the official practice...

thank for this reference to look at but that is not what i am wanting. i would like to know what are the possible reasons why powershell works some...

Do you have appropriate logging and error handling within the PoSh scripts themselves? I have seen cases where scripts have apparently completed 'successfully' (ie, they reported success to the calling...

It's definitely on the right track and...

Are the statistics up to date? You might get a more detailed answer if you attach the Actual Execution Plan (as XML) for people to take a closer look at...

... and it also comes up with correct answers.

(As Brian admitted in a later post) my solution did provide the correct answers!

Grant will probably have a great answer to this, but my suspicion would be that the optimiser decided that the cost of scanning the PK would be less than index...

To check out your concern about parallelism being an issue, I suggest that you amend the package property 'MaxConcurrentExecutables' to 1 and try running again.

Parallelism should generally not be an...

After adding [] to make this valid JSON, I came up with this

DROP TABLE IF EXISTS #SomeJSON;

CREATE TABLE #SomeJSON
(
    JSONString VARCHAR(MAX) NOT NULL
);

INSERT #SomeJSON
(
...

• This reply was modified 5 years, 6 months ago by Phil Parkin.

Here's a set-based solution.

DROP TABLE IF EXISTS #x;

CREATE TABLE #x
(
    SomeText VARCHAR(100)
);

INSERT #x
(
    SomeText
)
VALUES
('A[CL]')
,('B[HQUW]');

SELECT *
FROM #x x;

WITH Tally (N) AS
(
 ...

• This reply was modified 5 years, 6 months ago by Phil Parkin. Reason: Tidied up code in final CTE