sql2k8 (2/19/2014)

---

Hi ,

I cannot post the output of this data. It is confidential. If you can share me the logic i will try and see if it is working.

I need...

What about making your identity column the primary key and creating a clustered index for ID1, ID2, ID3?

sql2k8 (2/19/2014)

---

Hi,

I am using SQL Server 2008 Enterprise edition 64 bit on Windows serer 2008 enterprise edition 64 bit.

The below query works fine. I am trying to rewrite the code...

Woohoo!! Congrats!!!

steve.barfield (2/19/2014)

---

Thanks for your answer Lowell - that is the conclusion we are coming to.

But are you able to point us at a manual entry explaining what you say.

We were...

vigneshkumart50 (2/19/2014)

---

Hi Sean,

It's not a running total. The business rule for PriorVersion is sum(PreviousYear), so that I get PriorVersion values. And variance should be done for (PreviousYear - PriorVersion).

Lee me...

NO. What...

Maybe you should just create your scripts with a more standard approach?

IF OBJECT_ID('usp_test','P') IS NOT NULL

drop PROCEDURE usp_test

GO

create PROCEDURE usp_test

AS

select 2 as row2

GO

Can you update to something useful?

What does that mean? In your sample output your PriorVersion columns all equal PreviousYear_Profit now.

This will produce...

vigneshkumart50 (2/19/2014)

---

Hi,

You are correct. I disclosed some dummy raw data to show the expected output.

But this is the one that should be happening there.

PriorVersion will be like sum(PreviousYear)

Variance will...

OCTom (2/19/2014)

---

Sean Lange (2/18/2014)

---

OCTom (2/18/2014)

---

The following was in 1991 and in response to the question, "How many seminars or classes have you attended to keep up on technology?"

Answer: "I'm not...

What is the error message? Why are you using dynamic sql to create stored procs?

vigneshkumart50 (2/19/2014)

---

Hi,

This is my table structure

create table calculate(

ID int identity (1,1),

PreviousYear_Profit float not null,

)

insert into calculate values (12500)

insert into calculate values (22700)

insert into calculate values (18500)

insert into calculate values...

OCTom (2/18/2014)

---

The following was in 1991 and in response to the question, "How many seminars or classes have you attended to keep up on technology?"

Answer: "I'm not really into continuing...

Thanks Dwain. You were right in what you thought I was going for. Seems that this issue is in good hands now.