You can make use of PIVOT function

http://sqlblogcasts.com/blogs/madhivanan/archive/2007/11/02/different-ways-to-count-rows-from-a-table.aspx

Try my suggestion here

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=59094

Also refer

http://sqlblogcasts.com/blogs/madhivanan/archive/2007/08/27/multipurpose-row-number-function.aspx

Use Import/Export wizard

You should not create/alter a table thru procedure. What happens when you run the procedure twice?

Why dont you wrap it as single procedure?

Also refer

http://sqlblogcasts.com/blogs/madhivanan/archive/2008/09/12/return-top-n-rows.aspx

Other uses of Row_number() function

http://sqlblogcasts.com/blogs/madhivanan/archive/2007/08/27/multipurpose-row-number-function.aspx

Ramesh (5/8/2009)

---

It can also be done using sp_executesql system procedure

declare @DateTime DATETIME

declare @tablename varchar(100)

declare @sql nvarchar(4000)

create table #temp (starttime datetime)

-- Using sp_executesql

set @sql = 'select @DateTime...

You may need to read about Normalization

Also read about sp_executesql in SQL Server help file

Post...

Also see what you can do with row_number() function

http://sqlblogcasts.com/blogs/madhivanan/archive/2007/08/27/multipurpose-row-number-function.aspx

Also refer

http://sqlblogcasts.com/blogs/madhivanan/archive/2008/08/27/dynamic-pivot-in-sql-server-2005.aspx