Actually it's OK. The records go into the table in the proper order so when I do a simple select without an "order by" clause, they come back in the...

Sean Lange (11/27/2012)

---

leesider (11/27/2012)

---

OK, as I said in my last post I need to extend it a little further to include a running total. Cadavre is correct, I don't need...

OK, as I said in my last post I need to extend it a little further to include a running total. Cadavre is correct, I don't need a cursor. ...

Sean Lange (11/26/2012)

---

You should look at datepart.

For example, 2012-04-03 is in the fifteenth week of the year so if that date appears then the week number 15 should appear...

Cadavre (11/26/2012)

---

No cursor required.

Try this:...

That's what I thought thanks 🙂

Silly me, I am able to work around it by right-clicking and selecting "Script Stored procedure as" and then "Alter to".

Don't know why modify is doing that but the above...

anthony.green (6/6/2012)

---

You need a full outer join.

declare @tab1 table (year int, week int, total_savings decimal(36,18))

declare @tab2 table (year int, week int, total_savings decimal(36,18))

insert into @tab1 (year, week, total_savings) values

(2012,...

My apologies, I didn't make myself clear. The above query...