Why do you think you need to disable the clustered index?

robmcbarron (4/8/2014)

---

Thanks for your patience Sean, here goes..

I'm trying to calculate the difference between the start of the financial year (in this case 1st April 2013) and the savings start...

I would NEVER recommend passing in a character...

Everything Luis and Grant say plus...

There is lots of low hanging fruit here for performance improvement. Do you need UNION? A UNION ALL seems highly likely to be acceptable here...

patla4u (4/8/2014)

---

Hello,

I want to load data from Staging to Development environment.

In Dev. environment , I have index that is use for stored procedure and Staging environment, I don't...

Awfully sparse on details. Without some actual details it is pretty tough to guess.

I suspect the problem is because you are using an OR between your where predicates.

where...

Not sure what you are looking for as output. Using the values you stated and plugging them into your formula...

select (1168 - 1172) / 1172. * 100

This returns -0.341200

rummings (4/8/2014)

---

Hi Apple.... what I meant was..... I open a Stored procedure.... add a comment statement with text.... not changing any functional code.... execute the Stored Procedure.... it runs successfully.......

patrickmcginnis59 10839 (4/8/2014)

---

Very good point, how would you do it and still allow him to find...

This looks like a cookie cutter cross tab to me. Please see the articles in my signature about cross tabs. Also, here is a link to another thread where I...

Eirikur Eiriksson (4/8/2014)

---

hisakimatama (4/8/2014)

---

Aha, so it doesn't :-). I've always declared CTEs with the column declarations, and by the wonderful problems of habit, it stuck as "the" way to...

And then, encrypt those SSNs and stop storing them in plain text immediately!!!

You could make this even simpler by providing a default to HoursStarted.

create procedure GetSomeData

(

@HoursStarted int = 15

) as

Select [Columns]

from Production

where HourWorked > @HoursStated

So now if the user wants "All"...

Start by reading my response. Then telling us where this message is coming from.

Luis Cazares (4/8/2014)

---

I was working on a cross tabs solution but Sean beat me to do it.

I just wanted to point out that it should out perform the previous solutions...