aspfaq.com, among many others already noted.

If beginning, wrox book about asp 3.0 is ok.

Have fun...

Elno

Not at all.

Briefly, here is what I remember (80 hours ago already...). There was two cursors. I usually copy-paste the first 'fetch next to...' to the end of the cursor....

problem solved.

Thank you.

I don't know why, answers are faster to find after a post

racosta, here is input about the select:

The value appears once in the source file.

It appears once in the source table (with a select * from table).

It appears once with a...

Absolutely certain that the value is not good from the start, because I do a 'print' before each exec.

The value that comes back all the time exists once in the...

Here it is:

DECLARE c_st_eq CURSOR

FOR

SELECT DISTINCT

c_t_eq,

co_st_eq, n_st_eq

FROM dbo.so_t_eq

WHERE co_st_eq IS NOT NULL

Elno

Thanks for the tip.

Problem solved, from what I can see, actually the way described by A.Mitchell on

http://www.sqldts.com/default.aspx?6,222,254,0,1

Thanks again,

Elno

Thanks for input.

As far as I can see, NULLs are 'ex-numbers'. However:

- most of the numbers transfer ok

- format in excel is 'standard' for all cells (about 50 nulls for...

Basically, there's no transformation (data unchanged). In Excel, it's a column with 1 char. (letter or number, but lenght of 1). In sql, it's a nchar 1. Some lines are...

Thanks.

Steve, details about the 'issues' would interest me. Sorry if you mentionned them elsewhere and I didn't see them.

Elno

T-SQL (from QA object browser)

sorry-wrong button 🙁

Edited by - elno on 12/11/2002 10:45:35 AM

Thanks a lot for the answer.

What would be the risks of debugging on production server?

Could profiler be of any help there (keep traces of changes, to follow errors 'in retrospect)?...

What an evolving world we live in...

Latest news:

I executed a proc from a client account with incorrect data (// in int field). The error message was generated, no pb.

I executed...

Doesn't work on another machine (problem occurs).

Doesn't work on a machine 2ft away from server.

As always, on and off.

Could installation of SQL Server on the Server be the cause? Could...