@sql is not available inside exec master.dbo.sp_msforeachdb

You have to include all the code in the stored procedure parameter.

If your IO needs are really high, especially for read IO:

MySpace replaces all server hard disks with flash drives

http://www.computerworld.com/s/article/9139280/MySpace_replaces_all_server_hard_disks_with_flash_drives

MySpace Replaces Storage with Solid-State Drive Technology in 150 Standard Load Servers

http://www.networkcomputing.com/data-center/myspace-finds-novel-use-of-ssd-technology.php

MySpace...

Also, you can simply return the IDENTITY values inserted in the OUTPUT clause of the INSERT statement.

This is probably the best solution, and the only good solution for the case...

Eugene Elutin (6/25/2010)

---

It is known practice to use INT datatype to store dates especially in large datawarehouses... BUT!

Not in the YYYYMMDD format!

As in order to convert it back tp date...

EXEC sp_MSforeachdb 'USE [?]; EXEC sp_spaceused'

People need to get past the idea that relational databases are obsolete because they don’t do every possible thing anyone could ever want to do with data.

Doesn’t handle streaming interactive...

Look at using the PIVOT operator in SQL Server Books Online.

I don't think anyone said replace single quotes with double quotes.

You need to replace the single quotes with two single quotes.

Do it this way so that you don't have to worry about that problem:

select datediff(dd,'19700101',getdate())

Much more info about handling datetime in SQL Server here:

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

Homework?

It could be getting done manually, it could be a scheduled job on another SQL Server, a Windows Scheduled Task on another server, or it could be launched by an...

Is there some reason you can't use an editor to replace all single quotes with two single quotes?

It is not completely a star vs. snowflake choice.

You could have a snowflake schema that is used to maintain the data correctly, but have a star schema based on rollups...

This shows what is happening:

select

BeforeNoon= cast(convert(datetime,'20100622 11:59:59.997') as numeric),

AfterNoon= cast(convert(datetime,'20100622 12:00:00.000') as numeric)

Results:

BeforeNoon AfterNoon ...

No one is perfect. The most impotent thing for anyone developing code is to test your code completely to make sure it does what you expect.