Well I've got Access talking to my test database and I can edit and add rows to tables so in principal it's working, tarting it up a bit and making...

I do have Access installed too as part of Office 2010 so I'm giving it a look right now, using this: http://www.access-programmers.co.uk/forums/showthread.php?t=216956 as a v quick guide for...

I did actually consider Access this morning (for everything) but thought it was a step backwards to try and remember access from about 15 years ago when I was at...

Aye, that does make sense why BIG INT conversion didn't die but did run for ages before I killed it.

Performance may end up being important here, I've not decided, I may just pre-process the data in which case it's not overly important, thanks for the CTE example, I'll give...

Indeed, quite why I didn't just do something like this:

SELECT

t.ID,

t.Title,

(SELECT count(l.log_id) FROM #logs l WHERE l.id = t.id) as AllTime,

(SELECT count(l.log_id) FROM #logs l WHERE l.id = t.id and l.log_date...

What I'm trying to do is something I've not done before (perhaps this is why!), say you've created a temp table - a bit like my example - but you...

I figured somebody might know the answer from the 'double join' side of things...

Here's a couple of test tables with inserts:

create table #logs

(

log_id int,

id int,

log_date datetime

)

INSERT INTO #Logs SELECT 27824224...

I'd like to have time to try the above non CTE approach, time doesn't allow at the moment but hopefully at some point.

FYI the #test replica on my 'real' data...

Thanks for the responses guys, Lynn, I went with your method in the end, it's exactly what I was looking for!

I'm glad I was on the right track knowing some...

I meant to reply yesterday afternoon, I stumbled on the solution, sort of by accident!

On the table in question 'DataElemetStyle' was just left at the default of auto, changing this...

Paul, thanks for the reply, delayed response but to answer your two questions:

1. Both batch and row-by-row queries feature hard-coded numeric values, which are presumably keys for the table concerned....

Gabriel, that makes quite a lot of sense, I guess I could have broken my say 2,000 into blocks of 500 perhaps, however, in that instance out hours makes more...

That was my decision in the end to be honest, out of business hours. Worked out okay for this situation. I guess I was just thinking if one was foced...

Thanks for the response. In the situation I faced last week where I was updating contacts, about 2,000, on a local version of the database this took 1 second, on...