One way is to get into correlated sub-queries, but appart from being very complicated they are not very fast. A simpler way would be to create a temp table (by...

Access is a wonderfull client application! (far superior to VB6). BUT there are loads of problems with queries on tables linked to SQL Server - some bugs in the drivers...

Also consider

Over here in the UK we start national numbers with a zero (eg 01273 876986) whereas international numbers start with two zeros (eg 00 01 786 876 5678). If...

On the topic of Paging (ie getting the next 10 records) - the links seem rather limiting - how about: (using pubs)

-- First 10

select top 10 * from employee

order by...

Using Enterprise manager view the database (in 'task pad' view for SQL2000) and select 'Table Info' - Compare the two databases and I suspect you will see one or more...

Have you tried using transactions?

If you begin a transaction when you read the data and comitt it or roll it back when the user has finished with the record you...

Sub queries can give nice concise code, but are not very efficient. With a big data set you are much better off creating an intermediate temp table - not so...

You all seem dead set against views so let me put a point in their favour.

1. You can update data if its in a view - this could be a...

One of the problems with xp_cmdshell 'DTSRUN.EXE etc is you can't tell if the DTS package ran successfully or not, so I would look at Phil Carters suggestion. My...

Each time you run 'INSERT INTO temp1 ' you create a new record. Try the following code.:

create table myTemp (col001 varchar(250))

insert into myTemp values ( 'this is some text' )

insert...

I would try:

Update LT Set LT.FileCreatedDateTime = Updated.FileCreatedDateTime, LT.FileType = Updated.FileType, LT.SourceFileName = Updated.SourceFileName

FROM Updated inner join ImageCostFileImportLog LT on LT.RecordId = Updated.RecordId

The advantage of this is it still...