You could either use a subquery to get the max effective date per code and join it back to the original table or you could use the ROW_NUMBER approach.

You'd need to UNPIVOT your data followed by a PIVOT (either traditional using CrossTab or the PIVOT operator).

I truly hope you're not sending the password as plain text and compare it to another plain text value....

What concept do you use to store the password?

@Patrick_Fiedler:

Welcome, dear neighbor! (distance:...

WayneS (4/13/2011)

---

Jack Corbett (4/13/2011)

---

LutzM (4/13/2011)

---

I agree, the image data type is not the one someone would expect to find such valuable information. It's also strange that MS still uses the...

I posted a slightly different query as my answer to a quiz question (SQLServer Quiz 2011).

This query is modified to query SSRS 2008 and to return the actual parameter values...

You might want to have a look at

Jacob Sebastians blog (title: "How to find all stored procedures used by Report Server?") 😉

It...

You might want to have a look at Jeffs Running Total article[/url].

Based on the concept described in this article you could use a conditional increment instead of the running total...

Just think about how it'll look like when we all change back to our...

You could use

CROSS APPLY

(SELECT 'Added' AS Activity UNION ALL

SELECT 'Deleted') x

Together with

CONVERT(CHAR(19),CASE WHEN x.Activity THEN Added ELSE Deleted END,120) + ' ' + x.Activity

I'm in!

@steve-2: how many active posters with GilaMonster avatars are needed before the cube icon in the SSC logo is replaced by a GilaMonster picture? 😛

I would use the UNPIVOT approach followed by a self join.

This would cover items 1 to 3.

I don't understand your last requirement (modified column names): How could this happen when...

Either in your JOIN or your WHERE clause you reference two columns with a different collation.

You need to define one collation you'd like to use.

Something like

SELECT *

FROM ...

Here's a SQL Server solution. AFAIK, CASE and CAST should work in SyBase 15.

SELECT

t1.part_id,

t1.adt_ts,

CASE

WHEN t1.pay_clct_am = t2.pay_clct_am

THEN 'unchanged'

ELSE 'old:' +...

Yes, it's possible. I think, XQuery together with CrossApply is the solution here.

You might want to have a look at Jacob Sebastians blog.