December 6, 2003 at 6:47 am
Is there any case statement limit bcz when i
use this simple T-SQL i receive
UPDATE DBO.DIM_BOOKING_DETAILS
SET HOTEL_CANC_DATE =
CASE
WHEN SegmentType_FD LIKE 'HOT' THEN '19000101'END,
HOTEL =
CASE
WHEN SegmentType_FD LIKE 'HOT' THEN 2 END,
FLIGHT_CANC_DATE =
CASE
WHEN SegmentType_FD LIKE 'AIR' THEN '19000101' END,
FLIGHT =
CASE
WHEN SegmentType_FD LIKE 'AIR' THEN 2 END,
CAR_CANC_DATE =
CASE
WHEN SegmentType_FD LIKE 'CAR' THEN '19000101' END,
CAR =
CASE
WHEN SegmentType_FD LIKE 'CAR' THEN 2
END,
INS_CANC_DATE =
CASE
WHEN SegmentType_FD LIKE 'INS' THEN '19000101'
END,
INSURANCE =
CASE
WHEN SegmentType_FD LIKE 'INS' THEN 2
END,
OTHER_CANC_DATE =
CASE
WHEN SegmentType_FD LIKE 'OTH' THEN '19000101'
END,
OTHER =
CASE
WHEN SegmentType_FD LIKE 'OTH' THEN 2
END
FROM DBO.DIM_BOOKING_DETAILS A,
TEMP_D29_CANCEL B
WHERE
A.BRANCHCODE = B.BRANCHCODE_FD
AND A.FOLDERNO = B.FOLDERNO_FD
AND A.SOURCE_SYSTEM_ID = 2
after running this i get an error
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection Broken
December 6, 2003 at 12:20 pm
that's what it says, a network error. That being said, can you parse (not excute) the statement?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 6, 2003 at 7:44 pm
December 8, 2003 at 9:59 pm
yes i can parse
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply