SELECT      DATEADD(YEAR, DATEDIFF(YEAR, '19000101', CURRENT_TIMESTAMP), '19000101') AS theDate UNION ALL

SELECT      DATEADD(YEAR, DATEDIFF(YEAR, '19010101', CURRENT_TIMESTAMP), '19000101') UNION ALL

SELECT      DATEADD(YEAR, DATEDIFF(YEAR, '19020101', CURRENT_TIMESTAMP),...

The real question is "Why do you think you need a CTE for this?".

See http://www.sommarskog.se/dynamic_sql.html before you enter the land of denormalization.

See the difference between these two queries

SELECT      CustomerID,

            Item,

            ActivationDate

FROM        (

                         SELECT      CustomerID,

                                     Item,

                                     ActivationDate,

                                     ROW_NUMBER() OVER (PARTITION BY CustomerID, Item ORDER...

Try this

select customerId, item, min(activationDate) from history group by customerId, item

How about 2 * LEN() because it NCHAR?

No need for RTRIM at all with LEN function.

DECLARE

@s-2 NVARCHAR(520)

SET

@s-2 = N

SELECT Name, Age FROM (

SELECT Name, Age, ROW_NUMBER() OVER (PARTITION BY Age ORDER BY Name) AS RecID FROM MyTab

) AS d WHERE RecID = 1

SELECT Age, MIN(Name)...

declare @sample table (custid int)

insert      @sample

select      101 union all

select      101 union all

select      101...

DELETE f

FROM (SELECT ROW_NUMBER() OVER (PARTITION BY Col1 ORDER BY ID) AS RecID) AS f

WHERE RecID > 1

-- Initialize staging

BEGIN TRAN Yak

DECLARE     @LastID INT

SELECT      @LastID = MAX({Property table identity column name here})

For more versatile uses of DATEADD/DATEDIFF combinations, see

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=86769

Are you using SQL Server 2000 or SQL Server 2005?

Hi Ryan. Long time no see.

LEFT JOIN?

DECLARE

@Sample TABLE (ColA INT, ColB INT