jimtimber (2/29/2016)

---

In the original post it sounded like things were being rounded down in the change over to TIME, not up, when compared to the original DATETIME value which does...

The reason you can't pass individual parameter values is that the function is accepting a table, not individual values.

TheFault (2/29/2016)

---

I'm going to disagree with the general view here. How are people to get real world experience in the workplace without being allowed to have a go and learn...

ThomasRushton (2/29/2016)

---

djj (2/29/2016)

---

Ed Wagner (2/28/2016)

---

HappyGeek (2/27/2016)

---

Revenant (2/27/2016)

---

Ed Wagner (2/27/2016)

---

DonlSimpson (2/26/2016)

---

Ed Wagner (2/26/2016)

---

ThomasRushton (2/26/2016)

---

Revenant (2/26/2016)

---

Ed Wagner (2/26/2016)

---

Ed Wagner (2/26/2016)

---

djj (2/26/2016)

---

HappyGeek (2/26/2016)

---

Ray K (2/26/2016)

---

crookj (2/26/2016)

---

Ed Wagner (2/26/2016)

---

Luis Cazares (2/26/2016)

---

Grumpy DBA (2/26/2016)

---

ThomasRushton (2/26/2016)

---

djj...

Ed Wagner (2/29/2016)

---

gary1 (2/28/2016)

---

Hi Jeff and Ed,

I was able to get procedure name and its code (line 39). But my question is:

1. how to find what was running in SSMS...

gary1 (2/28/2016)

---

Hi Jeff and Ed,

I was able to get procedure name and its code (line 39). But my question is:

1. how to find what was running in SSMS using the...

Nice editorial, Phil. You're certainly right in that a good IDE makes life easier. It helps people perform better investigation and make better decisions. Of course, it...

Screaming

What Jeff posted twice now is exactly how to find your procedure.

SELECT name FROM sys.databases where database_id = 10;

Then, in your database (id = 10):

SELECT name FROM sys.objects WHERE object_id...

Hugo's approach of adding 500 ms and then truncating will most certainly work to round the datetime to the nearest second. However, ask yourself what the purpose is behind...

Well, until this thread, I'd never considered racing my NumbersOnly ITVF against the new TRY_CONVERT function. We're just migrating one instance to SQL 2012 and it had never occurred...

Jeff Moden (2/26/2016)

---

Shifting gears to the script you found... if it doesn't have a section for rebuilding stats, your job of finding a script isn't done yet. Most folks...

Chef

Sean Lange (2/26/2016)

---

Alan.B (2/26/2016)

---

Sean Lange (2/26/2016)

---

Lynn Pettis (2/26/2016)

---

Alan.B (2/26/2016)

---

Lynn Pettis (2/26/2016)

---

I know this should go elsewhere but I feel that I'll get more responses here.

Why do organizations believe that they...

sharonsql2013 (2/26/2016)

---

I have this Varchar datatype column which has numbers and NA.

Whenever I try to filter out any value the NA comes along with it.

How can I take care of...