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...

I don't think it's necessary to use both a CTE and a derived table here. The following is untested, but should work.

WITH SQLPaging AS (

SELECT...

How about an EXCEPT?

SELECT t1.col1

FROM T1

EXCEPT

SELECT t2.FkCol

FROM T2

Drew

There are two variants of the CASE statement

CASE <Expression>

WHEN <Value Expression> THEN <Result Expression>

or you can use

CASE

WHEN <Boolean Expression> THEN <Result Expression>

You...

lduvall (8/3/2009)

---

I want to pull records for sessions two weeks prior to their start date and I want to continue pulling them until two weeks after their end date. I'm...