Solomon Rutzky (3/21/2016)

---

spaghettidba (3/21/2016)

---

Jeff Moden (3/20/2016)

---

spaghettidba (3/17/2016)

---

I had the same issue in the past, both with VMs and my laptop, where I partitioned the disk a bit too aggressively...

What I...

Jeff Moden (3/20/2016)

---

spaghettidba (3/17/2016)

---

I had the same issue in the past, both with VMs and my laptop, where I partitioned the disk a bit too aggressively...

What I ended up doing...

Me too, but for some reason it didn't catch all the "bad"...

SELECT *

FROM @sampleData AS s

CROSS APPLY (

SELECT Name = (

SELECT SUBSTRING(s.name, number, 1) AS c

FROM master.dbo.spt_values

WHERE type = 'P'

AND number > 0

AND (

ASCII(SUBSTRING(s.name, number, 1)) BETWEEN 97 AND 122

OR

ASCII(SUBSTRING(s.name, number,...

This should do the trick:

DECLARE @sampleData TABLE (

Id int,

Name nvarchar(50)

)

INSERT INTO @sampleData VALUES

(1 ,'test“te d''abc')

,(2 ,'anr¤a')

,(3 ,' gs-re-C“te d''ab')

,(4 ,'M‚fe, DF')

,(5 ,'R™temd')

,(6 ...

I see no variable passed to the query for sp_send_dbmail. You're concatenating the value '22' to the query, which is the only way to execute queries with parameters in dbmail....

Why is the output wrong. What is the expected output?

Better?

SELECT ENC.PatientID,

ENC.DischargeDate,

ITV.InterventionDate,

Days = DATEDIFF(day, DischargeDate, InterventionDate)

FROM #Encounters AS ENC

OUTER APPLY (

SELECT TOP 1 *

FROM #Intervention AS ITV

WHERE PatientID = ENC.PatientID

AND InterventionDate <= DATEADD(day, 2, ENC.DischargeDate)

AND InterventionDate >...

This is one way to do it:

SELECT *

FROM #Encounters AS ENC

CROSS APPLY (

SELECT TOP 1 *

FROM #Intervention AS ITV

WHERE PatientID = ENC.PatientID

AND InterventionDate <= DATEADD(day, 2, ENC.DischargeDate)

AND InterventionDate > ENC.DischargeDate

ORDER...

Option1: SQL Power Doc

https://sqlpowerdoc.codeplex.com/

Option2: MAPS

https://technet.microsoft.com/en-us/solutionaccelerators/dd537572.aspx

Duplicate post, replies here please: http://www.sqlservercentral.com/Forums/FindPost1770164.aspx

jasona.work (3/16/2016)

---

Shoot me, please, just shoot me...

So, several (most) of my servers have silly-small C:\ drives for the OS. This hasn't been a problem until recently, now those drives...

Solomon Rutzky (3/14/2016)

---

Well, for reasons heretofore stated and unstated, whether expressly...

FWIW, I agree with Solomon here.

Basically, you have something like this:

SELECT a bunch of columns

FROM sys.databases AS DB -- This is the LOCAL list of databases

LEFT JOIN [Linkedservername]. msdb.dbo.backupset AS BS -- This...