RE: help with moving from access to sql server

2001-09-07 Thread Daniel Lancelot
any empirical tests - and would be interested to hear others thoughts/knowledge... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 04 September 2001 19:36 To: CF-Talk Subject: RE: help with moving from access to sql server Can't you just use a Convert

help with moving from access to sql server

2001-09-04 Thread Declan Maher
Could anybody help me with the following error regarding datatypes that I am getting having just moved my database from Access to SQL Server 7. I am receiving the following error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot

RE: help with moving from access to sql server

2001-09-04 Thread DeVoil, Nick
Why do you need the GROUP BY clause at all? I don't see any aggregate functions (COUNT, SUM etc) Also, which column is a bit column and does it really need to be? Nick ** Information in this email is confidential and may be

RE: help with moving from access to sql server

2001-09-04 Thread Daniel Lancelot
: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: 04 September 2001 15:48 To: CF-Talk Subject: RE: help with moving from access to sql server Why do you need the GROUP BY clause at all? I don't see any aggregate functions (COUNT, SUM etc) Also, which column is a bit column and does it really need

Re: help with moving from access to sql server

2001-09-04 Thread Alex
use cast() or convert() to change the datatype in your qry On Tue, 4 Sep 2001, Declan Maher wrote: Could anybody help me with the following error regarding datatypes that I am getting having just moved my database from Access to SQL Server 7. I am receiving the following error: ODBC Error

RE: help with moving from access to sql server

2001-09-04 Thread Bryan Love
ACP Internet Application Developer Telecommunication Systems Inc. [EMAIL PROTECTED] -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 7:41 AM To: CF-Talk Subject: help with moving from

RE: help with moving from access to sql server

2001-09-04 Thread C. Hatton Humphrey
, September 04, 2001 1:36 PM To: CF-Talk Subject: RE: help with moving from access to sql server BIT is the correct type to use for a boolean value, but you must think about it first since BIT typed columns cannot be included in a GROUP BY clauses. TINYINT is the one to use for boolean values if you