That eliminates anything we could have done with indexed views.

Can you add clustered indexes on the tables, or any indexes...

kyadav (11/21/2011)

---

Supposing that it is same, I have created plan guide and implemented it in database. User will come tomorrow test the report. I am not sure if takes any...

Is it always generated the same way or does it change depending on user input (columns list,...

Change the query to go in the tables only once rather than 1 gazillion times and you should be fine.

You can pivot the data like this.

SELECT SUM(CASE WHEN Date BETWEEN...

Ah ok, my first answer just from the header was how the heck can that possbily be a problem :-D.

Thanks for the feedback.

Jeff Moden (11/21/2011)

---

Ninja's_RGR'us (11/21/2011)

---

Jack Corbett (11/21/2011)

---

Ninja's_RGR'us (11/21/2011)

---

Jack Corbett (11/21/2011)

---

Hey, for those not on Twitter (why aren't you). My dad passed away early this morning. Not unexpected. I...

If you want to get dirty with this =>

SELECT id, sum() into #tmp

create clustered index on sum

declare @max-2 int

or use the cursor here to get the max value

select @max-2 =...

You already have 2 ways to go about it.

What have you tried?

Evil Kraig F (11/21/2011)

---

Remi: If you're not willing to lose the place to a condemnation you won't be able to get the legal firepower necessary to force the landlord to...

IE, this works, slow as hell =>

use master ;

;

WITH CTE ( object_id, summ )

AS (

...

I've always checked all 3 fields.

It gives me both the .txt document and a way to do a select to do more complexe filtering.

I'm not 100% sure of the "best"...

Happy to help!

bomborde (11/21/2011)

---

Ninja's_RGR'us (11/21/2011)

---

GilaMonster (11/21/2011)

---

But, since this is a kind of test (for a scholarship), you should really be doing this yourself, or will you share the prize with us if...

What's wrong with => replace (fieldname, '|3^VA', '|3^')

Srinivas MSBI (11/21/2011)

---

Please find the attached.

Query: Whenever StartDate is greater than EndDate, it should throw a warning says "StartDate should not greater than EndDate". Here Area, Country, ProductName, Segment...