Take a look at the pivot command and see if that helps.

With the improvements in the QO, the implicit conversions are likely just being revealed to you now while they 2000 didn't care so much about it. I'd find a...

You are welcome.

Try this

WITH thisCTEisJustToProduceSampleData AS (

SELECT 'x' AS ex_prdname, 10 AS price

UNION

SELECT 'y', 20

UNION

SELECT 'z',30

)

SELECT TOP 2 *

FROM thisCTEisJustToProduceSampleData

ORDER BY price DESC;

hb21l6 (3/10/2014)

---

I see..

To create a heap, create a table without a clustered index. If a table already has a clustered index, drop the clustered index to return the table to...

Those are your heaps. You may want to investigate the creation of a clustered index on those tables.

what is the index id of these nameless indexes? I am betting it is an id of 0. But let's confirm for certain before jumping down any assumptions.

Try the script here.

http://jasonbrimhall.info/2011/11/17/table-space-revised-again/

trick

I'd call that one of those infinite nested loops operations.

At...

Ed Wagner (3/10/2014)

---

SQLRNNR (3/10/2014)

---

GilaMonster (3/10/2014)

---

That's about what my commute is now,...

Sean Lange (3/10/2014)

---

koti.raavi (3/10/2014)

---

I can understand but i have got very less time..It would be really helpful if you can give some hints or tips..which makes the work done faster.Thank...

See my response on this other thread.

http://www.sqlservercentral.com/Forums/FindPost1549320.aspx

errrmmm

http://www.sqlservercentral.com/Forums/FindPost1549320.aspx :Whistling: :unsure:

koti.raavi (3/10/2014)

---

Please help me out and Please find attached image..thanks

The objective of this task is to create a report that will connect to the AdventureWorksDemo database on the “TESTPC” instance...