Haha. Steve was posting almost the exact same query while I was posting. Well done sir!!

First things first. When you post question about sql you need to provide details in a way that allows...

Rune Bivrin (1/10/2017)

---

Russell Shilling (1/10/2017)

---

The answer is clearly wrong. Some of these questions are really questionable.

The

will also return the string. The left function...

vpolasa (1/10/2017)

---

In the other thread I mentioned, I'm not getting any error. I'm unable to produce the data as JSON. The sample data I provided in the thread might help...

vpolasa (1/10/2017)

---

Thanks Sean.. I'm not worried about this issue but my main concern is in below thread.

Could you please suggest on how to convert Hierarchical XML data to JSON. I...

vpolasa (1/10/2017)

---

Thanks Drew for your reply. I edited my original post. Could you please retry?

I'm getting below error (sorry for the misleading title):

Maximum stored procedure, function, trigger, or...

vpolasa (1/10/2017)

---

I'm trying to run below code but it's throwing error. Can someone please point and correct what I'm missing?

create table emp_mgr (employee varchar(99), manager varchar(99))

insert into emp_mgr select...

PSB (1/9/2017)

---

Is there anyway I can add new columns TextID and NameID for the numeric fields for Text and Names field ?

--Something like the below resultset

SELECT 1 AS...

I feel your pain there. I have had to deal with that nightmare before too. Hopefully the solution I posted will let...

PSB (1/9/2017)

---

SELECT 1 AS ID,'BRZ Brazil' AS Texts ,'Name3' AS Names UNION

SELECT 2 as ID,'BRZ Brazil' AS Texts ,'Name1' AS Names UNION

SELECT 2 as ID,'VEN Venezuela' AS Texts ,'Name2' AS...

PSB (1/9/2017)

---

What if there are more than one field where same split needs to be done ?

CREATE TABLE #Split

(

ID INT,

Texts NVARCHAR(100),Names...

PSB (1/9/2017)

---

Hi,

I need to remove the number and semicolon and # and just get the text and insert as two rows .

CREATE TABLE #Split

(

ID...

Luis Cazares (1/6/2017)

---

Something like this?

SELECT

pr.Title AS ProjectRoot , pr.ID AS ParentID,

wf.Title AS WorkFlow , wf.ID AS WorkflowID,

...

anjaliagarwal5 (1/6/2017)

---

Hi All,

I posted a question before, but this questions is different then the other one.

I have both sql server 2008 and sql server 2012 on my computer....

Great job posting ddl, sample data and desired output. What I don't understand at all is how you get from your data to the output. The column names don't seem...