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
#1945602
There is no procedure in AdventureWorksDW2014 Can you please provide the script 🙂
December 26, 2016 at 12:50 pm
#1919640
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
#1917966
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
#1889601
When I want whole XML convert to tabular form I found OpenXML is easy and fast
😀
March 17, 2016 at 7:35 am
#1865855
Very good post !!!
March 5, 2015 at 4:08 am
#1781864