Oksana March (5/26/2010)

---

Gianluca Sartori (5/25/2010)

---

Brain dumps are not allowed and violate the NDA. Don't look for the exact questions, try instead to take the chance of this exam to learn...

I suppose that the rank is based on the fact that the sequence on column "Data" continues without changes.

If this is correct, it can be done this way:

DECLARE @RankTest TABLE...

You can set up a filter on object_name or object_id. That should be enough.

You could start from the "tuning" template and script it out as server-side trace.

Hope this helps

Disappointment is somehow commensurated to expectations.

His signature sets a quite high expectiation.

I would change signature into "Absolute noob", so that every time he gets it right turns into a nice...

Ah, that's ok. I thought...

I can't understand why limiting posts here is so important.

Am I missing something?

Grant Fritchey (5/25/2010)

---

I haven't been posting here at the water cooler because, frankly, I was appalled at how many posts I had here. But I have to share this one...

SELECT *

FROM INFORMATION_SCHEMA.TABLES AS T

WHERE TABLE_TYPE = 'BASE TABLE'

AND EXISTS (

SELECT *

FROM INFORMATION_SCHEMA.COLUMNS AS C

WHERE C.TABLE_CATALOG = T.TABLE_CATALOG

AND C.TABLE_SCHEMA = T.TABLE_SCHEMA

AND C.TABLE_NAME = T.TABLE_NAME

AND COLUMNPROPERTY(

OBJECT_ID(QUOTENAME(C.TABLE_CATALOG) + '.' + QUOTENAME(C.TABLE_SCHEMA) +...

COLUMNPROPERTY(table_id, column_name, 'IsIdentity')

Brain dumps are not allowed and violate the NDA. Don't look for the exact questions, try instead to take the chance of this exam to learn as much as you...

Probably PRINT introduces less overhead.

If inside a loop, consider that SSMS can handle a limited number of resultsets.

I don't know if this is what you were asking, I hope this...

This should do the trick for you:

DECLARE @test-2 TABLE (

VK int,

PK int,

FK int,

Amt int

)

INSERT INTO @test-2

SELECT 3, 130, 129, 100 UNION ALL

SELECT 3, 130, 130, 100 UNION ALL

SELECT 3, 130,...

Nobody can give a sensible answer to this question, but you.

I could say "all the Euros you saved * 0.77", but I'm sure it won't help. 🙂

You have to...

This problem has been covered so many times that I'm surprised that Google doesn't give you a clue. Does it?

I'm sorry, but I can't understand why UNION ALL doesnt' fit your needs.

Can you post the desired output of your "merged" query please?