john.acb (10/25/2010)

---

Hall of Fame, my example would be something like this:

SELECT

col1,

col2,

col3,

...

...

COUNT(CASE WHEN...

john.acb (10/25/2010)

---

Example:

Select

COUNT(col1) OVER(Partition By col1) as 'First' ,

COUNT(col1) OVER(Partition By col1) as 'Second' ,

COUNT(col1) OVER(Partition By col1) as 'Third',

...

gmrose (10/21/2010)

---

For timing, yesterday's script ran for over 23 hours and was less than 5% complete when I halted it. Today's script succussfully completed in less than 4 minutes....

Heh yeah and only 2 1/2 hours until beertime! 🙂

I love a good chili flavour. This stuff takes some beating. I made some a week ago using Rick Stein's recipe and...

Brandie, please can you share your recipe? Most recipes over here suck. The one I use is modified from a Texas chili-cooking competition and takes ages.

hallidayd (10/22/2010)

---

I hope you understand I am attempting to guide you towards better practice and am not trolling. After that you can take what I say on board or disregard.

The...

Rootfixxxxxxer, can you please confirm which SQL Server version you are using?

The code I posted is stage 1 - optimise the query.

The new columns names would be generated in stage...

Blimey Gianluca, first-rate stuff and quick too. I was going to start by offering some improvements to the original query, then finish up with a cross-tab.

DROP TABLE #PontoRegistos

CREATE TABLE #PontoRegistos...

Is there a question here?

Quite right too, your first draft was rubbish 😛

Nope, if the results are correct then it's not wrong. It may not be the fastest show in the...

ColdCoffee (10/21/2010)

---

Chris Morris-439714 (10/21/2010)

---

There's a trick for that...put them in then

REPLACE(',' +...

There's a trick for that...put them in then

REPLACE(',' + EmpName + ',',',,',',')

Why do you think the query should return only one row (or none) regardless of how many rows may or may not match the filter?

I'm not sure if this...