SQL 2000 dump declared value to file.

[SBSP]

I i have an SQL statment that is rounding a value some how.

I need to dump a declared value to a text file at the end of the statement.

So i can see what the result is.

the declaration is @INPUT_VALUE

how will i write (APPEND)
@INPUT_VALUE to file ?

Vice ?

Edit:

Man this is stupid all i want to see is @INPUT_VALUE value.

Can i not push that into an new table ?

[viceroy]

Not sure exactly what you want?

You could just print the value

PRINT @INPUT_VALUE

It will show on your query screen under messages.

Do you HAVE to have it outputed to file?

How are you outputing to file?

[SBSP]

Thanks man.

No I just need to see the values.
It doesn't have to go to file.

Let me try


Edit.

Hi

No i dont think thats going to work.

I have a stored proc (Proc1) and with in that stored proc it executes another stored proc. (Proc2)

Stored proc gets run by using a local package.

I need to see the results of stored proc2

[viceroy]

Hmmm, okay,

Well I'd still say run the Proc 1 from Query Analyser and use the print command from within Proc 2

If the value is as expected while running from QA but different when run from a package, then there is an issue, possibly with conversions taking place?

[SBSP]

Ok couldn't get that right.

Can i not pump it into a new database.

I have a backup database.

Called BAKDB with table Called HDDATA and Field HD031

How would i 'Insert Data' into the BAKDB ?

all i can find is

INSERT INTO table_name
VALUES (value1, value2,....)

Code: Select all

INSERT INTO BAKDB.HDDATA
VALUES (@INPUT_VALUE )

Will the above work ?

[viceroy]

insert into bakdb..hddata
(hd031)
select @input_value

[SBSP]

Thanks I'm running it now.

It takes about 20mins to complete.

[viceroy]

cool.