Getting Full Name of Employee

Question

1.00/5 (1 vote)

See more:

Hi guys,
I have an problem
In My DSE(Executive)table There is Columns Like
FirstName
LastName
MiddleName
In my stored Procedure i have to concate the string as Full Name(May be temporary column)Si how i can achieve it.
I wrote SP..but dont knw its working or not

SP-
ALTER PROCEDURE dbo.GetDSEFullName
(
@FirstName varchar(50),
@MiddleName varchar(50),
@LastName varchar(50)
)

AS
BEGIN
Declare FullName varchar(500)
SET NOCOUNT ON
DECLARE @Err int
Declare @qry nvarchar(4000)
Declare @temp nvarchar(2000)

Set @temp = null

Set @qry ='
select
DSE_ID from DSE_Info
where DSE_Info.FirstName='''+@FirstName+''' and DSE_Info.LastName='''+ @LastName + ''''

if(@MiddleName is not null)
Begin
Set @temp = ' AND MiddleName = '''+ @MiddleName + ''''
Set @qry = @qry + @temp
SELECT
End

print @qry
Execute SP_EXECUTESQL @qry
SET @Err = @@Error

RETURN @Err

END

Posted 6-Oct-13 19:37pm

indrajeet jadhav

Add a Solution

Comments

Azee 7-Oct-13 2:10am

So you want your SP to return just the full name concatenated? You don't need an SP for that, just create a function and return concatenated full name.

indrajeet jadhav 7-Oct-13 2:14am

How..will you help me ..This Full Name i need to bind Drop Down

4 solutions

Solution 1

Hey there,

I assume, the middle name could be null, so here is a scalar-valued function:

SQL

CREATE FUNCTION GetFullName
(
	@FirstName varchar(50),
	@MiddleName varchar(50),
	@LastName varchar(50)
)
RETURNS varchar(200)
AS
BEGIN
	DECLARE @FullName varchar(200) = @FirstName;
	IF (@MiddleName is NOT NULL AND @MiddleName <> '')
	BEGIN
		Set @FullName += ' ' + @MiddleName;
	END
	
	SET @FullName += ' ' + @LastName;
	RETURN @FullName

END

and here is how you can call it.

SQL

SELECT dbo.getFullName('John', 'J', 'Smith')

Hope it helps, do let me know.

Azee...

Posted 6-Oct-13 20:21pm

Azee

Solution 2

http://sqlhints.com/2012/12/02/concat-function-in-sql-server-2012/[^]

Posted 6-Oct-13 20:30pm

Siva Hyderabad

Solution 3

Awsomeee Work ..Azee ..Thnxx for your help

Posted 6-Oct-13 20:45pm

indrajeet jadhav

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

indrajeet jadhav · Accepted Answer · 2013-10-07T21:32:00

if (dtGetFullName.Rows.Count > 0)
{
for (int iCount = 0; iCount < dtGetFullName.Rows.Count; iCount++)
{
cmbDSEName.Items.Add(dtGetFullName.Rows[iCount]["DSE_FirstName"].ToString().Trim() + " " + dtGetFullName.Rows[iCount]["DSE_MiddleName"].ToString().Trim() + " " + dtGetFullName.Rows[iCount]["DSE_LastName"].ToString().Trim());
// cmbContactCode.Items.Add(dtSearchContacts.Rows[iCount]["ContactID"].ToString());
}
}