my take on the QU process.....virtually same as Craig's but I think I have added in all the safety checks required ....

uses a million row test table.

all credit should...

does this help.....??

http://www.sqlservercentral.com/Forums/FindPost1517185.aspx

what are you expecting to achieve by moving from SQLexpress?

obviously there will be costs for your company...but what benefits?

jdasilva (5/13/2014)

---

I was thinking that...

I did comment it all out and try just the bare bones, and that worked.

I am not the best at the syntax for SQL, so...

assuming you already have

dbo_StaffListings and dbo_OfficeCodes table created and data populated in SQL server

then

start from scratch and rebuild in SQL...I don't think there is shorterm quick fix for all...

can you please post back an insert data script with your expected...

is this anywhere close.....

SELECT id , COMM1, COMM2, COMM3 , QTY,

( SELECT CAST( ISNULL(MAX ( V ) ,0) as numeric(6,2))

...

first off...the correct way of presenting data...based on your spreadsheet.

USE [tempdb]

CREATE TABLE [dbo].[yourtable](

[ID] [int] IDENTITY(1,1) NOT NULL,

[COMM1] [decimal](18, 2) NULL,

[COMM2] [decimal](18, 2) NULL,

[COMM3] [decimal](18, 2) NULL,

[QTY] [decimal](18, 2) NULL

) ON...

deepujagan (5/13/2014)

---

Sorry, for not posting the sample data. Here is some sample data attached. I have issues only when the comm2 has negatives values and comm1 & comm3 are 'Zeros'....

haddoque2000 (5/13/2014)

---

The original table looks like this:

CREATE TABLE [dbo].[FactFinance](

[FinanceKey] [int] IDENTITY(1,1) NOT NULL,

[DateKey] [int] NOT NULL,

[OrganizationKey] [int] NOT NULL,

...

haddoque2000 (5/11/2014)

---

I have spent most of the weekend trying out different solutions for creating running totals. Set based and cursors. None of them worked. T-SQL has always got some gotcha...

robin.pryor (5/9/2014)

---

The job is only meant to be run manually. There are steps that have to be done on someone else's end creating and putting files in place, etc. It's...

rf44 (5/9/2014)

---

Sean Lange (5/9/2014)

---

Makes me very happy that I don't use Access for anything at all...and haven't in a LONG time. Even when I did a few things with Access...

this may or may not help you....years back, I used to do something similar to what you are experiencing and running for multiple sites across a slow WAN.

if I recall,...

is/can your form be based on a single table/sql query?