I know I might be a little off topic here, but I use Access ADPS to connect to the server (1 connection by default for the whole application). For...

just change this :

ON [4gl Datamart].dbo.tmp_D_Customer.cust_sys_num = [4gl Datamart].dbo.test_D_Customer.cust_sys_num

SELECT Count(No) as Total, No

FROM dbo.Request

GROUP BY No

HAVING COUNT(No) 1

I'm gonna let you have this one...

So any proof Heather about that statement?

It's a nice trick but it's the slowest of 'em all. The best is still the split function.

It's the same reason I'm always here... Learn something new everyday.

What exactly r u trying to accomplish in this stored proc?... I didn't see any reason to validate the use of a cursor in this case.

Can you post the whole...

can you post the code from all the sps so i can provide a better solution?

add a parameter to the 2nd sp

(Select SERVERID, MAX(UPDATED) as UPDATED, Drive from dbo.YourTable

GROUP BY

SERVERID, DRIVE) Y2

is a derived table, I basically select the last update date for each serverid/drive combinaison. Then I join...

Glad you could work it out.

I guess I didn't make myself clear. I would change the 2nd sp so that it doesn't work on only 1 row at the time, but on all rows...

Well then I would suggest to do as I proposed, but I would choose to have a job run every minute or so (however often you need). This job...

My previous query cannot work... this one is tested and does what you ask :

Select Y2.SERVERID, Y2.UPDATED, Y2.Drive, Y1.FreeSpace from dbo.YourTable Y1 inner join

(Select SERVERID, MAX(UPDATED) as UPDATED, Drive...

never did this but maybe something like that could do it

Select SERVERID, UPDATED, Drive, FREESPACE from dbo.YourTable

GROUP BY

SERVERID, DRIVE, FREESPACE

HAVING UPDATED = MAX(UPDATED)