Unfortunately, I don't remember the error. I will write it down next time.

Why? What if it was query timeout?

What if it was deadlock?

-k

Thanks. It says -1 which means no timeout is set. So how can I get this error if it is unlimited?

I checked the client and the server.

-k

Nevermind. The answer is yes.

-K

Greg,

Thanks a lot. That was exactly what I was looking for.

-K

?Why would that be better performance?

here is what I have so far but it does not work:

DISTINCT_COLUMNS is a table I made with a list of columns I want to find the distinct values for.

alter...

I did not state my request clearly. I need the frequency of each DISTINCT value.

Ex: If column_gender has 2 distinct values (M,Y) I need to find out there are 36...

Worked great!!! thanks 🙂

-K

This did not work.

create trigger mytrigger for update on Mytable as

if update (columnA)

begin

update TableB

set x = a.columnA

from tableB b,mytable a

there is no index on svc_cat.

So the second is faster or not?

-K

query time out is set to 0 (ie. unlimited)

-K

SO it has to rerun the query for each row?

I will buy that book.

-Kevin

Well, this is the exact cursor I was looking at.

select column_name,data_type from information_schema.columns where table_name ='central_regen_fact_table'

order by column_name

--------------------------------

CREATE ...

Andy,

I can get a select statement to work but not a procedure:

select * into zzz

FROM OPENROWSET('SQLOLEDB','server_name';'sa';'secret_password',

'exec sp_spaceused')

error:

Could not process object 'exec sp_helpdb'. The OLE DB provider 'SQLOLEDB'...

Thanks Andy,

I don't suppose there would be any way to dynamically build that table based on the results ?

Like...

select * into table_x from table_y

-K