Viewing 15 posts - 1,216 through 1,230 (of 4,087 total)
I would like to build a groups data...
February 22, 2018 at 9:51 am
It's not entirely clear what you are trying to accomplish, but I would restructure your tables. GroupMembers should be a link between groups and individuals ONLY. It should not contain...
February 21, 2018 at 2:03 pm
February 21, 2018 at 11:34 am
It looks like the following will work.
SELECT SUM([Net Loss]) OVER( PARTITION BY ADM_RISK_GRADING_ORG_UNIT_ID, ADM_EVENT_TYPE_ID, ADM_CAUSE_TYPE_ID ORDER BY [Effect Date YYYYMM] ROWS BETWEEN 12 PRECEDING AND 1...
February 20, 2018 at 3:08 pm
chef423 - Tuesday, February 20, 2018 2:02 PMDoes this help?
Invalid object name 'Permissions'.
Invalid object name 'Inventory_Exceptions'.
Invalid object name 'Inventory'.
You are also...
February 20, 2018 at 2:25 pm
February 19, 2018 at 12:29 pm
February 16, 2018 at 9:11 am
February 16, 2018 at 7:32 am
February 15, 2018 at 2:02 pm
February 15, 2018 at 12:40 pm
February 15, 2018 at 11:30 am
You're trying to do everything in one subquery. You need to break it out into multiple subqueries.
WITH XML_Names AS
(
SELECT DISTINCT Xml_name
FROM #temp
)
February 15, 2018 at 9:41 am
February 15, 2018 at 8:49 am
February 15, 2018 at 8:12 am
Viewing 15 posts - 1,216 through 1,230 (of 4,087 total)