Doing that with t-sql is likely to only be close at best. Have you tried using SQL Search?

Sure I do stuff like that all the time. Given the EAV-ish type of query you posted yesterday I suspect you will need to leverage this type of thing all...

SQListic (8/21/2013)

---

Hi Experts,

We had a application that enters logs into database approximately for every half an hour.

Lets say if the apllication started at 1:01 and ended its at job 1:05,...

Koen Verbeeck (8/21/2013)

---

Sean Lange (8/21/2013)

---

Koen Verbeeck (8/21/2013)

---

In the category of "Are the posted answers getting worse?"

http://www.sqlservercentral.com/Forums/Topic1485861-1063-1.aspx

From now on I shall answers questions in the following manner:

"I have no flipping clue....

Koen Verbeeck (8/21/2013)

---

In the category of "Are the posted answers getting worse?"

http://www.sqlservercentral.com/Forums/Topic1485861-1063-1.aspx

From now on I shall answers questions in the following manner:

"I have no flipping clue. Please post the solution...

Here is how I would do this in sql server. I have no idea if you can anything like this in DB2 or not.

;with myCTE as

(

select * , ROW_NUMBER() over(order...

Being that this a sql server site I don't...

When I see these things I am reminded the story here. https://www.simple-talk.com/opinion/opinion-pieces/bad-carma/%5B/url%5D

/me slinks back from the anti-design quietly...

This is a BIG can of worms here. There are some...

EAV FTW!!!!

ry.sqldev (8/21/2013)

---

CREATE TABLE "AAA"."ADD_PROCESS" (

...

Instead of posting excel documents that require us to import data and guess on datatypes can you instead post ddl (create table statements) and sample data (insert statements)? That way...

erikd (8/21/2013)

---

Hi,

A bit of a general question:

I have a query with 28 LEFT JOINS. 20 of them join one table to the original query in order to break information out...

No problem. Glad that worked for you.

Way more than you should ever...