Skip to Content
0
Former Member
Mar 05, 2009 at 03:54 PM

Derived Table How can I give the results of this SQL Line an Explicit Name.

147 Views

I am trying to create a derived table and I get the error

"each calculated column must have an explicit name"

I added the as shiptype to the end of the line and that did not work. Any thoughts?

shiptype = case when araddr.invno is not null then 'ADDR' else (case when arcadr.custno is not null then 'CADR' else 'CUST' end) end as shiptype,

Thanks

Jeff