what you are asking cannot be done in SQL.

SQL does not have image processing, or export to pdf, so you'll need to create an application that does the work...

this. if you don't have the service running, you must...

the convert function has an optional parameter for style/number of decimals? when the converted value is a decimal/float.

https://msdn.microsoft.com/en-us/library/ms187928.aspx

money and smallmoney Styles

When expression is money or smallmoney, style can be one...

you must have a trace or extended event in place,.

SQL does not capture who ran select statements /users info unless you create something to capture it.

theres some really good db comparison tools out there, like redgatecompare, or dbdiff , or a database schema comparison if you have the ultimate version of visual studio. they do...

the modern database mail uses a service broker, so it's fire and forget; you call sp_send_dbmail with the right parameters, and the proc returns immediately, and the service broker tries...

ok, this is tried and true code for an ACE driver example i just retested.

the Sheet in excel is named AK.

does modifying either of these s to be your document...

i've run into issues where the \users folders are extra protected;

i always use something not under mydocuments\mydownlaods\mydesktop, like C:\Data\SQLImportTrim.xls instead of C:\Users\home\Desktop\SQLImportTrim.xls',

can you try moving the file to a non-protected...

adding quick consumable info for others to run with the ball:

;WITH TableA([date],[ID])

AS

(

SELECT '2012-09-21','1' UNION ALL

SELECT '2012-09-28','1' UNION ALL

SELECT '2012-10-05','1' UNION ALL

SELECT '2012-10-12','1' UNION ALL

SELECT '2012-10-19','1' UNION ALL

SELECT '2012-10-26','1' UNION ALL

SELECT...

well the est guess method based on column names might be a starting point, like you mentioned.

how about this:

if can you assume in your data sources that the first column,...

i think the issue is xp_cmshell;

as i remember it, with xp_cmdshell you are limited to a single pair of double quotes to a command, so ONE of your two paths...

JimK 28184 (7/16/2015)

---

Thanks, Alvin. It is a recurring problem, so we try to get as much info from those who know up front, but a lot of times nobody can...

So is everyone goi g to put in th3 same credentials, like Reportreader /SOMEPASSWORD? or will each user have a set 9f sql credentials

Yeah evey table, view, proc and function potentially, but you could script it from the metadata in sys.objects, a d i think you d be up and running.

that sounds like a [data source] or [shared data source] was added, but does not have saved credentials in it.

check the data source of the report you were prompted with.