jarid.lawson (11/16/2015)

---

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

...

robert.sterbal 56890 (11/16/2015)

---

Gilamonster,

I think you have been trying too hard to teach someone without altering your approach if your response is that someone has asked a bad (as in ineffective)...

jarid.lawson (11/16/2015)

---

Lynn Pettis (11/16/2015)

---

What you don't say is if the database name in the synonym is the same database the view and tables are in or if it is a...

Ed Wagner (11/16/2015)

---

Lynn Pettis (11/16/2015)

---

And then you this type of question:

************(11/16/2015)

---

How can i round off decimal number. E.g if i have 7.9---i need to round it off to 8, ...

Maintaining your log file on the principle should maintain the log file on the mirror. If it isn't it sounds like something may be messed up.

jarid.lawson (11/16/2015)

---

I've never seen SQL behave this way before, so I need some help in pointing me where to look next.

A co-worker created a SQL script to help me learn...

And then you this type of question:

************(11/16/2015)

---

How can i round off decimal number. E.g if i have 7.9---i need to round it off to 8, if i have 7.4---i...

sqlinterset (11/16/2015)

---

How can i round off decimal number. E.g if i have 7.9---i need to round it off to 8, if i have 7.4---i need to round it off...

And the post she was talking about was the one...

robert.sterbal 56890 (11/16/2015)

---

One of the things that makes people turn away from a forum is when bed behavior isn't addressed.

I'd agree that a +1 shouldn't be the first thing in...

robert.sterbal 56890 (11/16/2015)

---

So I would recommend after the 2nd or 3rd question that seems lazy for the reply to be:

-------------------------------------------------------

You are asking a question that could be looked up easily...

Would some one else please take this one, I really don't think I should touch this one. Wouldn't be surprised if the OP didn't know the database was using...

Shouldn't that be 2/7?

vavfam 50321 (11/16/2015)

---

Here is the error I get. I also max out on errors and it fails at that point.

Bulk load data conversion error (type mismatch or invalid character...

Ed Wagner (11/16/2015)

---

Sean Lange (11/16/2015)

---

I didn't think it was that snippy. I wouldn't have given them the code...