Insights of a Full Stack dev

Sunday, 24 January 2016

SQL pivot without aggregration

Pivot data to return the first two country entries for each person.

on January 24, 2016 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Pivot, SQL
Newer Posts Older Posts Home
View mobile version
Subscribe to: Comments (Atom)

About Me

Steven Hollidge
View my complete profile

Blog Archive

  • ►  2025 (2)
    • ►  March (2)
  • ►  2023 (1)
    • ►  December (1)
  • ►  2021 (2)
    • ►  October (2)
  • ►  2020 (1)
    • ►  August (1)
  • ►  2019 (2)
    • ►  October (1)
    • ►  May (1)
  • ►  2018 (1)
    • ►  June (1)
  • ►  2017 (15)
    • ►  April (4)
    • ►  March (11)
  • ▼  2016 (13)
    • ►  July (1)
    • ►  June (2)
    • ►  May (2)
    • ►  April (4)
    • ►  March (2)
    • ►  February (1)
    • ▼  January (1)
      • SQL pivot without aggregration
  • ►  2015 (6)
    • ►  May (5)
    • ►  February (1)
  • ►  2014 (62)
    • ►  November (18)
    • ►  October (16)
    • ►  September (1)
    • ►  July (3)
    • ►  June (14)
    • ►  May (9)
    • ►  April (1)
  • ►  2013 (62)
    • ►  December (1)
    • ►  November (10)
    • ►  October (7)
    • ►  September (2)
    • ►  August (2)
    • ►  July (5)
    • ►  June (2)
    • ►  May (4)
    • ►  April (4)
    • ►  March (13)
    • ►  February (10)
    • ►  January (2)
  • ►  2012 (121)
    • ►  December (3)
    • ►  November (20)
    • ►  October (6)
    • ►  September (3)
    • ►  August (3)
    • ►  July (2)
    • ►  June (17)
    • ►  May (15)
    • ►  April (31)
    • ►  March (12)
    • ►  February (6)
    • ►  January (3)
  • ►  2011 (102)
    • ►  December (3)
    • ►  November (2)
    • ►  October (18)
    • ►  September (7)
    • ►  August (9)
    • ►  July (7)
    • ►  June (24)
    • ►  May (18)
    • ►  April (5)
    • ►  March (9)

Labels

  • .NET4.5
  • 0MQ
  • accordion
  • Acer
  • Acrobat Reader
  • ActualSizeProxy
  • Adobe
  • Adorner
  • Adplus
  • Agile
  • AgileZen
  • AgOpenXml
  • Android
  • Angular
  • Angular-Animate
  • angular-cli
  • Angular-Wizard
  • Animation
  • AOP
  • api
  • App Bar
  • app server
  • Apple
  • Application Library Caching
  • application server
  • Application.Data.Current.TemporaryFolder
  • appveyor
  • Architecture
  • Aspire
  • async
  • AttachedProperty
  • Auth0
  • automapper
  • AutoResetEvent
  • await
  • Azure
  • Backface
  • badges
  • bcl
  • BDD
  • Behavior
  • beta
  • bindings
  • Blade
  • Blend
  • BookSleeve
  • bootstrap
  • breadcrumbs
  • brush
  • bug
  • BuildEvent
  • Burrow.NET
  • C#
  • Callbacks
  • captcha
  • certificates
  • Charms
  • charts
  • Chrome
  • Claims based
  • clean.bat
  • ClickOnce
  • Clip
  • Closure
  • cloud
  • CME
  • Code Contracts
  • CodeGen
  • COM
  • Comet
  • Components
  • Concurrency
  • conferences
  • Context Menu
  • Continuous Testing
  • contrast
  • Controls
  • Converter
  • cors
  • counter
  • Cryptography
  • Crystal Reports
  • CSS
  • CSS3
  • CUDA CUDAfy C# High Performance GPU CPU TPL
  • Custom Control
  • CustomMarkupExtension
  • DAL
  • Dapper
  • dashboard
  • data
  • Data Access
  • Data Protection API
  • Data Repository Pattern
  • DataAnnotations
  • DataBinding
  • DataContextProxy
  • DataContractSerializer
  • DataFlow
  • DataGrid
  • DataTemplates
  • DateTime
  • Debugging
  • Deep Zoom
  • defaults
  • Delay
  • DependencyProperty
  • Deployment
  • DescriptionViewer
  • Design
  • DetectStale
  • Diagnostics
  • directive
  • Dispose
  • double dispatch
  • dropdownlist
  • Dump
  • Dynamic
  • Dynamic Data
  • Dynamic Form
  • Dynamic Layout
  • DynamicUI
  • Enum
  • EqualityComparer
  • eslint
  • EventAggregator
  • Events
  • EventSource
  • EventTriggers
  • Excel
  • Exception
  • Explosions
  • express
  • expression
  • Expression Design
  • Extension
  • ExtractPropertyName
  • facebook
  • factories
  • Fade
  • Fiddler
  • File Streaming
  • Filter
  • Fluent Assertions
  • Fluid Move
  • FluidListBox
  • fonts
  • fount
  • Framework
  • Func
  • GarbageCollector
  • GC
  • Gibraltar
  • github
  • Google
  • GPT Partition style
  • graphs
  • Grasshopper
  • GridView
  • GridViewCheckBoxColumn
  • GUI
  • Header Template
  • Heatmap
  • Helper
  • High Frequency
  • HighCharts
  • highlight
  • HowTo
  • HTML
  • html5
  • HTMLViewer
  • HTTP
  • httpclient
  • HttpHandler
  • HttpListener
  • HTTPS
  • IComparable
  • IComparer
  • Icons
  • ICustomTypeProvider
  • IDisposable
  • IEditableObject
  • IEnumerable
  • IEquatable
  • ImageButton
  • Images
  • IndexedDB
  • inheritence
  • INotifyDataErrorInfo
  • INotifyPropertyChanged
  • INPC
  • instagram
  • IntelliTrace
  • Interceptor
  • interface
  • Interop
  • intro.js
  • iOS
  • IQueryable
  • IronPython
  • Isolated Storage
  • ItemsContainer
  • ItemsLoaded
  • ItemTemplate
  • ItineraryHunter
  • jasmine
  • JavaScript
  • jQuery
  • Json
  • Jsonp
  • Jupiter
  • Karma
  • KendoUI
  • Kerberos
  • keyframes
  • Kinect
  • Knockout.JS
  • KONA
  • Leading the user
  • LeanUX
  • LINQ
  • Linux
  • ListBox
  • ListView
  • Live Writer
  • LoadingStatus
  • localstorage
  • Lock
  • lodash
  • logging
  • MailChimp
  • ManualResetEvent
  • maps fonts
  • Markup Extension
  • Material design
  • MBUnit
  • media queries
  • MediaTypeFormatter
  • MEF
  • Memcached
  • Memory
  • Menu
  • messaging
  • Messenger
  • Metaprogramming
  • Metro
  • mobile
  • Mocking Framework
  • ModernUI
  • MongoDb
  • Mongoose
  • Monitor
  • moq
  • MouseMove
  • mq
  • MSMQ
  • MSpec
  • MSTest
  • multiple isolated wcf
  • Multithreaded
  • MVC
  • MVVM
  • MVVMLight
  • navigation
  • NCrunch
  • ng
  • ng-repeat
  • ngAnimate
  • ngMessage
  • Ninject
  • node
  • NoSql
  • Notifications
  • npm
  • NServiceBus
  • NUI
  • NUnit
  • ObjectPool
  • Observable
  • OCX
  • OOB
  • Ookii
  • OpenFileDialog
  • option
  • ORM
  • OverlapStackPanel
  • parallel
  • Path
  • patterns
  • PDF
  • performance
  • PetaPoco
  • PhantomJS
  • Pivot
  • PivotViewer
  • Polymer
  • Popup
  • PostSharp
  • Powershell
  • Predicate
  • Presentation
  • Printing
  • PRISM
  • Profiler
  • project
  • promises
  • PropertyChangedBase
  • PropertyListener
  • ProtectData
  • protobuf
  • prototype
  • Protractor
  • providers
  • pub/sub
  • Python
  • QuickGraph
  • QUnit
  • RabbitMQ
  • raddatepicker
  • RavenDb
  • react.js
  • reactive extensions
  • Reactive Trader
  • Redis
  • reflection
  • RelayCommand
  • Reports
  • Repository Pattern
  • request
  • required
  • Resolve
  • Resources
  • Responsive design
  • REST
  • revocable
  • ribbon
  • RichTextBlock
  • Rijndael
  • router
  • Routing
  • RSS
  • RUFUS
  • rx
  • S7
  • SCRUM
  • SDK
  • Security
  • select
  • selector
  • Semantic
  • Serialization
  • server
  • service hosting
  • ServiceLocator
  • services
  • ServiceStack
  • setInterval
  • Silverlight
  • Silverlight Glimpse
  • simple
  • Single usage
  • Singleton
  • Sinon
  • Sleep
  • Slider
  • sneak peak
  • Sort
  • SOS
  • SOSEX
  • SpecFlow
  • Splash
  • Splash Screen
  • SQL
  • SQLAzure
  • SSE
  • SSL
  • SSRS
  • STATLight
  • Stopwatch
  • StoryQ
  • Stream
  • Style
  • SVN
  • SyncFusion
  • Syntax
  • T4
  • TabControl
  • table
  • Tasks
  • TDD
  • TeamCity
  • Telerik
  • Template
  • TemplateSelector
  • TestContext
  • Tests
  • Text
  • Themes
  • Threading
  • threadpool
  • Tiles
  • TimeLine
  • timer
  • ToggleButton
  • ToggleSwitch
  • Tool
  • Toolkit
  • Tooltip
  • TortoiseSVN
  • TPL
  • transclude
  • transform
  • Transitions
  • travis-ci.org
  • treeview
  • triggers
  • troubleshooting
  • TRX2HTML
  • TryFindResource
  • TSQL
  • TypeScript
  • Ubuntu
  • UI
  • UIMessage
  • UnitTesting
  • USB
  • UserControl
  • utilities
  • UX
  • UX Hacks
  • validation
  • ValueConverter
  • ViewModel
  • virgin
  • visitor pattern
  • Visual Studio
  • VisualStateHelper
  • VisualStateManager
  • VSCode
  • VSM
  • wallaby
  • Wcf
  • WCFRIA
  • WcfWebApi
  • WCFWebAPITestClient
  • WeakEventHandler
  • WeakEventReference
  • WeakReference
  • web
  • Web Server
  • Web Services
  • Web Worker
  • WebApi
  • WebRequest
  • WebResponse
  • webstorm
  • Where
  • Win8
  • Windbg
  • Windows
  • Windows 8.1
  • Windows service
  • Windows Store App
  • Windows to Go
  • Windows10
  • windows8
  • WinRT
  • Wizard
  • Word
  • WP7
  • WPF
  • wrapbox
  • Xaml
  • XBOX360
  • XboxOne
  • Xml
  • XSLT
  • XSS
  • xUnit
  • yosemite
  • ZeroMq
  • Zune

Report Abuse

Twitter

Tweets by @stevenhollidge

Search this blog

Search This Blog

Pages

  • Home

Best free Ableton Live free downloads

Popular Posts

  • RX Frequency Cheat Sheet
    Ok, so you’re down with observables and you get the use of where and select statements to restrict and project your observables/events.  Now...
  • How to host multiple isolated WCF services within a single Windows service with zero App.config
    CodeProject Note: The code featured in this blog posting was put together whilst working with David Marsh on the Tranquility.Net (Wcf App ...
  • React.js Concepts
    Overview React.js is used to create components in your views, it specifically renders UI and responds to events. Instagram and Facebook ha...
Awesome Inc. theme. Powered by Blogger.