Alan,

Nice work. I did get the impression that the original poster had indicated that the data isn't necessarily that consistent or conforming, so I don't know if it's...

Jeff Moden (12/5/2016)

---

Lynn Pettis (12/5/2016)

---

Jeff Moden (12/3/2016)

---

As you can see, the neat thing about nice simple answers is that they're...

Well, no surprise there, really... There's been a "scale" problem of one kind or...

One of the more challenging things about posting in a forum is that while you may remember every detail from the...

Lynn Pettis (12/2/2016)

---

Too much work. Looks like we are using SQL Server 2012 based on where this question is posted. The following will work on SQL Server 2008...

Just checking to see if you remembered to put the variable names you're using in your script into the appropriate READ ONLY or READ/WRITE variable list on the General tab...

Thank you, kind sir!

sac.nan (12/2/2016)

---

@sgmunson

Wow...Fantastic..This is exactly what I need...

I would show this solution to the management so they understand how tough the solution is and I am sure it would take ages...

Please note that the value -9999 for the default value to use when the LEAD value for the desired field IS NULL, has to NOT EXIST as a valid value...

sac.nan (12/2/2016)

---

John Mitchell-245523 (12/2/2016)

---

Yes, the answer was kind of "that's the requirement", which is fair enough, I suppose. I'd still love to know what this is for, though. ...

Bill Talada (11/28/2016)

---

You seem to have missed the poster's single problem he mentioned which is query timeout. All my suggestions answer that one problem. If a pre-select is...

halifaxdal (11/28/2016)

---

Y.B. (11/28/2016)

---

halifaxdal (11/25/2016)

---

Thank you very much.

3. Is it possible? Probably but I'm hesitant to give more solutions you won't be able to maintain. I'd recommend you get a...

mxy (12/1/2016)

---

i have below sample data, i try to extract valid credit card data. But i was not able to do so ,since data is not in good format. Can...

r5d4 (12/1/2016)

---

Hiya,

I'm on a site where SQL Developers have a functions database which only contains functions.

The functions are used via 3 part naming in code in other databases.

It is done...

urbanromio2 (12/1/2016)

---

group by clause cube function does it for column names.

but the requirement is on rows of column, so what i did, pivoted the table rows in to columns which...