I know that I said I would leave y'all alone, but I lied. Here is a issue, if you look, I'm setting a varible of assetindex to what is...

Worked perfectly, thanks!

One last question and I'll leave everybody alone. In this script, I'm inserting VEHDESC from IMSV7.COMPVEH into ASSETDESC in FA00100; however, VEHDESC is a datatype of varchar(256) and ASSETDESC...

I completely understand now! Thank you all! I'm going to try it, but I'm pretty sure that I can get it from here!

I guess I'm not explaining myself. I know how to do it the way that you just suggested; however, did you see my variables that I have set to...

So, here is the deal. I know that I can do it the way that you have described; however, I didn't put my full project here. The reason...

I'm new to T-SQL, so I'm sure my code isn't right. I want to loop through all the records and then display them.

Sometimes I just want to say "DUH" to myself!!! :crazy:

Thank you, that worked perfectly!!!

Jordon

COFFEE, I NEED COFFEE!!!!

Thank you very much, you're awesome!!!

Ok, I didn't get a lot of sleep last night, so I'm going blank this morning. Here is my code:

SELECT

IMSV7.TBL308.DESCRIPT, IMSV7.PARCEL.SECTION, IMSV7.PARCEL.BLOCK,

IMSV7.TBL308.DESCRIPT + ' SUB ' + ISNULL(IMSV7.PARCEL.SECTION, '')...

Nevermind, I woke up and got it. For anybody looking to do this, you can write it like this:

Select 'Section ' + Section FROM Table

Just so everybody knows, this is what I ended up doing.

I linked the servers together, using the system stored procedure of sp_addlinkedserver. Once they were linked, SQL looked at...

Nevermind, I got it:

SELECT EMPLOYID,FRSTNAME,LASTNAME FROM UPR00100

LEFT JOIN INFOR.TRAIN.IMSV7.EMPLOYEE ON UPR00100.EMPLOYID = EMPLOYEE.EMPID

I get the same error when I try:

SELECT INFOR.TRAIN.IMSV7.EMPLOYEE.EMPID

FROM INFOR.TRAIN.IMSV7.EMPLOYEE

However, if I try:

SELECT EMPID

FROM INFOR.TRAIN.IMSV7.EMPLOYEE

That works.

I was trying to just query this info to see my results before I did the insert. Both of my servers are linked together through the sp_linkedserver, so I...