Luis Cazares (9/19/2014)

---

The row counts are normal, the normal run should be in under 20 minutes but sometimes it takes really long time to complete.

The column is not needed, but...

ohack (9/19/2014)

---

Hi,

Another SQL Server 2000 mystery, perhaps related to my last post (http://www.sqlservercentral.com/Forums/Topic1611514-5-1.aspx).

A stored procedure (the same one) disappears from syscacheobjects - usually before the usecounts counter reaches...

Hi Luis,

Are the row counts typical of this process?

Since the estimated plan shows clustered index scans of both tables, I'd first check to be sure you didn't lose a...

okbangas (9/19/2014)

---

I have some doubt on the correctness of this question. As you get the coordinates from a GPS system and your task is to store the coordinates (calculation of...

I think it's a shame. I always enjoyed Tori, Kari, and Grant's segments more than Adam...

DavidL (8/14/2014)

---

wolfkillj (8/14/2014)

Did you try using the code mickyT posted above to find the rows where the vppblong value contains some character other than the digits 0-9, decimal point (.),...

DavidL (8/13/2014)

---

This to me looks completely silly, but this is what I did to make it 'work'.

SELECT f.vpid#

,f.numlat As Latitude

,CONVERT(NUMERIC(12,8),f.[IntPart]) +

CONVERT(NUMERIC(12,8),f.[Mantissa]) AS Longitude

FROM

(

select vpid#, vppblat

, convert(numeric(12,8),vppblat) as numlat,...

jcrawf02 (8/13/2014)

---

rodjkidd (8/13/2014)

---

Ed Wagner (8/13/2014)

---

Thanks for all the well wishes, everyone. Things are starting to...

KoldCoffee (8/12/2014)

---

I want to pull in a specific value from a second dataset that returns just one row of data, but has 6 columns. I need the value...

Evil Kraig F (8/11/2014)

---

I would disagree. I think the better approach would be the OP's original idea, but slightly modified. If you use SELECT * FROM OPENQUERY( LinkedServer,...

v4vaas 19815 (8/11/2014)

---

Ok Thank you. Thing is, I need to use BULK INSERT for some performance tests...so, am thinking I can create a file (text or csv) with all the...

I think we would need more information about what the application is trying to do,...

Steve Jones - SSC Editor (7/16/2014)

---

GilaMonster (7/16/2014)

---

I would be, if he...

Koen Verbeeck (7/10/2014)

---

Jack Corbett (7/10/2014)

---

Koen Verbeeck (7/10/2014)

---

So I tried to endorse Jeff on LinkedIn for BCP, but somehow it doesn't work.

I saw Jeff was endorsed 9 times for...

wolfkillj (7/8/2014)

---

GilaMonster (7/8/2014)

---

🙁 EVE hasn't taken over my life. Not entirely anyway....