sorry, I didn't realize the blog exceed the limit. The example is under this topic 'Summarizing Data Using ROLLUP'.

This is how you handle (source BOL):

GROUPING

Is an aggregate function that causes an additional column to be output with a...

If you want just the date, use an ODBC canonical function

select {fn CURRENT_DATE()} AS 'date only'

or

SELECT {fn CURRENT_TIMESTAMP()} AS 'Timestamp'

See

The easiest way is to use an ODBC canonical function which SQL Server supports.

select {fn CURRENT_DATE()} AS 'date only'

See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcscalar_functions.asp for more information on ODBC functions.

This would be a better approach.

Create the table first:

create table Table2 (col list)

Then insert all the records from Table 1 to table 2:

Insert into Table2

select (col list)

From Table1 with (nolock)