Ed Wagner (12/13/2016)

---

John Mitchell-245523 (12/13/2016)

---

Why not? You're not changing any data if you cast as...

Okay so we try the brute force method and relax it from there:

SELECT ao.TherapyAdmin_ID, ao.VisitObservation_ID, 1 as RowVersionNumber

FROM (

SELECT t.TherapyAdmin_ID

FROM hcs.PatientOrder po

INNER JOIN...

Thanks. Can you run this please - and post up the plan?

SELECT TherapyAdmin_ID, VisitObservation_ID, 1 as RowVersionNumber

FROM hcs.AdminObservation ao

WHERE EXISTS (

SELECT 1

FROM hcs.PatientOrder po

INNER JOIN...

People are guessing. There are at least five requests for you to post up the...

spectra (12/13/2016)

---

I would like to upgrade this query a bit ...

CREATE TABLE #John (j datetime)

INSERT INTO #John VALUES ('2016-11-10 12:12:42.100')

SELECT j FROM #John

WHERE j BETWEEN '20161201' and '20161213'

If...

spectra (12/13/2016)

---

Tested .... but its not...

zouzou (12/13/2016)

---

Hello all,

The same query with a group by clause I try to run on SQL Server 2005 and on SQl Server 2014 but it seems that every time i...

-- Note1: CONVERT style 102 = yyyy.mm.dd

-- Note2: Use ISDATE with a character expression to determine if the expression can be converted to date.

-- isdate(convert(datetime won't work because the conversion...

Okay, that's more reasonable. Now, although your db is miniscule, this may be occurring - which is why I asked...

Matt.Altman (12/12/2016)

---

@thom-2. Thanks for cleaning up the code and making it readable. I changed the LEFT JOIN and the query is still running at 8 minutes. Should...

Then you shouldn't need this:

WHERE NOT EXISTS (SELECT 1 FROM Metrics WHERE week != DATEPART(wk, n.Timestamp) OR week...

Does the Metrics table have a clustered index? How are you removing rows, DELETE or TRUNCATE?

Or using CASE:

ALTER PROCEDURE [dbo].[Validate_User]

@Username NVARCHAR(20),

@Password NVARCHAR(80)

AS

BEGIN

SET NOCOUNT ON;

DECLARE @UserId INT, @EmailConfirmed BIT; -- is it a BIT...

John Mitchell-245523 (12/12/2016)

---

WHERE LEN(MyCol) > 10

AND (MyCol LIKE '_____[1-6]1%'

OR MyCol LIKE '_____[7-9]2%'

OR MyCol LIKE '_____[0]2%')

The digit 6 appears in both your "1" and "2" requirements, so I guessed where to...

Eirikur Eiriksson (12/9/2016)

---

ChrisM@Work (12/9/2016)

---

Brandie Tarvin (12/9/2016)

---

rodjkidd (12/9/2016)

---

ChrisM@Work (12/8/2016)

---

rodjkidd (12/7/2016)

---

Eirikur,

I'm about a 20 minute walk to the High Holborn Caffe 1882. Let me know if you still want to meet up...