Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Derived column question with ISNULL Expand / Collapse
Author
Message
Posted Monday, December 16, 2013 10:59 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, February 3, 2016 3:05 AM
Points: 214, Visits: 1,341
I have very simple requirement. I would have done this at the query level. Just wanted to learn how to do it in SSIS also

CASE WHEN MiddleName IS NULL THEN FirstName + ' ' + LastName ELSE FirstName + ' ' + MiddleName + ' ' + LastName END AS FullName

Just wanted to check how i can use ISNULL in derived column to build new column
Post #1523358
Posted Monday, December 16, 2013 11:07 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, February 3, 2016 3:05 AM
Points: 214, Visits: 1,341
ISNULL( MiddleName)? FirstName + LastName:FirstName+MiddleName+LastName

Got it
Post #1523366
Posted Tuesday, December 17, 2013 1:42 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, February 4, 2016 4:52 AM
Points: 1,069, Visits: 1,940
You forgot to add a space delimiter between names

Regards/Raunak
Now a member of Linkedin

Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum
Post #1523562
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse