run this in Query analyser and you'll see the problem

Select top 1 * from dbo.SysObjects

Print @@Rowcount

--1

print @@Rowcount

--0

The rowcount variable is reupdated after the print statement. The 2nd time you...

Thank god... I was hopping he was wrong cause a few of my backups would have been wrong :-).

The table is created then dropped within the exec () statement

try :

set @sql = 'select * into #mytemp from ;

SELECT * FROM #mytemp'

exec (@sql)

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??