Hi Alan,

I will post a new, inproved version of the proc with

identity property.

Thanks

Regards

Yakov

Hi Phill,

thanks for your contribution.

I thought that Enterprise Manager or Query Analyzer always put column names in brackets (on both left and right sides). Your code example does not have...

Hi David,

thanks for comments.

I agree with you... but... this is a procedure that you may use multiple times day after day and year after year ... and the name should...

Here is a proc that will do it. No hard coded values.

You give it first day of the month.

create proc up_Return_Sundays (@start_date datetime)

as

declare @Sunday_Date table (Sunday_Date int)

SELECT @start_date = DATEADD(day,...

Hi Davis,

thanks for opening discussion on this article.

As you know there are thousand articles describing different short cuts of  the Query Analyzer and my article is only one that shows where...