Viewing 5 posts - 1 through 5 (of 5 total)
Actually it worked I had the last line wrong
this is what I have
CREATE function Get_Pop(@pop_group int)
Returns nvarchar(1000)
BEGIN
declare @r nvarchar(1000)
select @r = ''
select @r =...
October 23, 2001 at 7:59 am
Damn Never mind, i screewed up again!
thank you so much for your help
you saved my ass!
October 23, 2001 at 7:59 am
CREATE function Get_Pop(@pop_group int)
Returns nvarchar(100)
BEGIN
declare @r nvarchar(1000)
select @r = ''
select @r = rtrim(@r) + name + "," from SM_Servers,SM_group_Link where (SM_group_Link.group_name = @pop_group) and...
October 23, 2001 at 7:54 am
Doesnt the function have to return a value!
or inlined within another statement will it automatically do that, sort of like the function getdate()?
October 22, 2001 at 5:01 pm
I tried that and I get this error,
Error 444: select statements within A function cannot return data to a client.
or something like that.
is your example with a UDF or a...
October 22, 2001 at 2:32 pm
Viewing 5 posts - 1 through 5 (of 5 total)