Viewing 15 posts - 16 through 30 (of 398 total)
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.
--Quote me
February 12, 2020 at 7:13 am
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...
--Quote me
February 3, 2020 at 12:33 am
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...
--Quote me
September 9, 2019 at 4:55 pm
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...
--Quote me
September 9, 2019 at 5:20 am
<accidental 3rd post > not used to new sqlservercentral format
--Quote me
September 8, 2019 at 5:19 am
<accidental second post > not used to new sqlcentral format
--Quote me
September 8, 2019 at 5:11 am
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"
--Quote me
June 19, 2019 at 2:13 pm
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...
--Quote me
March 19, 2019 at 11:35 pm
frederico_fonseca could you add a value to your test table description...
--Quote me
March 18, 2019 at 2:05 am
I also tried to write sql to csv file and then csv to excel, doesn't help.
--Quote me
March 16, 2019 at 1:23 am
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...
--Quote me
March 15, 2019 at 11:16 am
it's not working in SSIS. I have posted in Integration Services forum. Same issue with 255 limitation.
--Quote me
March 15, 2019 at 12:48 am
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...
--Quote me
March 13, 2019 at 11:03 pm
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...
--Quote me
March 13, 2019 at 6:51 pm
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...
--Quote me
March 13, 2019 at 10:46 am
Viewing 15 posts - 16 through 30 (of 398 total)