marlon.seton (9/16/2013)

---

We write all our code in Oracle first, where PL/SQL is needed, then produce the tSQL version afterwards where that is different, so we'd never have this problem (and...

Steve Jones - SSC Editor (9/16/2013)

---

Get a space to hold some sessions. I bet if...

jasona.work (9/16/2013)

---

What happened? Nothing new in here all weekend, and it's not even any sort of a holiday anywhere (that I'm aware of at least...)

Just think everyone!

Only 101 more...

Jack Corbett (9/13/2013)

---

dwain.c (9/12/2013)

---

Jack Corbett (9/12/2013)

---

Brandie Tarvin (9/12/2013)

---

Ed,

Go to http://www.sqlsaturday.com and see if there is a way to register for event notifications. That way if one...

Jeff Moden (9/15/2013)

---

With the idea of "teaching a man to fish" in full swing, please see the following article.

http://www.sqlservercentral.com/articles/comma+separated+list/71700/

For future posts, please see the article at the first link in...

Yes, I'd say the idea of packing two separate attributes of your invoices into a single column could be considered "wrong." Is there a...

Sean Lange (9/13/2013)

---

Sure no problem. What you need to do is parse your string and then parse the results. Parsing strings in sql is the challenge here. Take a look...

When you reply to the post, look on the left at the IFCode Shortcuts. Use...

bitbucket-25253 (9/13/2013)

---

I suggest that you read this article by Jeff Moden

http://www.sqlservercentral.com/articles/T-SQL/71550/

For an excellent article including sample data and the code that will do what you seem to asking how...

Like hunchback, I'll start with Mr. Ben-Gan's interval packing approach but I believe the last part diverges from what he proposes:

WITH C1 AS (

...

Since Lynn is too busy serving his country in Afghanistan to come back here to help you out, I'll step in.

WITH SampleData (Projects, Customers, UpdatedBy, NewValue, UpdatedOn) AS (

SELECT 'Project...

ChrisM@Work (9/13/2013)

---

dwain.c (9/12/2013)

---

Jack Corbett (9/12/2013)

---

Brandie Tarvin (9/12/2013)

---

Ed,

Go to http://www.sqlsaturday.com and see if there is a way to register for event notifications. That way if one pops up near...

I didn't hear that much when I was out and about with my signboard.

I have it on good authority that...

Dehqon D. (9/11/2013)

---

Trying to copy one table to another in sql 2012, data type was set before me. Strangely, my end result have 10 times more money. I.e 27152555833.00 would...

I'm interested in hearing the answer to this so I can use it on my bank account.