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

expression in derived column issue Expand / Collapse
Author
Message
Posted Friday, March 1, 2013 5:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 1:09 AM
Points: 3, Visits: 19
I want to cretaed new column in derived column with default string valuve like


Column name Expression
TableName FactFDDCellQHourlyPegEricsson1

I have tried in many ways converting into sting and text but it showing an error, Plz any one help me to get out of this.
Post #1425449
Posted Friday, March 1, 2013 8:22 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 3:38 AM
Points: 1,852, Visits: 2,961
Hi, what SQL are you running at the moment and what error are you getting?

Thanks
Post #1425541
Posted Friday, March 1, 2013 8:33 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 7:43 PM
Points: 33,046, Visits: 15,152
It's not clear what you are trying to do.

There's a Derived Column transformation. Do you mean a computed column?







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1425550
Posted Sunday, March 3, 2013 6:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 1:09 AM
Points: 3, Visits: 19
i got the answer

thank you
Post #1425938
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse