Viewing 15 posts - 1 through 15 (of 15 total)
Thanks - the problem lies within the sourceid will appear multiple times in both tables that are associated with the customerid , and need to devise a JOIN between the...
June 9, 2017 at 9:59 am
OK, thanks for all insights / advice, if I have more roadblock with this, i'll come back with more indepth questions/sample data.
Zo
May 26, 2017 at 4:15 pm
OK, thank you for this- if it can still exist as a derived column format (and the CTE can be recognized as a "column"), then yes, thats the desired format.
April 19, 2017 at 7:53 am
Thanks for your insights and help Luis.Here's what i really want to do is group all the customerids and add up the instances that these statuses occur, but here...
April 18, 2017 at 11:04 pm
Steve , I reassign aliases to the orders table reference in the subquery, and try this subquery, i get null for the Total summary (on the rollup), tried doing IsNull...
February 19, 2017 at 2:18 pm
Thanks Steve, let me see if this is on the right track, which it could be . Appreciate your insight.
Z
February 19, 2017 at 12:38 pm
OK thanks... again the problem lies with each unique customerID has to produce a result with the above formula, the output needs to be something similar to
CUSTID HOLDING
February 18, 2017 at 12:49 pm
TABLE dbo.events
(
EventID smallint NOT NULL,
Eventname nvarchar(100) not null,
Eventadded datetime NOT NULL,
EventScheduled datetime NULL,
EventDate datetime NULL,
Department varchar(50) NULL,
CONSTRAINT PK_EventID PRIMARY...
January 18, 2017 at 3:58 pm
Thanks for all help, will be testing, but this is headed in the right direction!
January 18, 2017 at 1:04 pm
January 17, 2017 at 6:45 pm
January 12, 2017 at 3:58 pm
Hypothetically the orderid would also be copied from orders table to vendororders table sometime after the process of the order history
HTH, thanks
January 11, 2017 at 7:07 pm
Thanks for the insights- i will have more of a detailed gameplan after re-testing the series of reports i have generated and could come back for more info.
Zo
January 1, 2017 at 12:36 pm
Viewing 15 posts - 1 through 15 (of 15 total)