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'

Check the contents of TargetEmployers_staff to make sure it contains a value and that it is valid.

You have incorrect code between TargetEmployers_staff and TargetOther

it should be

TargetEmployers_staff & "', '" & TargetOther

I think you have quotes around all your data including bit fields. I suggest you use a...

Can you post the asp code that creates the sql string

The error indicates that you are using execite on a connection object and have a malformed query (possibly a missing quote). As above can you post the asp code that...

alternative method for placing the record count from a table into a variable

DECLARE @sql nvarchar(100),@Reccount int

SET @sql...

CREATE PROCEDURE yourprocedurename

@GlYear int,

@GlPeriod int,

@stockcodefrom char(4),

@stockcodeto char(4)

AS

select stockcode,

[current year sales],

[Last year sales],

[current year last 3 months sales],

[last years last 3...

Try

declare @sql nvarchar(100)

set @sql = 'select @count = count(*) from ' +

@tableName + ' where ' + @colName + ' = ' + CAST(@recordID as varchar)

exec sp_executesql...

Well spotted jarney.

I used what was on the posted question when I answered but took details from the above posts when I answered this...

SETUSER work differently on SQL7 and SQL2K.

SQL7 changes both

SQL2K changes only user_name()

DECLARE @GlYear int, @GlPeriod int

SET @GlYear = 2005

SET @GlPeriod = 1

select stockcode,

sum(case when GlYear = @GlYear AND GlPeriod = @GlPeriod

 then netsalesvalue else 0 end) as...

SELECT su.sysuser_id, su.sysuser_firstname, su.sysuser_lastname

  FROM sysuser su

  LEFT OUTER JOIN sysuser_sysusergroup sug

    ON sug.sysuser_id = su.sysuser_id

    AND sug.sysusergroup_id = '1'

WHERE sug.sysuser_id IS NULL

ORDER BY su.sysuser_lastname, su.sysuser_firstname

or

SELECT su.sysuser_id, su.sysuser_firstname, su.sysuser_lastname

  FROM...

Nice article Andy and congrats. Nice to hear from you.

I personally I'm a developer and will stay that way, have done team leading, supervision and such, and was crap at...

Quote from Micorosft

You do not need to configure any licensing options when installing the SQL Server 2000 tools only. However, when using the tools to connect to SQL Server, you...

All that testosterone. Hey, what a great way to stir up trouble

I agree with you Antares, I always considered it a system table....