Mark - it looks like the OP is still evolving...

No problem - take "c.data_view = 'BASE' " out of the WHERE clause and put it back into the CASE statements.

Cool, that's good so far. Thanks for posting the results.

You can get rid of the "extra rows" by using a simple aggregate:

SELECT DISTINCT

org_id = a.organization,

org_name = a.name,

TB...

yingchai (1/13/2012)

---

Hi ChrisM@home,

Removing the WHERE clause does not help. It still throws the same error...

Msg 8152, Level 16, State 14, Line 9

String or binary data would be truncated.

The statement has...

Ooops sorry my mistake - you want to check that [Organization] exists in the Organization_table.

Firstly, can you try this alternative to the existing code? I don't think you need...

yingchai (1/13/2012)

---

....By looking at the script above, I had hard coded the four organization ID in the WHERE clause (line 14 to line 17). How can I modify the script...

Since the query above resolves out children from parents, you first have to resolve the parents of the groups you want to pass in:

;WITH

Groups AS (

SELECT GroupId = g.Id,...

Evil Kraig F (1/12/2012)

---

nick-1043370 (1/12/2012)

---

Speaking for myself I'd rather get something, work out whether it works in the context of the problem, and then re-pose the question if necessary. If...

sjimmo (1/12/2012)

---

The variable contains a telephone number. In this case, it could be a cell, home or work phone. The reason for the...

You're welcome.

Can I recommend to you the link in my sig "please read this"? It's quite funny, and it's helpful for new forum members too.

Cheers

ChrisM

I think that's the same as this:

Select i.name as Server, fd.path

FROM dbo.Inv_Installed_File_Details fd

JOIN vComputer i ON i.Guid = fd._ResourceGuid

WHERE fd.name = 'ESRDEF.BIN' and Path not like '%BinHub'

AND (

(i.[OS Name]...

Not without a clearer idea of what...

GSquared (1/12/2012)

---

Brandie Tarvin (1/12/2012)

---

GilaMonster (1/12/2012)

---

Bex (1/12/2012)

---

From someone who is a lurker on this site, I take the attitude that if I ask for free help and I don't like the...

SQL Kiwi (1/12/2012)

---

Jeff and Chris,

You've missed the point I was making, and have chosen to assume that I am either (a) not aware of the performance issues involved; or (b)...

Jeff Moden (1/12/2012)

---

SQL Kiwi (1/11/2012)

---

It's pretty tough to imagine a list of dates long enough to make any practical difference regarding performance here. Before anyone says it, yes I...