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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-12 : 08:13:58
|
| Payal Shah writes "DECLARE @IncidentOwner varchar set @IncidentOwner = //I want to add Owned_by_worker_full_name SELECT [workitem_number] as 'Incident #',[owned_by_worker_full_name] as 'Incident Owner',[assigned_to_worker_full_name] as 'Assigned Technician',FROM dbo.HD_workitem_current_view " |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-10-12 : 08:21:08
|
| Why do you want to do this?Let it be as it is and in your select statement you can use alias name for the columnMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Set dynamic value in veriable