the solution was to create a new profile and reference it with @profile_name.

New profile is SQL Email

and it is referenced like this

exec msdb.dbo.sp_send_dbmail @profile_name='SQL Email', etc.

So left join just brings over everything *no matter what* filters I put on the A table on the AND?

I see that appears how it works.   I added another...

• This reply was modified 4 years, 10 months ago by  polkadot.
• This reply was modified 4 years, 10 months ago by  polkadot.
• This reply was modified 4 years, 10 months ago by  polkadot.

thank you so much.

yes, i confused matters by using name @return_value for desired output variable.

Thank you for info on ado.net.  Have made note of it.

by the time i wrote this...

• This reply was modified 5 years, 3 months ago by  polkadot.

Thank you very much!  Having one last issue: in calling procedure I'm getting error: Must declare the scalar variable "@output".

changes made

1 . moved sp_send_dbmail to the calling sproc, just because it...

• This reply was modified 5 years, 3 months ago by  polkadot.
• This reply was modified 5 years, 3 months ago by  polkadot.
• This reply was modified 5 years, 3 months ago by  polkadot.
• This reply was modified 5 years, 3 months ago by  polkadot.
• This reply was modified 5 years, 3 months ago by  polkadot.
• This reply was modified 5 years, 3 months ago by  polkadot.
• This reply was modified 5 years, 3 months ago by  polkadot.
• This reply was modified 5 years, 3 months ago by  polkadot.
• This reply was modified 5 years, 3 months ago by  polkadot.

<accidental 3rd post > not used to new sqlservercentral format

<accidental second post > not used to new sqlcentral format

• This reply was modified 5 years, 3 months ago by  polkadot.
• This reply was modified 5 years, 3 months ago by  polkadot.
• This reply was modified 5 years, 3 months ago by  polkadot.
• This reply was modified 5 years, 3 months ago by  polkadot.

Relief to learn I am to use command line!  thank you.

got it to work with

sqlcmd -S servername -d dbname -E -Q "SELECT * FROM [Schema].[dbo].[Inventory]" -s "," -o "\\address.org\vdifolders$\polkadot\Documents\US570333\Inventory.txt"

• This reply was modified 5 years, 6 months ago by  polkadot.

Hi frederico_fonseca
in the zipped folder 'ssisopenxml' i found
(1) sql script for two tables (I created both in a DB called TestDB )
(2) .dtsx with script task in...

frederico_fonseca  could you add a value to your test table description...

I also tried to write sql to csv file and then csv to excel,  doesn't help.

i don't understand why it is bad.  only you're saying 'Using a spreadsheet to display that much data in one column is unquestionably in the bad idea category 99.9% of...

it's not working in SSIS.  I have posted in Integration Services forum. Same issue with 255 limitation.

I am fine with SSIS since this is just another application I have already experience using (just don't have a licence for it at my current job place).    So...

cast (materialdescription_ups as varchar(max))  didn't alleviate.   Also tried changing General to TEXT datatype in excel column.

is there another provider other than "ACE" that will work??

any experience...

In this case TRIM won't be acceptable.  I have also tried ORDER BY len(materialdescription_ups) DESC, to make sure that Excel knows to set the size of the column to >255...