changing this to dynamic sql implies you need to do the exact same thing, but maybe to other tables with identical structure;

i don't see anything in the procedure that seems...

compulted columns are simply ADD NAME AS {some calculation } [PERSISTED] if you wantthe row values rendered and stored instead of calculated on demand

ALTER TABLE [PIHP].[HIST5657]

ADD

ServiceFromDatex AS CONVERT(CHAR(8),ServiceFromDate,112 )...

you assigned your string to @table, but did not append it to @html;

add SET @html = @html + @table + @tail before you do the email;

you need a @tail...

create a view that contains the query.

create a user, and grant the user access only to that single view.

as long as the query hits a single schema(ie dbo) in a...

best practice is still to use a local drive.

that's the only drives you can consitently depend on exisitng, right?

After creating the backup, you would want to compress the file...

for xml won't let you inject closing html tags any place you want, but what you want to do is make it do the 99% of the work, and then...

not sure why you might limit yourself to 150 chars; database mail, outlook, email clients do not have a limitation like that.

i'm just selecting emails via FOR XML to make...

you've got quite a few things going that are causing malformed html; IE will do it's best to clean that up, but Outlook does not.

i populated your table and reviewed...

is your data double quoted, meaning the value featuring the comma is properly delimited so you can process it?

1,Academy award winners,"Jones, James Earl",moredata

if it's not, you need to go...

if we are talking about checking if an object is no longer valid because columns or tables were renamed , dropped, etc,

i've got this script i posted here on SSC...

i've seen the same on my side, with the default of one retry; an email with to: 'goodemail@somedomain.com;bademaul@somedomain.com' results in goodemail getting two emails.

first thing to do is review who...

i would think youll start with a case expression, and then order by the tagname anyway as the second condition;

how do you get the value "tagor1", for example? uis that...

i leave xp_cmdshell disabled by default , and have processes enable it, perform bcp via xp_cmdshell, and then disable again.

you could perform bcp from a command line SQL job, and...

how about not using #temp, but creating the table in tempdb instead? then it will still exist.

DECLARE @cmd nvarchar(4000) = '

SELECT schema_name(schema_id) As Schemaname,

object_id,

Name as TableName

INTO tempdb.dbo.StagingTable

from msdb.sys.tables...

below is an updated version of it, i posted the original version of it on http://sqlclrexport.codeplex.com/ years ago.

SQLCLRExport.zip