Yes, absolutely... I saw your article Jeff.. My only question is if one account changes its parent...

It sounds like this structure is for a company that uses network marketing for its sales force. The problem here is that I'm not sure quite what you...

Steve,

Thanks for that but my question was different. Let me explain it much better.

I have an accounts table like below

DECLARE @Accounts TABLE

(

AccountID INT,

ParentAccountID INT,

ServerModifiedDate DATETIME

)

ParentAccountID Can keep changing due to...

sgmunson (6/24/2015)

---

I hope you're not using this data structure as the basis for accounting data. There is way too much other maintenance that would get very tricky after...

Yes actually. depending on the use case - building it using some form of "just in time" approach could be cleaner than storing and readjusting it all of the...

Matt Miller (#4) (6/24/2015)

---

well - I am not sure why you need to reload the entire table. The structure column can be built recursively, so pointing a given node...

is it something you want to present in the form of a query or just for research purposes? Can you not use Excel if it's a one time quick thing...

Out of the three options he had, I thought that would be okay to use.

I said that...

I don't think out of the three, datepart one wouldn't suffice your requirement. What if the expiry date is of a different month or year? but you are only considering...

Don't see anything wrong in the query unless there is an issue with my eyes expect that I don't see a FROM clause near the INSERT Command.

I believe you can write this query without using DYNAMIC SQL. but the only part that confuses me is @CID. You specified it as integer, and you are passing a...

Check this if the package fails for the second time in the loop :

I think you haven't specified the file to be picked by expression by using the value from...

when you use break points, use the watch windows to view variables at run time.. you don't have to print them to view them..

Is this what you are looking for? I didn't find any cube related information in your question, so I did this in straight SQL..

DECLARE @Input TABLE

(

pn VARCHAR(10),

prcode VARCHAR(10),

dos DATE,

Expected...

If you are looking to increment the number automatically whenever you insert a new record, try Identity(1,1) on that column, so that it gets automatically incremented.