Thanks for further input:

I have used SQL Server 2000 for years now and I really like the feature where there is a button at the bottom of the stored procedure...

Hi:

Thanks, yes I later found those templates but when I change the template for the:

. . . . Create Stored Procedure (New Menu)

I still get the same old...

OK:

....Could be that I am missing something:

In SQL QUERY ANALYZER, when I run:

PRINT CONVERT(DateTime, GetDate(), 20) OR

PRINT CONVERT(DateTime, GetDate(), 120)

I get:

Jun 14 2007 9:26AM

So the formatt: YYYY-MM-DD...

Hi:

... The suggestion to do GUI-side formatting for date field is well taken. However, if MS SQL Server does provide a date formatting function then such a function should cover...

Richard:

You state that:

. . "Connection objects can only execute "action" queries (insert, update, and delete)"

Could it be that you also meant to imply that the "read" query required that the...

Thanks the two script work perfectly!!!

Anthony

Jeniffer:

I think that the rolling average problem is really an algorithm/script coding challenge where you need multiple code objects that build into the needed script.

E.g. You need a function/sp which will recieve an exam name...

Thanks for all who contributed a solution to this. A few things are noteworthy:

The  formatting method using:

CAST(@MyNumeric AS DECIMAL(8,2)) works OK and data is returned...