Its just a normal table

ie.. Totalcost field and createtime field

I need to know every 30 minutes base on createtime the sum(totalcost)

thanks

Nelson

I need a statement that go over the intire table looking at the datetime field and give me the results like this:

2010-07-11 12:00 total 1.00

2010-07-11 12:30 ...

Thank you, I got it...

Hi,

Yes i´m using the create scritp BUT when I run it on the second server i´m getting this error:

A transport-level error has occurred when sending the request to the server....

maybe need a service pack??

I just run it on 2005 and get the same exactly error

I need be able to run on 2000 and 2005, but I just run it on 2000

When I run your script I'm getting this error:

Server: Msg 195, Level 15, State 10, Line 1

'SCHEMA_NAME' is not a recognized function name.

Server: Msg 170, Level 15, State 1, Line...

Doesn't work, this is the problem, we are trying to build a report

with a sql script to run that script at the customer to check is

sql server and all...

I answered already

I answer already, please give me the script

thanks

it's because the application running is DELPHI and it cannot run procedure,cursor,create table, just need a script to run

I did not build the application I'm just a DBA

I need a script to analyse the intire sql, all the tables,sizes,logs

spaceused,unusead, free space everything please

help !!!!!!!!!!

I cannot use cursor or loop or create table, I need a simple script to do the job,any ideas?

DAT files are created on old version of sql 6.5