I guess my previous answer was not enough?

Try looking at the error message.

@Portfolios or @PortfolioObjectID cannot both be null, one must be populated

@Portfolios or @PortfolioObjectID cannot both be null, one...

I gave you an answer in that thread.

This example works with your sample data.

;with Data(Name, DefaultValue, DayValue, Building) as

(

select 'MrA', 1, 'monday', 'A' union all

select 'MrA', 1, 'monday', 'A' union all

select 'MrA', 1, 'monday', 'A' union all

select...

Personally I would not store this total in your database. It makes updates and deletes way more difficult than they need to be. If you need this type of thing...

Or you might be able to use ROW_NUMBER() based on your brief sample data and the output.

yes

From our very own Jeff Moden...

Solving the Running Total and Ordinal Rank Problems[/url]

Lynn Pettis (4/25/2012)

---

Sean Lange (4/25/2012)

---

The problem is that xp_dirtree does not return data in a format that is going to help put this back together. It looks like you are...

Without some context of your dynamic sql it is shooting in the dark. Can you post some details about what you are trying? At least the code you are running.

I did find a post right on this site with some code that will list this exactly as I understand you are looking for.

http://www.sqlservercentral.com/Forums/Topic1104688-8-1.aspx

The problem is that xp_dirtree does not return data in a format that is going to help put this back together. It looks like you are trying to get a...

LOL that would certainly be a good candidate as a "feature" to remove in some version.

ROFL!!!! 😛

Figured I would dig a little and try to refresh my memory, it has been awhile since I had to deal with SSNs.

http://en.wikipedia.org/wiki/Social_Security_number

If you are just using this as random dates just update your table to change the 2/29 values to something else, or delete them. Then your previous update code will...