Would this not be better

INSERT INTO [360_QuestionResults] (Question, Role, GroupId)

SELECT r.QuestionNumber, r.Role, r.GroupNumber

FROM [360_Reference] r

LEFT OUTER JOIN [360_QuestionResults] q

ON q.Question = r.QuestionNumber

AND q.Role = r.Role...

Do it in the report. Something like this. You will have to pad this with html (paragraphs, table etc).

<%

prevcompanyname = ""

if rs.eof = false then prevcompanyname = rs("companyname")

do until rs.eof

if...

I also answered this in the other thread.

Wow this is confusing

The correct answer is still wrong....

yep, this time I failed to give the wrong answer

Wish I had

If you are comparing data from 4 cursors to another cursor then there must be a common key, so join the data using the key and do the matching, why...

Are you matching across groups (tran id) or within groups and how many columns are you differentiating. Can you post tables structures and query that produces the cursor.

Additional,

Did a test with data containing a comma and got the error you specified.

I did a test from SQL7 to SQL2K with no problems. As stated above BCP in will generate new timestamp values. If the two table structures are truly identical then...

If you are running sql under the system account maybe the cause.

In Control Panel, Regional Settings, set the locale and date/time settings and tick the box called Set as system default...

select [desc]

from (

select Parentid,

  0 as [key1],

  0 as [key2],

  Parentdesc as [desc]

  from Ptable

union

select Parentid,

  1 as [key1],

  cast(Descriptionid...

select col1,col2

from (

select col1,col2 from tablea

union

select col1,col2 from tableb

) a

order by cast(col1 as int)

Have not tested, but try this

insert openquery(linkedservername, 'select col1,col2,col3 from tablename where 1=0') values (col1value,col2value,col2value)

I use dynamic sql and sp_executesql

SET @sql2 = 'select * from openquery(' + @linkedserver + ',''' + @sql + ''')'

EXEC sp_executesql @sql2

Make sure you understand the risks with dynamic sql (injection...

These links will help, plus check Books Online

HOWTO: Add a FoxPro Database to SQL Server as a Linked Server

http://support.microsoft.com/default.aspx?scid=kb;en-us;199131

HOWTO: Do SQL Server 7.0 Distributed Queries With FoxPro .dbf Files

You could set up a linked server to the foxpro database and use

update openquery(linkservername, 'select colname from tablename where keyname = keyvalue')

set colname = 'updatevalue'