I had a solution but it won't work on SQL 2000. Could you confirm the version you're working on?

Brandie Tarvin (1/22/2015)

---

rodjkidd (1/22/2015)

---

Steve Jones - SSC Editor (1/21/2015)

---

So....

What's the superhero costume of choice here? SQL Bits is a month+ away, with the theme of superheroes for the Friday night...

Hi,

You have several possibilites.

One way would be to use the filter available on object explorer in SSMS.

Another way would be to use Redgate's SQL Search (it's great).

Another one would be...

I just read the ROW_NUMBER restriction. Is this cheating?

SELECT IDENTITY(int, 1, 1) id, num1

INTO #A

FROM A;

SELECT IDENTITY(int, 1, 1) id, ltr

INTO #B

FROM B;

SELECT num1, ltr

FROM #A

FULL

JOIN #B ON...

And the safe way would be with 2 ROW_NUMBER() functions.

This is a relatively common question used to get a report with unrelated columns.

WITH cteA AS(

SELECT num1,...

This is interesting. I tried the code in my computer and it just hangs indefinitely. If I remove the CTE it runs immediately. If I use a subquery it runs...

I'm just guessing here, but you might need the APPLY operator.

Something like this:

SELECT tt.Name, tt.installed

FROM @PatchGroup pg

CROSS APPLY dbo.fn_PatchInfo ('Desktop', pg.patchgroup) pi

Brandie Tarvin (1/21/2015)

---

Sioban Krzywicki (1/21/2015)

---

Brandie Tarvin (1/21/2015)

---

Unfortunately my only...

Sioban Krzywicki (1/21/2015)

---

Jeff Moden (1/21/2015)

---

To be honest, I don't care if someone's eyes are on stems and they leave snail...

jwiseh (1/19/2015)

---

Luis Cazares (1/19/2015)

---

You should practice with those databases. Practice won't replace real experience. DBs are subject to change from one company to another (unless they use the same 3rd...

You should practice with those databases. Practice won't replace real experience. DBs are subject to change from one company to another (unless they use the same 3rd party app).

If you...

Not done if you have more than 100 databases.

You can use dynamic code to generate the statements.

DECLARE @sql varchar(MAX) ;

...

Note that there are some problems registered when using sp_MSForEachDB. Check the following article for an alternative: http://www.mssqltips.com/sqlservertip/2201/making-a-more-reliable-and-flexible-spmsforeachdb/

You could also build your own solution using a cursor and dynamic code.

As I said, using MAX() will help you with this problem. I hope that you can get rid of this EAV design which makes everything more complicated.

Here's an example of...