webrunner (11/11/2015)

---

Hello experts,

Does anyone have advice about what training might be good for an accidental DBA? I have a good deal of hands-on experience at this point (~7 years)...

Whenever using this syntax it will happen. You might have been very lucky for not encountering this problem before....

Or try the alternative using cross tabs.

SELECT [Station_ID],

[Case_No],

[Date],

...

The [font="Courier New"]Where TCC.Cntac_Dt >= Cast(Convert(Varchar,GetDate()-120,101) As DateTime)[/font] clause is changing the LEFT JOIN into an INNER JOIN.

I usually code it like this:

Select TCH.Cas_ID

,TCCL.Cl_ID

From dbo.TCas_History TCH

Inner...

Grant Fritchey (11/10/2015)

---

Steve Jones - SSC Editor (11/10/2015)

---

jasona.work (11/10/2015)

---

Anyone feel like stopping by to help me paint some rooms in my house Thanksgiving weekend? There'll be left-over turkey and...

I received a notification for your post.

ScottPletcher (11/10/2015)

---

David Rich (11/9/2015)

---

While going through execution plan i observed this warning

Type conversion in expression (CONVERT_IMPLICIT(varchar(255),[e].[abc],0)) may affect "CardinalityEstimate" in query plan choice

and this is getting converted to nvarchar(255)....

From Books Online:

The full syntax of the SELECT statement is complex, but the main clauses can be summarized as:

[ WITH { [ XMLNAMESPACES ,] [ <common_table_expression> ] } ]

SELECT select_list...

I feel your pain.

I was in a similar dark place too, but came back to the light side of the force.

UNO!

yellow

It seems that the PostgreSQL server is closing the connection or limiting the resources. You might need to change some settings. I'm sorry that I can't help you with much...

If...

jasona.work (11/10/2015)

---

Anyone feel like stopping by to help me paint some rooms in my house Thanksgiving weekend? There'll be left-over turkey and I'll even spring for a case of...

Would changing the process to SSIS be an option?

That's exactly why you have it available.

I hope that's not the real password. 😉