Why my SQL Function returns unexpected value?

Question

I am writing a function where I need to fetch Title(e.g. Mr/Miss/Mrs) FirstName and LastName from a table based on a comma delimited string containing user emails.

so far I have tried following

My SQL Fiddle PS. First build the schema on fiddler page and then try to executing queries

When i run following

select dbo.fn_getUserNamefrmEmail('[email protected]')

I get proper output as Mr. Abc Def

but when i try to run

select dbo.fn_getToUserNames('[email protected], [email protected], [email protected], [email protected]',',')

I am getting NULL - 0 as i have set result to 0 if it is NULL

I am unable to understand what am I doing wrong and need help.

+1 for preparing a fiddle. If everyone could do that...

Szymon
– Szymon

2014-05-04 08:34:08 +00:00
Commented May 4, 2014 at 8:34 — Szymon
– Szymon, Commented May 4, 2014 at 8:34

Szymon · Accepted Answer · 2014-05-04 08:31:08Z

5

There is only one small problem.

Change the line

DECLARE @result_string nvarchar(max)

to

DECLARE @result_string nvarchar(max) = ''

You haven't initialised @result_string variable so it remains null when you do

SELECT @result_string = @result_string + ', ' + @temp

And the end result is still null.

Correct version in SQL Fiddle.

answered May 4, 2014 at 8:31

Szymon

43k16 gold badges99 silver badges115 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Why my SQL Function returns unexpected value?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related