사용자 정의함수에서 Begin ~ End 사이입니다.. 그런데 굵게 쓴 부분이 DB내에 함수를 호출하여 임시 테이블 변수인 @OncEnt에 테이블를 넣고 싶은데..
다음과 같은 오류가 발생하네영.. "메시지 137, 수준 15, 상태 1, 프로시저 WeekDayEntLevCntTot, 줄 62 스칼라 변수 "@OncEnt"을(를) 선언해야 합니다. "
Bgin
.....
...
DECLARE @OncEnt TABLE(WeekDate int,
MainSeaEntCnt int, MainSeaLevCnt int, MainOncEntCnt int, MainOncLevCnt int, MainFeeSum int,
BackSeaEntCnt int, BackSeaLevCnt int, BackOncEntCnt int, BackOncLevCnt int, BackFeeSum int,
HakYSeaEntCnt int, HakYSeaLevCnt int, HakYOncEntCnt int, HakYOncLevCnt int, HakYFeeSum int,
DormSeaEntCnt int, DormSeaLevCnt int, DormOncEntCnt int, DormOncLevCnt int, DormFeeSum int,
TotSumBuf int, DateCnt int);.
SET @OncEnt = (dbo.WeekDayEntLevCnt(@FromDate, @ToDate, @MainSeaEntGate, @MainSeaLevGate, @MainOncEntGate, @MainOncLevGate,
@BackSeaEntGate, @BackSeaLevGate, @BackOncEntGate, @BackOncLevGate, @HakYSeaEntGate,
@HakYSeaLevGate, @HakYOncEntGate, @HakYOncLevGate, @DormSeaEntGate, @DormSeaLevGate,
@DormOncEntGate, @DormOncLevGate, @DateCnt));
SELECT @MainSeaEntCnt = MainSeaEntCnt, @MainSeaLevCnt = MainSeaLevCnt, @MainOncLevCnt = MainOncLevCnt, @MainFeeSum = MainFeeSum,
@BackSeaEntCnt = BackSeaEntCnt, @BackSeaLevCnt =BackSeaLevCnt, @BackOncLevCnt = BackOncEntCnt, @BackOncLevCnt = BackOncLevCnt,
@BackFeeSum = BackFeeSum, @HakYSeaEntCnt = HakYSeaEntCnt, @HakYSeaLevCnt = HakYSeaLevCnt, @HakYOncEntCnt = HakYOncEntCnt,
@HakYOncLevCnt = HakYOncLevCnt, @HakYFeeSum = HakYFeeSum, @DormSeaEntCnt = DormSeaEntCnt, @DormSeaLevCnt = DormSeaLevCnt,
@DormOncEntCnt = DormOncEntCnt, @DormOncLevCnt= DormOncLevCnt, @DormFeeSum = DormFeeSum, @TotSum = TotSumBuf, @DayCount = DateCnt,
@WeekDay = WeekDate From @OncEnt
|
