We're gonna say this one more time. There's no point in mixing both technologies, you either work from sql server or from access, whereever the data is. There's no...

, SUM(CASE WHEN ConnectTime > 0 and CRC 'ANS' THEN 1 ELSE 0 END) as AnswerCount

why don't you modify the values with an update statement?

WHERE work_ord_num LIKE @work_ord_num + '%' AND

actually it might be the other way around...

In my case I had the id in char because of presentation, once I moved the id to the int column I create...

I'm no expert in this but you can use the import wizard to find out how :

Right click on the db in which you want to import the data

--...

exactly... also you should convert it to int (unless it's impossible with the data).

Also even some have disagreed about this I've seen a huge speed improvement in changing my primary...

name is sysname(128) = 128

number and colid are smallint = 4

Text is nvarchar(4000) = 8000

So you can definitly bust the 8094 limit there. But as John suggested, you can...

Yes this is prtty much what you had posted a few weeks back... that's what made me realize how much of a killer it can be.

DTS the tables to sql server and do the work there. Looks like you'r trying to dig a big hole with a spoon instead of using a shovel... ...

Deterministic udf aren't so bad to use Frank... but I'd agree that some function uses can be devastating on performance.

Hey Frank, why did you change your avatar??

This will do what you want, but without the identity (all the values will be unique but many numbers will be skipped).

Select Distinct C.name, (Select count(*) from dbo.SysColumns C2 where...

Have you considered my advice on keeping the work_ord_num in a separate column so that a index seek can be used? You'll see a huge speed improvement even on...

I think you could have an instead of update on views that could be coded to reinsert the data in the base tables.

But you could also have a table or...