Lowell (8/12/2009)

---

the forum doesn't like things that look like html tags....wierd results occur, like the clickable button above, which got rendered as an object instead of text:

i had to find...

My solution will work for stepparents as...

That's much better. Try the following code:

SELECT SCT_NAME, [1] + IsNull(', ' + [2], '') AS Parents

FROM (

SELECT

...

I think that this line from BOL...

You're going to need to use a PIVOT (or equivalent). If you want a more detailed answer, I suggest that you follow the forum etiquette guidelines and post the...

The following query only queries #tmp once.

WITH Z_cte AS (

SELECT id FROM #tmp

GROUP BY id

HAVING Min(value) = 'Z'

...

There's actually another reason. SQL returns (a) result set(s). The blank line is simply not part of the result set, so your options are to separate your single...

You shouldn't be doing formatting in T-SQL. You should be using a formatting tool like SSRS.

You can trick T-SQL into doing this by adding a COMPUTE BY clause (which...

Think of Translations as a big CASE statement. CASE Language

WHEN 'French' THEN [French Description]

WHEN 'English' THEN [English Description]

WHEN 'Spanish' THEN [Spanish Description]

etc.,

Translations simply picks which columns to display based...

sarvesh singh (8/9/2009)

---

Eventmeasure table gets eventid from event...

Who is this "Allen" that you are referring to?

Drew

If you can get those values, then probably the easiest thing to do is to create two calculated columns: one for Total Amount and one for Rate Amount. Populate...

One other thing. You do not need the TOP 100 PERCENT. It does absolutely nothing for you and might cause a performance hit.

Drew

For an EXISTS clause to work, you almost always want to have a correlated subquery. If you can run the subquery alone, then it's not a correlated subquery. ...

Yeah, I noticed that the alias would not be recognized after I posted. I really should have tested before posting. I still prefer a CTE to a derived...