selectul e urmatorul: 

SELECT func_qjn22_Grp_PfVkn_SOLL.VknID, func_qjn22_Grp_PfVkn_SOLL.TypNr,
func_qjn22_Grp_PfVkn_SOLL.GenNr, func_qjn22_Grp_PfVkn_SOLL.Folge,
func_qjn22_Grp_PfVkn_SOLL.ArtNr, func_qjn22_Grp_PfVkn_SOLL.AnzKrit AS PfSoll,
(CASE WHEN PfSoll > func_qjn22_Grp_PfVkn_SOLL.AnzKrit THEN func_qjn22_Grp_PfVkn_SOLL.AnzKrit ELSE func_qjn21_grp_PfVkn_ist.AnzKrit END) AS PfIst,
PfSoll*10 + (CASE PfIst WHEN null THEN 0 ELSE PfIst END) AS Result
FROM qjn21_Grp_PfVkn_IST() AS func_qjn21_Grp_PfVkn_IST RIGHT JOIN qjn22_Grp_PfVkn_SOLL() AS func_qjn22_Grp_PfVkn_SOLL
ON func_qjn21_Grp_PfVkn_IST.VknID = func_qjn22_Grp_PfVkn_SOLL.VknID

iar eroarea: Msg 207, Level 16, State 1, Line 4
Invalid column name 'PfSoll'.
Msg 207, Level 16, State 1, Line 5
Invalid column name 'PfSoll'.
Msg 207, Level 16, State 1, Line 5
Invalid column name 'PfIst'.
Msg 207, Level 16, State 1, Line 5
Invalid column name 'PfIst' 

 

ok....nu poate folosi in linia de select numele data dupa AS...

de ce?....din moment ce sunt definitte mai inainte si ar trebui sa fie cunoscute nu invalide...

 multumesc anticipat...
 

Nu se poate , iata alta dovada:

daca lansez :

select occupationlabel as a,

(case when occupationlabel='EXEC VICE PRES' then 'exec' else 'nu e ok' end) as b

from dbo.occupation

rezulta

a b

-------------------------------------------------- -------

EXEC VICE PRES exec

FIELDS OPS MGR nu e ok

BUS OFFICE MGR nu e ok

X-RAY TECH nu e ok

(4 row(s) affected)

 

daca lansez

select occupationlabel as a,

(case when a='EXEC VICE PRES' then 'exec' else 'nu e ok' end) as b

from dbo.occupation

 

rezulta :

Msg 207, Level 16, State 1, Line 2

Invalid column name 'a'.

Concluzia , nu folositi aliasul in case ... end

---

Gheorghe Ciubuc,SQL Server Influencer, MCP(SQL 2000), MCTS (SQL Server 2005) , OCA(Oracle 9i), Sybase(Brainbench)

Mutumesc frumos!!!