SQLServerCentral / SQL Server 2005 / T-SQL (SS2K5) / Select statements included within a function cannot return data to a client / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 00:19:22 GMT20RE: Select statements included within a function cannot return data to a clienthttp://www.sqlservercentral.com/Forums/Topic715199-338-1.aspxHi,guys.I am new[img]http://www.rlgf.info/16.jpg[/img][img]http://www.rlgf.info/13.jpg[/img][img]http://www.rlgf.info/14.jpg[/img][img]http://www.rlgf.info/17.jpg[/img][img]http://www.ryzu.info/10.jpg[/img]Thu, 15 Nov 2012 19:35:35 GMTstarshayizRE: Select statements included within a function cannot return data to a clienthttp://www.sqlservercentral.com/Forums/Topic715199-338-1.aspxThanks for the suggestion about the inline function. I am a real novice at writing functions and this quickly solved a problem that I was struggling with.Thu, 15 Nov 2012 00:50:43 GMTTom WaitmanRE: Select statements included within a function cannot return data to a clienthttp://www.sqlservercentral.com/Forums/Topic715199-338-1.aspxtks!Command(s) completed successfully.Tue, 12 May 2009 09:43:13 GMTluan.wpRE: Select statements included within a function cannot return data to a clienthttp://www.sqlservercentral.com/Forums/Topic715199-338-1.aspxYou need to assign the returning value from the select to the variable you declared.Like that :[code]DECLARE @var nvarchar(200)select @var = top 1 field1 from table1return @Var.[/code]That will fix your problem, but I think you should use an Inline function for that, just do this :[code]create function fn1@Param nvarchar(100)returns nvarchar(200)asBEGINReturn (Select top 1 field1 from table1 where Field2 = @Param)END[/code]Hope it helps, if you need some working code, just tell me, I only put sample for you to understand.Tue, 12 May 2009 09:20:36 GMTJ-F BergeronRE: Select statements included within a function cannot return data to a clienthttp://www.sqlservercentral.com/Forums/Topic715199-338-1.aspxI suspect that the query is logically incorrect. Since you have declared the variable @Descricao but not assigned any value to it. [code]declare @Descricao as varchar(200)select top 1 lt.txtDescricaofrom gpv_promocoes pinner join GPV_Log lon p.codPromocao = l.cod_objetoinner join GPV_Log_Tipo lton lt.cod_tipolog = l.cod_tipologwhere p.codPromocao = @codPromocao and lt.txtDescricao = @Descricao[/code]Tue, 12 May 2009 09:20:34 GMTRamesh SaiveSelect statements included within a function cannot return data to a clienthttp://www.sqlservercentral.com/Forums/Topic715199-338-1.aspxHi,i'm trying create on function, but the sql print:Msg 444, Level 16, State 2, Procedure Retorna_UltimoLog, Line 9Select statements included within a function cannot return data to a client.somepeople, can help me?the query iscreate function Retorna_UltimoLog (@codPromocao int)RETURNS varchar(200)as BEGIN declare @Descricao as varchar(200) select top 1 lt.txtDescricao from gpv_promocoes p inner join GPV_Log l on p.codPromocao = l.cod_objeto inner join GPV_Log_Tipo lt on lt.cod_tipolog = l.cod_tipolog where p.codPromocao = @codPromocao and lt.txtDescricao = @Descricao order by l.cod_Log DESC Return @Descricao ENDTue, 12 May 2009 09:14:12 GMTluan.wp