Viewing 15 posts - 18,226 through 18,240 (of 18,926 total)
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...
April 6, 2005 at 9:32 am
just change this :
ON [4gl Datamart].dbo.tmp_D_Customer.cust_sys_num = [4gl Datamart].dbo.test_D_Customer.cust_sys_num
April 6, 2005 at 7:48 am
SELECT Count(No) as Total, No
FROM dbo.Request
GROUP BY No
HAVING COUNT(No) 1
April 6, 2005 at 7:22 am
I'm gonna let you have this one...
So any proof Heather about that statement?
April 6, 2005 at 6:32 am
It's a nice trick but it's the slowest of 'em all. The best is still the split function.
April 6, 2005 at 6:30 am
It's the same reason I'm always here... Learn something new everyday.
April 6, 2005 at 6:25 am
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...
April 6, 2005 at 6:20 am
can you post the code from all the sps so i can provide a better solution?
April 5, 2005 at 2:48 pm
add a parameter to the 2nd sp
April 5, 2005 at 2:18 pm
(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...
April 5, 2005 at 2:16 pm
Glad you could work it out.
April 5, 2005 at 2:09 pm
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...
April 5, 2005 at 2:07 pm
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...
April 5, 2005 at 2:03 pm
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...
April 5, 2005 at 1:59 pm
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)
April 5, 2005 at 1:49 pm
Viewing 15 posts - 18,226 through 18,240 (of 18,926 total)