Hi and welcome to the forums. It is nearly impossible for us to debug this for you but we can help guide you in figuring out the problem.

First, let's format...

Ahh gotcha....

jameslauf (8/20/2014)

---

Thanks again. this is what I changed it too and it seems to work.

with NumberedResults as

(

select ROW_NUMBER() over (Partition By actindx order by Calendar_Month) as RowNum

, *

from...

Something along these lines.

with NumberedResults as

(

select ROW_NUMBER() over (Partition By NATURALACCT order by Calendar_Month) as RowNum

, *

from TrialBalance

)

select n2.ACTIVITYDEBIT as StartingBalance, n1.*

from NumberedResults n1

left join NumberedResults n2 on n2.RowNum...

jameslauf (8/20/2014)

---

I know this is a rookie question, but how do I find out which column makes my Row number? I assume there is an internal SP or something that...

Create a cte that includes ROW_NUMBER. I don't know what column(s) make your order. Then you select from the cte, join to the cte on rownumber = rownumber + 1...

So everything is ok now or not? Do you still need help?

This is not...

bucknick (8/20/2014)

---

Exactly. The goal is to only see the databases they have access to but based on the readings, this is not an option unless you make the user...

Hi and welcome to the forums. I don't understand what you mean about putting your variables in a temp table. I don't see a temp table declared, nor is there...

bucknick (8/20/2014)

---

Is there a way to hide databases that users don't have access to? I read articles on denying the public role 'VIEW ANY DATABASE' and make the user...

cbrammer1219 (8/20/2014)

---

Is this possible, I am trying to execute a stored procedure depending on what parameter is selected, something like this????

Case

when field = 'value' then...

RantaSanta (8/20/2014)

---

I have requirement to facilitate end user to let them create customizable report ( choose the column the y want ) , order by which column , schedule for...

software

Ed Wagner (8/20/2014)

---

Sean Lange (8/20/2014)

---

Ed Wagner (8/20/2014)

---

Sean Lange (8/20/2014)

---

Are others having problems with SSC today? It seems that almost every topic has some bizarre html comment added to the title....