expression in derived column issue

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » T-SQL (SS2K8) » expression in derived column issue

expression in derived column issue

Rate Topic

Display Mode

Topic Options

Author

Message

ramesh.sadhu21

Posted Friday, March 01, 2013 5:44 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, April 22, 2013 5:34 AM
Points: 3, Visits: 15

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

Gazareth

Posted Friday, March 01, 2013 8:22 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Monday, June 10, 2013 4:11 AM
Points: 1,474, Visits: 2,344

Hi, what SQL are you running at the moment and what error are you getting?

Thanks

Post #1425541

Steve Jones - SSC Editor

Posted Friday, March 01, 2013 8:33 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 5:09 AM
Points: 31,526, Visits: 13,864

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

ramesh.sadhu21

Posted Sunday, March 03, 2013 6:19 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, April 22, 2013 5:34 AM
Points: 3, Visits: 15

i got the answer

thank you

Post #1425938

« Prev Topic | Next Topic »

Permissions