Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 3:52 AM
Points: 194, Visits: 1,106
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-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 3:52 AM
Points: 194, Visits: 1,106
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: Wednesday, June 18, 2014 3:28 AM
Points: 1,044, Visits: 1,839
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