2 Different Names for the Same Field Condition

[codrutza]

Hi
SQL Server Management Studio Express
Maybe it's a silly question.
I have to write in a stored procedure something like that:
select
table.number,
...

case

when table.Company='A'
then table.Ts as TsA

when table.Company<>'A'
then table.Ts as TsnonA

end

from table

I need TsA, TsnonA in the report I'm doing, but I get error at "as".
Could you help me with this?

 

[bborissov]

You can't do that. You should have two fields TsA and TsnonA.
Then in Report you should handle them.

SELECT CASE when table.Company='A'  THEN table.Ts END AS TsA,
       CASE when table.Company<>'A' THEN table.Ts END AS TsNonA
...

BTW I would do this different way.
Get [Ts] and have one field (bit?) that will should you if this TS is from A or NON A:

SELECT table.Ts,
       CASE when table.Company = 'A' THEN 1 ELSE 0 END AS TsAFlag
...

Borislav Borissov
VFP9 SP2, SQL Server

 

[codrutza]

Thanks for reply. I can't modify the tables.

 

[codrutza]

I already have the formulas in the report, but I've tried to find an easier, faster way....

 

[bborissov]

There is no need to make any changes in the tables, just the resulting query will be with one more field.


Borislav Borissov
VFP9 SP2, SQL Server

 

[codrutza]

I wrote in the select and I obtained the field TsAFlag, but I have no idea what to do with it, I'm sorry. The only way I know to use it is in the report maybe.