Wow, comprehensive answer!  So there is a God and he understands SQL Server ... all is well

What message are you getting?

Not in SQL Server - but perhaps it's something to do with Magic Software ???, check out:

http://www.magicsoftware.com

This appears to be a logon error - possibly because the external app is trying to log in as sa and the sa password has been changed on the server. ...

This gets you some of the way and may give you an idea about how to finish it off:

select b1.*, sum(b2.units) CumUnits

from basetable b1

join basetable b2 on b1.tdate >= b2.tdate

group...

Why not recast this as a conditional insert?

if not exists (SELECT destination FROM filespath WHERE Destination = @a)

begin

 INSERT INTO FilesPath (Path,Destination)

 VALUES     (@a,@b)

end

Hi Bob

Can you break the script into several stored procedures and then bring these all together in a master stored procedure?  Just use

exec [procname]

within a stored proc to execute another...

I reckon people would be more keen to help if you posted a copy of pornstar.mdb

Under what circumstances does the error message appear?...

Watch out for the possibility that INSERT statements can add a row that has its clustered index value 'between' existing entries - possibly forcing a major rewrite of data on...

Hi Ray, just a quick comment on your response - your final query will, in fact, only return those orders that are placed at the same millisecond as the query...

I would have thought that the GROUP BY clause would ensure that city5 would not be displayed 3 times - ** please test and post the results along with the...

I'm having a bit of trouble working out what you want.  Is it something like this?

select t1.city, t1.name, sum(no_of_games)

from test1 t1

join test2 t2 on t1.city = t2.city

join test3...

By "reflexive", do you mean a self-join? If so, I agree with Phill Cart's response - just add the table again and Access will create an alias for it.

There is - use the SQL pane and write the query yourself.  Is that what you mean?

It is possible to restore without the log file - SQL Server should create a new log for you.  Are you working in EM or QA and exactly what is...