Viewing 6 posts - 1 through 6 (of 6 total)
A Type3 Dimension change can easily be achieved by doing following
Update [Department_Type3]Set [GroupName_current]='IT', EffectiveDate=Getdate(), [GroupName_Old]= [GroupName_current] 🙂
June 6, 2017 at 7:51 am
There is no procedure in AdventureWorksDW2014 Can you please provide the script 🙂
December 26, 2016 at 12:50 pm
Thanks so much Hugo, I've search for the same answer, only difference I want is to insert that tag in middle so use ' .. after(/planBean/intActionID)[1]'
Thanks again much appreciated...
December 14, 2016 at 11:12 am
Query 9 is returning 6 rows instead of one
/*(9)*/ SELECT DISTINCT(COUNT(1)) FROM #TmpCounts; -- 1 row
July 12, 2016 at 7:20 am
When I want whole XML convert to tabular form I found OpenXML is easy and fast
😀
March 17, 2016 at 7:35 am
Very good post !!!
March 5, 2015 at 4:08 am
Viewing 6 posts - 1 through 6 (of 6 total)