题目内容
YouworkinDublinatthemainofficeofTestKing.com.YouareresponsibleformanagingaSQLServer2005database.ThesalesdepartmentwantsareportthatcomparescustomeractivityinthepreviousquarterbetweenthemainofficeinDublinandthebranchofficeinBuenosAires.Theywantthedatasortedbysurnameandfirstname.YourestorearecentbackupoftheBuenosAiresdatabaseontoyourserver.Youwritequeriestobuildthereport,orderingthedatabytheSurnameandFirstNamecolumns.YoureviewthedataandnoticethatthecustomerlistfromtheBuenosAiresdatabaseissorteddifferently.Thesalesdepartmentneedsthereviseddatawithin15minutesforapresentation.
Youneedtoimplementthefastestpossiblesolutionthatensuresthatthedatafrombothdatabasesissortedidentically.
Whatshouldyoudo?()
查看答案
搜索结果不匹配?点我反馈