No this will be a stored procedure

Select (FirstName + '/domain') as myfield

So FirstName is the name of one of your fields (used as an example) and the part after is what you want to...

Sure thing duh! LOL..

Sorry guys.

https://www.dropbox.com/s/1nr8j939esk7p3g/GetMessage_ess__2014-09-10T20_12_55.xml?dl=0

I created an XSD (I hope) Is there anywhere you might be able to point me in using this to automatically create tables in SQL that match the XML...

I don't have any xsd and im not sure that is available to me. That said I will have a look at the script, thank you!

I get this error with the latest revision (containing the full path)

Msg 537, Level 16, State 2, Line 10

Invalid length parameter passed to the LEFT or SUBSTRING function.

Can't figure out...

Personally I love ApexSQL products. They have one called ApexSQL Doc.

This will document the entire database including any objects, ssis, ect.

You can select the databases, tables, functions, SPROC's, SSIS, ect...

Ok I saw that after posting... sorry. So I made a couple changes and now I don't get a specific error but I don't get a file generated either.

The...

Ok Now I am having a problem with a similar procedure as posted previously. I can not figure out why this will not run, can someone help please?

The error result;

SQLState...

Thats did the trick. You have no idea how much of a help you have been. Thank you so much!

I am very very close now.. thank you so much for your help..

I have one more issue. Now I create an export that is 0 bytes with an error of

Enter...

I have tried that but I could not get the syntax correct I guess.... Here is where I am calling the DB

EXEC eDirect..xp_cmdshell @bcpCommand

the instance and server are both...

Still no go :(.

Changed to:

DECLARE @bcpCommand VARCHAR(8000)

SET @bcpCommand = 'bcp " SELECT * from ##TempExportData2" queryout'

SET @bcpCommand = @bcpCommand + 'f:\FFMun\FirstMerrit\Output\FirstMerritFFMun.xls -S -C -U sa -P...

Thank you for your reply.. Here is the SPROC with some data altered of course.

(

@dbName varchar(100) = '[eDirect]',

@sql varchar(8000) = 'select LastName, FirstName, PreTitle, SufTitle as Suffix, OldPriNumb...

Thank you everyone for your help. These solutions did not do the trick however I did manage to solve the problem. It MAY not be the most efficient method; took...