Viewing 15 posts - 1 through 15 (of 92 total)
drew.allen (5/20/2016)
;
WITH E(n) AS(
...
May 20, 2016 at 3:42 pm
Ok, I figured it out. It just took me a second to retrace the logic path the way it should be.
Here is the completed project. This includes the second phase...
May 19, 2016 at 5:12 pm
The DBAs just sent out an email alerting us to a corruption in today's refresh (reporting database is 1 day behind production transactional database). They completed repairs and I am...
November 16, 2015 at 2:16 pm
CREATE SYNONYM [c_prd].[TCAS_HISTORY] FOR [DatabaseNameNotGiven].[dbo].[TCAS_HISTORY]
This synonym is found in the same database listed for the DatabaseNameNotGiven value. I had SQL Server itself generate the code via right click > Script...
November 16, 2015 at 1:57 pm
Select TC.Cas_ID
From c_prd.TCASE TC
Inner Join c_prd.TCAS_HISTORY TCH
On TC.Cas_ID = TCH.Cas_ID
Where TCH.CaseCloseDate Is Null
Returns 9,816 records
Select TC.Cas_ID
From dbo.TCASE TC
Inner Join dbo.TCAS_HISTORY TCH
...
November 16, 2015 at 1:47 pm
Lynn Pettis (11/16/2015)
November 16, 2015 at 1:08 pm
djj (11/11/2015)
As an aside what if you change
TCC.Cntac_Dt >= Cast(Convert(Varchar,GetDate()-120,101) As DateTime)
to
TCC.Cntac_Dt >= Cast(DATEADD(DAY,-120, GetDate()) As Date)
Good call. I was just trying to take off the time, and...
November 11, 2015 at 9:14 am
Luis Cazares (11/11/2015)
jarid.lawson (11/10/2015)
I've never had a left join react like that for me.
Whenever using this syntax it will happen. You might have been very lucky for not encountering this...
November 11, 2015 at 9:12 am
SoHelpMeCodd (11/11/2015)
An old article (one that I cut my teeth on :-D), but check out INF: How to Restrict the Inner Table of an ANSI Outer Join
Thank you. That was...
November 11, 2015 at 9:11 am
Ding, ding, ding, ding, ding...We Have A Winner!
The Where TCC.Cntac_Dt >= Cast(Convert(Varchar,GetDate()-120,101) As DateTime) clause is changing the LEFT JOIN into an INNER JOIN.
I usually code it like this:
Select TCH.Cas_ID
...
November 10, 2015 at 1:31 pm
SQLBill (11/10/2015)
November 10, 2015 at 1:13 pm
Alvin Ramard (11/10/2015)
What happens if you change:
Where TCC.Cntac_Dt >= Cast(Convert(Varchar,GetDate()-120,101) As DateTime)
to:
Where ((TCC.Cntac_Dt >= Cast(Convert(Varchar,GetDate()-120,101) As DateTime)( OR (TCC.Cntac_Dt IS NULL))
That leaves me at 423 still missing.
Am I...
November 10, 2015 at 1:09 pm
Crude back hacks don't bother me. I don't care how pretty it looks on the back end just as long as it does what I'm looking for.
I want to make...
October 21, 2015 at 10:02 am
I found the solution. In case you ever have to troubleshoot this for your system, here are the steps I used to correct my specific issue.
Root Cause: Invalid alias address...
October 3, 2014 at 2:02 pm
So that I am not leaving an unanswered question hanging out there...
Let me first state that I was an idiot for forgetting this. I have not played with Aliases in...
October 3, 2014 at 1:23 pm
Viewing 15 posts - 1 through 15 (of 92 total)