is it accessing metadata, like sys.tables and stuff,so you KNOW the object sit access exist in ALL databases, or is it assuming that specific tables exist int he database you...

the public role has access to tempdb, so you could create a semi-permanent table that would exist until the sql service was stopped and started/server rebooted, by creating...

not sure if this is what you are after, this was my first guess

/*--Results

ClosestUnder ClosestOver

20 25

*/

;WITH MyCTE([Code],[Number],[Value])

AS

(

SELECT '5',convert(float,'10.00'),convert(money,'1.9201') UNION ALL

SELECT...

did you try the query at all?

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