재익형님 말씀대로입니다. ^^;...
아무래도 Subquery에서... 값이 다수가 넘어오는 것 같은데요...^^;...
확인해보시길...
재익형님은.. 정말 자주 들어오시는 것 같아요..^^;...
언제쯤 얼굴을 뵈올런지...
>>
>> -- 박재범 님이 쓰신 글:
>> >> 원본문을 올립니다.
>> >> 부탁드립니다.
>> >> 1>update desc_mileage set mileage_value = (select b.money * case when b.user_divide = \'1\' then a.poffer_per when b.user_divide = \'0\' then a.goffer_per end from company_info a, desc_mileage b where a.company_name = b.company_name and a.service_name = b.service_name and (b.mileage_value = 0 or b.mileage_value = null) and b.id = \'jebuempak\'), apply_date = (select convert(char(8), dateadd(dd, convert(int,a.apply_date), b.m_date),112) from desc_mileage b, company_info a where a.company_name = b.company_name and a.service_name = b.service_name and b.id = \'jebuempak\') where id = \'jebuempak\' and m_date = \'20010830\'
>> >> 2> go
>> >> Msg 512, Level 16, State 1:
>> >> Line 1:
>> >> Subquery returned more than 1 value. This is illegal when the subquery follows
>> >> =, !=, <, <= , >, >=, or when the subquery is used as an expression.
>> >> Command has been aborted.
>> >> (0 rows affected)
>> >> 1>
>> >> 위의 apply_date는 type이 char(8)이고요
>> >> mileage_value의 type은 numeric(9)입니다.
|