First, are you using SQL Server 2012 or SQL Server 2005? You have double posted in two different forums.

Second, please don't double post, it fragments answers you may get.

Third,...

First, you haven't detailed what exactly is wrong.

Second, what have you done to try and resolve the problem?

Third, how does the running total part of all this fit in or...

I have to agree with Sarah regarding SSC. Some amazing people (Jeff Moden for one) helped kick my learning of SQL Server in to high gear when I became...

SQLRNNR (6/30/2014)

---

David Burrows (6/30/2014)

---

Actually Lynn's solution looked...

Great. Now, be sure you take the time to work through the code and understand what it is doing since you have to support it. If you have...

How about giving this a shot. You may also be able to run this against all ID_Resource entities at once instead of one at a time.

I'd try it in...

Koen Verbeeck (6/29/2014)

---

Lynn Pettis (6/28/2014)

---

It is scary how people manage to get into working with databases and then expect others to bail them out when they are in over their...

Give this a shot:

declare @ProgamCodeIn nvarchar(10);

set @ProgamCodeIn = N'STORE2';

with baseitems as (

select

ipp.ItemID,

ipp.ProgramID,

p.Code,

rn = row_number()...

Jeff Moden (6/28/2014)

---

Lynn Pettis (6/28/2014)

---

Sana4u (6/28/2014)

---

HI

Is there a better way to write the following ?? Please view the below comments I have received in one of the stored procedure

Plenty wrong....

Last I knew, if you shutdown your server gracefully then the services shutdown gracefully as well.

It may have nothing to do with SQL but with how the VM is configured and/or built.

That is a really broad question. What are you looking at automating?

Okay, now using your sample data show us what the output should look like if the query runs correctly.

It is scary how people manage to get into working with databases and then expect others to bail them out when they are in over their head.

And the begging and...

Sana4u (6/28/2014)

---

HI

Is there a better way to write the following ?? Please view the below comments I have received in one of the stored procedure

Plenty wrong. For starters, this

where cast(convert(varchar(10),PostingDate,110)...