I may be missing something on this but the solution seems unnecessarily complex. I generally use the SELECT / INTO method to allow the proc to automatically create the #temptable...

It just keeps getting gooder and gooder 🙂

John

And now for those that want a stored proc:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- CREATED ON====================================================

--8/10/2009 , SQLServerCentral.com

-- DESCRIPTION=====================================================

--Find the first day of week...

Alphonse,

Thanks for the quick post. This is a very clean solution.

John

Jack,

Thanks!

In doing some testing I found that if the DOW you are looking for is also the first day of the month then it jumps to the next target DOW...