Eric M Russell (11/18/2016)

---

Budd (11/18/2016)

---

PLEASE tell me what needs to be done to make something like this work?

DECLARE @PARAM1 VARCHAR(2000) = 'Tom','JOE','BUDD','TIM' --< Obviously this wont work

Select...

Dear Santa,

I know you won't be able to bring me a new laptop this year, but could you just bring more RAM (and a new HDD) for my current one...

andrew gothard (11/18/2016)

---

Brandie Tarvin (11/17/2016)

---

Grant Fritchey (11/16/2016)

---

Announcements include:

SP1 for 2016 (which also has CREATE OR ALTER).

A single development surface. This means all functionality in Enterprise is also in Standard and...

You need to split the string to be able to use the individual values.

DECLARE @PARAM1 VARCHAR(2000) = 'Tom,JOE,BUDD,TIM'

SELECT firstname

FROM Employees

WHERE firstname in (SELECT Item FROM dbo.DelimitedSplit8K( @PARAM1, ',')s);

The...

The code is full of errors. Also, it won't count DDL operations, just rows with an operation_date greater than now.

MMartin1 (11/17/2016)

---

That's how I went about doing it and then had to take a...

Breaker

GilaMonster (11/17/2016)

---

And with only 4 cores,...

Robin

Have you tried with HAVING? https://msdn.microsoft.com/en-us/library/ms180199.aspx

What are you trying to do? Shouldn't the subqueries be correlated somehow?

The sample data is no help. We don't have expected results and I'm not sure you know what to expect from that data.

Hugo Kornelis (11/17/2016)

---

Eirikur Eiriksson (11/17/2016)

---

Brandie Tarvin (11/17/2016)

---

Beatrix Kiddo (11/17/2016)

---

It's in the link there.

CREATE OR ALTER (Yes, we heard you !!!) – New CREATE OR ALTER support makes it easier to...

funbi (11/17/2016)

---

Luis Cazares (11/17/2016)

---

funbi (11/17/2016)

---

Yeah I got

select * from MyData where CHARINDEX('[',mychar,0) = 1

which works fine,...

You're missing WHERE clauses. You might also be taking a bad approach. You need to create a cross tabs query which would be more effective.

Here's an article that describe them

http://www.sqlservercentral.com/articles/T-SQL/63681/

And...

funbi (11/17/2016)

---

Yeah I got

select * from MyData where CHARINDEX('[',mychar,0) = 1

which works fine, then looked at...