simple

2 options

shrink the log or get more disk space (possibly by moving the log or data files) - both of which need access to the server.

ok - you've switched back from sum to average now - so i've modified to do both

think about what you are grouping by ---- you've still got convert(varchar(20)....) in there...

sorry chap , that means the information you have posted is useless... if you don't have access to the server then how are you going to fix it anyway...

ok - so change your grouping and, order by and select to use

DATEPART(hh,mydatecolumn)

i'm sure you can then figure out how to display the date in the query

hold on you said the log file was 80GB????

here is an example

select CONVERT(varchar(20),dateprocessed),COUNT(*) from mydb.dbo.mytable

where convert(date, dateprocessed)=convert(date,getdate())

group by CONVERT(varchar(20),dateprocessed)

order by CONVERT(datetime,CONVERT(varchar(20),dateprocessed)) desc

and add some function to limit the records - such as

where convert(date,mydatecolumn)=convert(date,@red)

what is the date column on the levels table called then ? you didn't post the table structure so we can't really help

but you need to change @reading date to...

remove the single quotes - you have turned your variables in to strings

'@StartDate' should be @StartDate

use a windowing function

try this

Create table demo(x nvarchar(20))

insert into demo values('abc')

insert into demo values('abc')

insert into demo values('abc')

insert into demo values('def')

insert into demo values('jkl')

insert into demo values('jkl')

delete y

from

(select x,ROW_NUMBER()...

i think somebody is giving you missinformation - shrinking the data file will give you fragmentation..... shrinking...

ok - can you run the command

sp_helpdb

against your server and find out what the recovery mode is on that database (its either simple, full or bulk logged)

then run the...

you don't need the group by clause... @readingdate is a variable, not a cloumn

thanks for that - but on other servers we can see the memory being released.... thats what looks unusual

in that case look at the official site

http://www.microsoft.com/learning/en/us/exam.aspx?id=70-432

it lists all of the details you asked - pre-requisites, how to prepare, time limits, number and type of questions