Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 Assign Text Value to a Table Column

Author  Topic 

kathyc
Starting Member

9 Posts

Posted - 2009-03-07 : 11:03:06
I have created a table with the following columns:

lead State Total #
Open
Disqualified
Closed

For the other 2 columns, in my sql code I calculate
the Total #.

How do I assign a text value of 'Open" to the Lead State
Column?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-03-08 : 13:05:41
dont you have the values Open, Disqualified,... stored inside field in your table?
Go to Top of Page
   

- Advertisement -