Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #596

Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005

Show all headers | View raw

xo wrote:
<snip>
> The error seems to be caused by the last line.  Add'l info - FLODS_ID
> is (PK, numeric (18,0), not null) and OBJECT_ID (varchar(80), null)
>
> Below is the sql -
>
<snip>
> Thanks in advance

Thanks for the attempt to provide extra information. Unfortunately it was 
both too much and not enough information.
Please provide:
1. A CREATE TABLE script to allow us to create a table with only the 
relevant columns. Do not include any columns that are not needed to recreate 
the symptom.
2. A script to insert some sample data into the table. The sample data 
should include the row that causes the error message.
3. The sql statement that uses the test table to reproduce the symptom

This of course will require you to find the row(s) containing the data that 
causes the error. Doing so might lead you to the answer to your question. I 
suggest you remove tables and columns from the sql you provided until you 
can run it without error. Then add back in a column/table at a time until 
the error does occur. Then try limiting the results using a WHERE clause 
until you identify the row(s) containing the problem data. 

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 xo <xo5555ox@gmail.com> - 2011-08-12 10:33 -0700
  Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-08-12 14:56 -0400
    Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 xo <xo5555ox@gmail.com> - 2011-08-12 13:05 -0700
      Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2011-08-12 16:56 -0400
  Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 Erland Sommarskog <esquel@sommarskog.se> - 2011-08-12 22:06 +0200
    Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 xo <xo5555ox@gmail.com> - 2011-08-12 13:17 -0700
      Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 Erland Sommarskog <esquel@sommarskog.se> - 2011-08-12 22:25 +0200
        Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 xo <xo5555ox@gmail.com> - 2011-08-12 14:31 -0700
          Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 Erland Sommarskog <esquel@sommarskog.se> - 2011-08-13 12:59 +0200

csiph-web