http://www.sql-server-performance.com/awe_memory.asp

see http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=15101&FORUM_ID=8&CAT_ID=1&Topic_Title=SUM%28%40Month1%29&Forum_Title=T%2DSQL

Not quiet sure what you are saying, but I would put add a trigger on insert.

You cannot added 'character' in you cased 'Jan'. Either convert this to numeric or cast it to Integer type.

May want to group the Time_TargetDelivery.

select Totalcount = (breakfast+dinner+lunch)

from

(

Select

(Select Count(*) From Time_TargetDelivery Where Time_TargetDelivery < breakfast time range) As breakfast,

(Select Count(*) From Time_TargetDelivery Where Time_TargetDelivery < Lunch time range) As Lunch,

(Select Count(*) From Time_TargetDelivery...

SET ROWCOUNT 13

GO

select * from table

GO

Not sure about the automatic process but you can check the sp with select @@version in QA.

http://www.sqlservercentral.com/columnists/dPriyankara/versionservicepack.asp

Use the float data type for very large or very small values and the decimal data type for values that require exact precision.

Exact Numeric Data Types

Exact numeric data types...

Not sure if this what you looking for but look up sp_helpgroup on BOL:

exec sp_helpgroup 'role'

I used the image data type for my simple web page.

Not sure why you want to copy same data into multiple. But have you look into the WHILE statement?

thanks

take a look at this link: http://www.sqlservercentral.com/columnists/sjones/sqlmailresources.asp. Also look-up xp_sendmail from BOL.

take a look at this link:

http://www.sqlservercentral.com/columnists/sjones/sqlmailresources.asp

thanks for all your help....