In this case, that...

I've snipped out both of the additional solutions and will be studying them both. Thank you.

This appears to work, at least for 2010 and 2011 (I verified the dates against the calendar). However, it uses a look-up rather than a calculation.

BEGIN -- Show each...

Jeff Moden (2/17/2011)

---

SELECT CASE

WHEN GETDATE() <= CAST(DATEDIFF(dd,-3,DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0))/7*7+4+14 AS DATETIME) --3rd Friday Current Month

...

abair34 (2/17/2011)

---

SELECT CASE WHEN current_timestamp > (your 3rd week of month calculation)

THEN (altered 3rd week of a month calculation based on DATEADD(MONTH, +1, currenttimestamp) instead of current_timestamp

ELSE (your current 3rd...

For January 2011, that formula returns the 14th, when the third Friday is on the 21st.

DECLARE @LoopDate AS DATETIME

SET @LoopDate = CAST('2011-01-01' AS DATETIME)

SELECT

CONVERT(CHAR(10),

DATEADD(wk,2,(@LoopDate -

Day(@LoopDate)+1)+(6-DATEPART(dw,(@LoopDate -

Day(@LoopDate)+1)))),

121)

2011-01-14

You're welcome. 😀

nadarajan_v (2/15/2011)

---

I agree with you that the...

I am working on assumptions about your table designs based on your description.

Your query is asking for screen names this way:

U.ScreenName AS OriginalPostBy

U.ScreenName AS LastPostBy

Where U = the TBS_UserDetails table.

If...

Thank you.

CELKO (2/14/2011)

---

CREATE TABLE People

(person_id INTEGER NOT NULL PRIMARY KEY,

person_name VARCHAR(35) NOT NULL,

sex_code INTEGER NOT NULL

CHECK(sex_code IN (1, 2)));

INSERT INTO People (person_id, person_name, sex_code)

VALUES (1,...

CREATE TABLE GradeLookupTable

(GradeID INTEGER

,GradeLookupName NCHAR(1)

,CONSTRAINT pk_Grade PRIMARY KEY (GradeID)

)

go

INSERT INTO GradeLookupTable

SELECT 1, 'A' UNION

SELECT 2, 'B'...