Hi All,
I am currently having a problem when run a stored procedure.
The set up is as follows.
[Server1].[Database1].dbo.[Proc1]
[Server2].[Database2].dbo.[Proc2]
Proc1 calls Proc2.
Proc2 has an output parameter which is to be returned to Proc1
When I run Proc1 I find that the output parameter from Proc2 is not passed back to Proc1 and the reason that I think it doesn't is because
Proc2 raises a SQL warning "Warning: Null value is eliminated by an aggregate or other SET operation"
The stange thing is that I have tried to use: set ansi_warnings off
this doesn't work.
I have also noticed that if I comment all the code out of Proc2 I still get the warning.
has anyone ever come around this before?
Thanks
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
SQL-4-Life