assuming DCDate is the Deceased Date, and you can only die once(except in the movies)

here's my best guess:

SELECT

a.PatientNumber,

MAX(a.DCDate) As DCDate,

Count(a.PatientNumber) as PatientVisits

FROM [PatientData] a

where a.DCDispCode = '20'

and...

here's the script with all columns in T.* exploded out to their full name.

you can remove what you don't need easier than i can.

object_name(object_id) has an additional optional parameter, db_id,...

isn't error 0x80004005 file permissions, ie cannot access \\servername\sharename\filename.xls?

this is probably after you publish /delopy the package(so it runs under a different user on the server), but works fine...

well here's how i do it:

deadlocks are already in the extended events. nothing extra needs to be done with that.

i have a stored procedure that pulls the "latest" deadlock from...

i did this once, but it's been a while, and it actually worked.

same issue, hardcoded code to three part naming conventions.

it's been a while, but i obviously made sure i...

it's just syntax.

you want to select modified data, and insert is still just an insert. i saw what you were tryingto do, though.

below is a better example

Insert INTO (

[ScenarioID]

,[CostCenterID]

,[CostCenterName]

,[FunctionID]

,[FunctionName])

SELECT 'Budget2013'...

My prod system s busy, but not 500 queries per second busy.

I've run that particular query quite a few times on production, during prod hours, since it's hitting the DMV's,...

what does "not working" mean to you? you did not mention any errors, and convert(varchar will return a string, albeit maybe a string that looks like a date, but it...

i believe this is one of Glenn Berry's scripts, that determine the most used stored procs.

you could infer that the procedure called the most, might be the ones called the...

add the column ReportServer.dbo.Catalog.Hidden to your query.

when a folder or report is marked as "hidden", you have to change the view in SSRS to "Details View" to see those hidden...

if your filegroup is not empty, you might need to alter some indexes and recreate them in another file group.

this would show you theFileGroup Name and the file a given...

absolutely great job on providing the set up sample scripts.

Am i underthinking this, that it is simply a group by problem, maybe with a NOT EXISTS?

it looked to me...

sp_whoisactive can send it's results to a table.

a simple example:

CREATE TABLE [master].[dbo].[MonitoredActivity] (

[dd hh:mm:ss.mss] ...

yes. you can create a credential with windows credentials, and then a proxy in SQL agent.

with that in place, you can modify the job step that calls the SSIS package...

if these were medical diagnosis codes, i know diagnosis codes vary between three and eight characters in length;

here's a couple examples

463

W45.8XXA

so i think using a delimitedsplit is...