SQLRNNR (8/4/2015)

---

That and a...

Grant Fritchey (8/4/2015)

---

xsevensinzx (8/3/2015)

---

In my years working in software development from a marketing perspective, the right way always seems a bit too subjective from the people who are advocating change....

Goose

This can be a complicated issue and it's called relational division. You can search the web about it and you'll find lots of information to learn about it.

Your sample data...

You're right, SQL Server 2014 has a new cardinality estimator which will change the behavior of some queries.

That said, you can't change a LEFT JOIN for an INNER JOIN. They're...

nsca.dev (8/4/2015)

---

Please ignore the previous query that I tried.

I tried this " select (CONVERT(VARCHAR(MAX),(convert(varbinary(max),body)))) from Table " and I got 86 records whereas there are more than 2000 records...

Companies and government can hire aliens in the USA. However, it's harder to get a job because they will prefer citizens who know the culture.

Why? What do you expect to get? The varbinary is the correct way to keep an image on SQL Server.

EDIT: You're getting all the question marks because you use varchar...

ben.brugman (8/4/2015)

---

Yes back to the problem of determining the column names. And then de solution...

I would go with the second option because it allows you more flexibility as you don't depend on traversing the hierarchy using the same route each time. I'm assuming that...

Here's an example on how you can do it, you might need to adapt the code as necessary. This article explains the method used: http://www.sqlservercentral.com/articles/comma+separated+list/71700/

SELECT DISTINCT

task_id,

...

Check this for examples on how to solve the problem:

http://stackoverflow.com/questions/10591044/how-write-sql-to-select-the-maximum-value-in-each-group

If you only need the ITEM_ID, you can use INTERSECT AND EXCEPT.

SELECT ITEM_ID

FROM @t4 t4

JOIN @t2 t2 ON t4.CAT_ID = t2.CAT_ID

WHERE t2.CAT_NAME = 'WHITE'

INTERSECT

SELECT ITEM_ID

FROM @t4 t4

JOIN @t2...

Is he...

Sean Lange (8/3/2015)

---

Michael L John (8/3/2015)

---

I just left a position because I got tired of hearing "That's the way we always did it" AND 'We don't have time to do...