Viewing 15 posts - 16 through 30 (of 123 total)
Hmmm... MLM. If that's true, are you using a "uni-level" payout system?
Yes, absolutely... I saw your article Jeff.. My only question is if one account changes its parent...
June 25, 2015 at 9:36 pm
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...
June 25, 2015 at 12:15 pm
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...
June 25, 2015 at 11:52 am
sgmunson (6/24/2015)
June 25, 2015 at 10:58 am
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...
June 25, 2015 at 10:55 am
Matt Miller (#4) (6/24/2015)
June 24, 2015 at 3:58 pm
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...
June 24, 2015 at 12:50 pm
I wouldn't because it will render any index useless.
Out of the three options he had, I thought that would be okay to use.
Do you really need the approval?
I said that...
October 8, 2014 at 12:57 pm
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...
October 8, 2014 at 12:34 pm
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.
May 7, 2014 at 10:14 am
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...
May 7, 2014 at 9:59 am
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...
May 7, 2014 at 9:52 am
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..
May 5, 2014 at 11:09 am
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...
May 5, 2014 at 11:07 am
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.
May 5, 2014 at 9:35 am
Viewing 15 posts - 16 through 30 (of 123 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy