Luis Cazares (8/19/2013)

---

As you're using SQL Server 2012, why won't you use TRY_CONVERT with a string Splitter[/url]?

WITH CTE AS(

SELECT TRY_CONVERT( DATETIME, Item) AS MyDate

FROM #temp t

CROSS APPLY dbo.DelimitedSplit8K( MyValues, '...

Ville-Pekka Vahteala (8/19/2013)

---

wolfkillj (8/19/2013)

---

Stefan Krzywicki (8/19/2013)

---

Sean Lange (8/19/2013)

---

Stefan Krzywicki (8/19/2013)

---

The Dixie Flatline (8/19/2013)

---

Just looking in a minute, while stopping to grab a donut. I feel compelled...

Thomas Abraham (8/19/2013)

---

phickey (8/19/2013)

---

I usually start with technical support for a complaint, in hopes that something can be done to fix the software. If this doesn't work, I move next...

WayneS (8/19/2013)

---

Jeff Moden (8/16/2013)

---

Grant Fritchey (8/16/2013)

---

Paul White (8/15/2013)

---

Jeff Moden (8/15/2013)

---

While I've found some workarounds for it, it seems bloody incredible to me that you cannot rebuild a partitioned index at...

Design fix

I agree completely with Jeff's observation about the "fine print" rule. Unfortunately, software today is governed by the fine print, exclusions, excuses, legal technicalities, disclaimers of suitability of fitness...

I would advise against trying to use data while it's in Excel. Import the list you want to process (I like BULK INSERT, but SSIS or other methods will...

Why are you breaking this into batches in the first place? Why not just do something like this?

INSERT INTO TableB(id, etc)

SELECT id, etc

FROM...

You'll want to write your procedure and build your result sets using whatever queries are necessary. Then, simply execute the two select statements at the end. You will...

jasona.work (8/16/2013)

---

SQLRNNR (8/15/2013)

---

jasona.work (8/14/2013)

---

Ed Wagner (8/14/2013)

---

Sean Lange (8/13/2013)

---

Ed Wagner (8/13/2013)

---

Congratulations on getting the car. I agree that a picture would be nice...hold the Speedo, please. Be sure to...

Ham sandwich

Hi and welcome to the SSC forums.

If you want to include a description of a group for a code in your table, you'll need to join to the table that...

Gail, Jeff and Steve are all above 30,000 and all are listed as SSChampion. Koen just got his 10,000-th this past week.

If the list from the forum really are...

jasona.work (8/15/2013)

---

Oh the unfettered joy and terror of that "oh sh1t" moment...

The one when you realize / find out that the DB you just restored into production from QA was...

Attack