your variable types are not valid for SQL.

look farther up in the output text. you should see an error that tells you exactly where it had the problem.

your other option would be to output to a file and then send the result as an attachment.

just occurred to me that since you are in 2000 you would not be able to puch more than 8000 characters into the variable. My Bad!

Basically if...

you do not need the variable

INSERT INTO dbo.Purchasing(PartNumber, IsHardware, KitAlways, ChinaPN, KitChina, InstallTime, LaborClass, UnitCost)

select

RIGHT('000000' + convert(varchar(6), PartNo), 6),

0,

0,

RIGHT('000000' + convert(varchar(6), PartNo), 6),

0,

10,

1,

null

FROM

dbo.Purchased

before SQL 2005 there is nothing larger than 8000. In 2005 there is Varchar(max) but that feature is not available in 2000. You can generate a string larger...

In access you have to create the linked table connections. Something of note is that whenever you make a change to table structure in SQL you will have to...

Welsh is absolutely correct I had missed that. you have to establish the relationship between the two tables. the current clause is more of a where cluase not...

try this. you can not use a like in a join. but by moving it to the where clause it should work fine.

UPDATE Purchasing

SET Purchasing.IsHardware = 1

FROM Purchasing...

I would take the opportunity to work "What" into every conversation, e-mail, and interaction I could. I would then put "What" posters all over my cubicle. That of...

You need to post some DDL and sample data. That would allow us to provide a better answer.

do you have SSIS available to you. this would be very easy to do in an SSIS package and then you could execute the package from a job.

what are you trying to do with the following lines of code?

CREATE TABLE #GET_EMP_MON_BIRTH

(

emp_dob SMALLDATETIME,

emp_name varchar(255)

)

SET @emp_dob = month(emp_dob);

SET emp_name

I think this is a similiar line of dicussion to a post I addded to someone asking how to get into a DBA position. The smaller companies or even...

The variable @vStart is not declared