I have to agree with Cadavre here.

It's not just the performance in this case, rCTE's are expensive and shouldn't be used unless they're doing far more work than simply...

The recursive CTE is used for generating rows - and it's a massively expensive way to do this. In 2K8 or higher, row constructors would be much cheaper

VALUES((1),(2),...)

In 2k5,...

Jeff Moden (2/13/2012)

---

ChrisM@home (1/18/2012)

---

jennigirl (1/18/2012)

---

I was able to get the query results I need, but I am looking to now present the results as the total count of trouble tickets...

Cadavre (12/9/2011)

---

Agreed 100%. Generally I use cross-tab queries to pivot data, I showed the syntax for...

The method you are using - correlated subqueries - is similar in layout to a cross-tab, but check out the real thing for performance:

SELECT

ListingID,

Photo01 = MAX(CASE WHEN Priority =...

Divine Flame (12/9/2011)

---

lol :-D, No way . He has not mentioned that he is using SQL...

Can you confirm that you are using SQL Server 2000?

Have a quick read of the link "here" in my sig, it will help you frame your question for a better...

It was just small enough to fit :hehe:

You could use the OUTPUT clause:

DROP TABLE #MemberEnrolments

CREATE TABLE #MemberEnrolments (MemberID INT NOT NULL, EnrollmentID INT NOT NULL, enrolmentStartDate DATE NOT NULL, primaryflag BIT)

ALTER TABLE #MemberEnrolments --WITH NOCHECK

ADD CONSTRAINT...

mario.balatellii (12/8/2011)

---

yeah thats what i was thinking as well.. Thanks.

Or may be i will have sql job which will transfer the data into a table in a database. What...

Probably easiest if you run the results into a local temp table...

SELECT ... INTO #Temp FROM ...

-- change this

update TestA set TestA.Column5 = TestB.Column5

from TestA inner join TestB

on TestA.Column1 = TestB.Column1

and TestA.column2 = TestB.Column2

and TestA.Column3 = TestB.Column3

-- to this

SELECT <<primary key from table a>>, b.Column5

INTO #Temp

FROM...

Nice one, Jason!

You're welcome Mario. You will need to change the name...

Crosstab version:

SELECT

[Type]= MAX(CASE WHEN en.[Entity name] = 'Type' THEN Attribute END),

[Bank name]= MAX(CASE WHEN en.[Entity name] = 'Bank name' THEN Attribute END),

[Merchant code] = MAX(CASE WHEN en.[Entity...