i just made a minor change and tested, i got this error because the directory structure is not there yet, could that be it?

Msg 50000, Level 16, State 1, Procedure...

yeah, i think my sum case will do exactly that for you.

what does this return? does it look right?

SELECT

USERNAME as [User Name],

SUM(CASE WHEN [Status_Type] =...

if you look at it the other way, are the last eight characters of the file name always a correctly formatted datestring?

so it-doesn-t-matter-about-dashes04122016.txt? can get me the right values with...

I'm thinking you'll need to group by your username, and maybe some other columns, and use the SUM(CASE trick to count the items meeting your criteria.

my first guess , based...

prachiverma10 (4/12/2016)

---

@Lowell, Thank you so much for your help. I did miss to end the if statement.

Regarding the other issue you pointed out, can you give an example in what...

prachiverma10 (4/11/2016)

---

I have created a trigger, which after getting the inserted values in variables tries to insert in another table.

following is the insert query which is giving error.

insert into tblDoctorPatient...

another reason to avoid them: Linq To SQL and Entity Framework side affects.

we just had an issue with transactions rolling back without any SQL error;

the issue was a linq to...

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...