That will work, thanks.

I need to change datatypes of multiple columns within multiple tables. How can I do this? Is there any stored procedure that will allow me to change on sys.types table?

Thanks.

I have resolved the issue.

Thanks again, Jeff.

Hello Jeff Moden,

What is not very clear to me is how to insert or delete data when the data is already existing in the hierarchy table....

Hello Greg,

Thanks for the information, that helps. Have a great day.

Hi Jeff Moden,

I truly appreciate your help. I am working on the the nested set. Only issue could be adding and deleting nodes where I will...

Hello Jeff Moden,

Thank you for pointing me in the right direction. How about using HierarcyID, are there any drawbacks?

Thank you so much for your time,

Rama

Yes, I am inserting into a remote table. Is there any other option besides selecting the record again and then inserting into an audit table?

Thanks.

Lowel and Nadrek,

I truly appreciate your help and time. I will certainly try out the code from Lowell but it will be a while before I...

siggemannen,

Say for example I have a file named my127.edi. How to do bcp or bulk insert for this file?

Thanks for your time.

Thank you Nadarek and Kraig.

Nadarek, That document did help me. By looking at the content of the file clarified some things, but I think I need to have a...

Thank you, but I do not have any layout. There must be some one who is expert on this, or has some idea how I can proceed.

Thanks.

We do not have the layout file, how do I create one or where do I get one?

Thanks.

Lowell,

If you have dealt with EDI before, can you please point me in the right direction? How did you import the data from EDI to SQL...