Eirikur Eiriksson (12/22/2015)

---

patrickmcginnis59 10839 (12/22/2015)

---

Eirikur Eiriksson (12/21/2015)

---

The problem is that xp_cmdshell...

mistaken post removed

Eirikur Eiriksson (12/21/2015)

---

The problem is that xp_cmdshell can only take one...

Just out of curiousity, how far off...

Jeff Moden (12/20/2015)

---

Adi Cohn-120898 (12/20/2015)

---

I think that it is a trivial plan. If I understand correctly (and I admit that that I might not understand it correctly:-D), a trivial...

"SQL code is amongst the worst code to parse without proper formatting."

Incorrect. SQL code will parse just fine without proper formatting.

Gary Varga (12/18/2015)

---

Yes.

So are many employers.

Ideally the worst employers get the worst employees and vice-verse. Strangely enough this is what I have tended to see. The worst employers lose all...

Eric M Russell (12/17/2015)

---

The data comparison feature you're using in Visual Studio; is that the same thing as the SQL Server Data Tools plugin? I've found an MSDN article which...

I'm making a guess about a conflict between "quotename()" function and quoted_name setting. maybe on a test database, flip your quoted name setting (I'm guessing "SET QUOTED_IDENTIFIER OFF") and try...

serg-52 (12/16/2015)

---

Let input be as follows

INSERT#MgtStructure (ManagerID, EmployeeID) VALUES

--('A', 'B'),

('A', 'C'),

('A', 'D'),

('B', 'C'),

('D', 'E'),

('F', 'G'),

('F', 'K'),

('H', 'I'),

('H', 'J')

--,('H', 'A')

Which is correct group for C ?

As OP stated, it's not...

I always thought that library systems / card catalogs were an interesting study in database design requirements.

Maybe it wouldn't be a terrible idea to see what historically has been done...

Yeah I picked that one...

I'm thinking that...

smmkr17 (12/5/2015)

---

Current table

ColA ColB ColC

A 1 Yes

A 2 No

A 1 Yes

A 1 Yes

B 1 Yes

B 2 Yes

C 1 Yes

D 1 No

My result should be

A No

B Yes

C No

If ColA Values A,B...

John Mitchell-245523 (9/11/2015)

---

pietlinden (9/10/2015)

---

John,

It's a recruiter, which makes me wonder, because the number of recruiters in this town that understand and can evaluate the "goodness" of T-SQL code is less...