HOw come I am not getting my data outputted `

HOw come I am not getting my data outputted `

Post by d.. » Sat, 18 Jan 2003 11:40:17



CREATE Procedure DJP_Logon_Script

)

as






















Begin


End

else

Begin
--get data for Cusotmer exists









End

--output data to Screen








GO

 
 
 

HOw come I am not getting my data outputted `

Post by d.. » Sat, 18 Jan 2003 12:17:12


Sorry this is a Duplicate Ignore this please, at work it did notsay it went
out correctly and
yet I find in in the group already.


> CREATE Procedure DJP_Logon_Script
> (










> )

> as























> Begin



> End

> else

> Begin
> --get data for Cusotmer exists










> End

> --output data to Screen








> GO


 
 
 

HOw come I am not getting my data outputted `

Post by JDP_M » Sat, 18 Jan 2003 12:34:02


What is your exec look like?

The proc does not do any prints so no output will occur.
If you included the prints w/in the proc then it would have output to the QA
window.

If your proc is not returning values, please post your exec that might look
like....

-- also notice that you don't need separate declares.
-- further, you might try using set rather than select



Output




                        OR strEmail
                        OR



included)

-- these could be included w/in the proc....


HTH

JeffP....


> CREATE Procedure DJP_Logon_Script
> (










> )

> as























> Begin



> End

> else

> Begin
> --get data for Cusotmer exists










> End

> --output data to Screen








> GO

 
 
 

1. output parameter not coming back

I am running into a problem and would like to see if someone can help
me.  I have a stored proc in sql server 2000 which is calling another
stored proc in sql server 7.  The stored proc in sql server 2000 has
output parameters.  When I finish the call, I get a value of -1 for
the output parameter which I am not setting anywhere.  The value
should come back as zero from the stored proc in sql server 7.  If I
run the stored proc to call another stored proc that is in another sql
server 2000 machine, then everything is ok.  Any ideas?

Thanks,
Adiel

2. 14072-MO-KANSAS CITY-ORACLE-DBA Skills-Database Administrator

3. I am getting this message when i am tring to export or import anything using

4. Group Selecting top Information only

5. Help - Simply Getting Data from Extrenal Data Files (not from Access Data Base)

6. DBO orhphan of SA

7. Help - I am getting an error using data control

8. Demo version of Oracle 8

9. handling data changes _ am getting stressed thinking about it

10. I am trying to locate the T-SQL debugger which comes with Query Analyzer

11. Not getting Output parameter From SP

12. subquery not getting correct output back

13. Need Help - Not getting output back from stored procedure