Thanks

Appreciate the nudge in the right direction guys.

Hi,

OK, SO there are two tables that are used.

/****** Object: Table [dbo].[HOLELOCATION] *****/

CREATE TABLE [dbo].[HOLELOCATION] (

[HOLEID] varchar(20) NOT NULL,

[PROJECTCODE] varchar(10) NOT NULL,

[TENEMENTID] varchar(30) NULL,

[GRIDNAME] varchar(20) NULL,

[HOLETYPE] varchar(10) NOT NULL,

[EAST]...

Unfortunate I need multiple instances due the separation of certain applications and the ability to control them patch them differently.

Apologies,

Question is how to I write the code such that my SQL will return the running totals under the [CUMULATIVE_DRILLED_METRES] column.

You dont.

http://support.microsoft.com/kb/2644592

Nice and easy QotD, thanks.

Good question, foiled by haste.

Thanks for the QotD

Nice back to basics question - thanks

easy as -- answered about a week ago

Nice and easy -thanks Steve

When you say you replaced the PMDB, you recreated a new one ? If so you have lost all your users and need to log in with the admin account...

Nice question - thanks steve

Did a bit of digging...as another explanation

https://www.simple-talk.com/sql/learn-sql-server/window-functions-in-sql-server-part-2-the-frame/

Nice 'n easy, thanks Steve