|
ramdas
Posting Yak Master
USA
181 Posts |
 Posted - 01/06/2003 : 15:36:27
|
Hi Folks,
Scenario:
I am retrieving a column called forecast from table A. The datatype of forecast is float. This retrieved column is to inserted into a column of data type int. I use a CAST function to convert to int. In case the value is NULL i replace it with 0. When I run the query I get an the following error:
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionCheckForData (CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Statement:
CAST(ISNULL(TableA.[Forecast],0) AS int)
Ramdas Narayanan
SQL Server DBA |
|
Converting From Float to int
