There's now a well-known solution to this problem which requires no non-standard functions:

DROP TABLE IF EXISTS #Test;

CREATE TABLE #Test
(
    SomeString VARCHAR(500)
);

INSERT #Test
(
  ...

I think its on my side. My SSMS crashes and restarts. As of now we dont have src control where im at. We're in the process of setting it...

Also, can't you just regenerate the ispac from source control?

Can you tell whether the error is generated locally, or on the server?

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!