Thanks everyone. I prefer the indexed view option as that returns the best results I've seen yet, but it causes some issues for the developpers.

The nonclustered index Gail suggested...

washingtonen (12/14/2008)

---

wow Barry, thanks a million!!!! your help is highly appreciated. I will try it and get back to you. Now, how do I call a function from a...

GilaMonster (12/14/2008)

---

timothyawiseman (12/13/2008)

---

I also indexed the group by column before initially posting, and it definitely helps, but I was wondering if there was something that could specifically aid with counts,...

washingtonen (12/13/2008)

---

This is the original SQL

SELECT

case when failed = 'N' then

(select * from dim_concept)

else

(select * from vw_dim_concept)

end

FROM

flagsta

and those the errors when i execute...

Depending on exactly what you are trying to do you may want to look at one of two approaches:

You may wish to consider a table valued function instead of a...

Michael Earl (12/11/2008)

---

As an alternative, you could import the records into a staging table and use T-SQL to merge together the appropriate rows. Aggregating and concatenating strings like this...

Steve Jones - Editor (12/13/2008)

---

For a clustered index, the row count should be stored in a system table, so that should be quick.

For the first, if you had an index...

Joseph M. Steinbrunner (12/5/2008)

---

It is very interesting to note this is possible, however as others have mentioned, it has significant drawbacks. You must have Excel installed on the...

Jeff Moden (12/6/2008)

---

Actually, I'll take door #3 😛 ... performance is the same as WHERE EXISTS and it's even easier to read especially for newbies that may be on the...

Jeff Moden (12/6/2008)

---

I'm definitely...

While I know this is a matter of opinion, I found 1...

G Bryant McClellan (12/1/2008)

---

Jeff Moden (12/1/2008)

---

Good article... but, because of the title, I was actually expecting to see something about a problem or technique with CTE's that couldn't be done...

I completely agree with Gail. My job title is DBA, but I automated most of the...

For flexibility, I wanted to be able to use a wildcard such...

Douglas Osborne (12/3/2008)

---

Hey,

This didn't work for me until I added a % at the end of the first dynamic SQL statement:

SELECT @sql = CASE

WHEN @sql IS...