Vill du ange ett alias eller tilldela en variabel ett värde?
Select @Lastdate =
Case When Len(Stoptime_e) = 0 Then
Case When Len(Stoptime_f) = 0 Then
Stoptime_n
Else
Stoptime_f
End
Else
Stoptime_e
End
Vaför? Tja ...
Frågan#1
Varför får jag inte sätta alias så här?
Server: Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near '='.
declare @Lastdate nvarchar(10)
Select
Case When Len(Stoptime_e) = 0 Then
Case When Len(Stoptime_f) = 0 Then
[b]@Lastdate = Stoptime_n[/b]
Else
@Lastdate = Stoptime_f
End
Else
@Lastdate = Stoptime_e
End
From Productionlog_shift sh
Inner Join Productionlog_setup s On sh.Setupid = s.Setupid
Inner Join Productionlog_setup_date d On s.Setupid = d.Setupid
Where d.Regdate = '2003-09-03'