Thank you for the reply I did have that earlier and it gave me the same error, but you are right it, of course, needs it.

I have put it in...

• This reply was modified 4 years, 1 month ago by  itmasterw 60042.

Hi,

I am sorry. I went back to the tables and realized that I was looking at the wrong tables. this makes sense now.

Sorry to have bothered you guys with this.

Thank...

Sure here is the table and the procedure:

Notice that while the tabel has a id field the procedure does not. I do not see how this si possable or what...

No that is what gets me it is not an IDENTITY field on any of theses tables. so I am not seeing how they were implemented of how they are...

This worked and was much easier and easy to understand, far beyond anything else that read.

Thank you

Okay thank you for your help.

First thank you for the reply.

Second, I misspelled this, I meant abnormal. Unfortunately I am not able to post the exact data.

However, what my manager is saying is that if...

• This reply was modified 4 years, 3 months ago by  itmasterw 60042.

Okay, that is what I thought.

Thanks

this really got us  a lot closer.

thanks

Thanks this looks great. I only found away to take the first numbers off.

Thank you

Yah, that is what I thought too, but I wanted to see if maybe I was missing something.

Thank you

Yes, I checked that a few times, and I tried other tables as well. They all return data but just not in the file.

Tanks for your help, but while that did create the file but it is blank.

Hi,

So I changed the location and made this as bare bones as I can and it still will not go.

The result show this:

output

'"' is not recognized as an internal or...

HI,

I took it out all together and it was the same result.

• This reply was modified 4 years, 6 months ago by  itmasterw 60042.