Intrebari

Re: probleme cu AS

ioana — Mon, 03 Sep 2007 10:36:08 GMT

Mutumesc frumos!!!

Re: probleme cu AS

ggciubuc — Mon, 03 Sep 2007 09:58:32 GMT

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

probleme cu AS

ioana — Mon, 03 Sep 2007 08:51:05 GMT

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...