sql server - Split Microsoft SQL Row -


assume have data so:

+------+------+------+------+ | col1 | col2 | col3 | col4 | +------+------+------+------+ |    | b    | x    | y    | +------+------+------+------+

i wish split after column achieve this:

+------+------+ | col1 | col2 | +------+------+ |    | b    | | x    | y    | +------+------+

what easiest way achieve this? forced in old ms access database connection sql server. thoughts?

use union all:

select col1, col2 t union select col3, col4 t;

both databases support union all. both take column names first subquery.


-

Comments

Post a Comment

Popular posts from this blog

php - Displaying JSON data posts for blog using just the post id -

i have page named 'posts_list.php' containing list of blog posts retrieved form json api have id, title, image etc . have link on page goes page called 'post.php' below: <a href="post.php?id=<?php echo $post->id ?> "> using method can retrieve 'id' of post clicked user using: <?php $postid = $_get['id']; ?> what want display json post on post.php corresponds id retrieved link on posts_list.php i know sql use clause, being new json im not sure if possible. need achieve php , json it has info /v1/blogs/@blog/@id @blog - blog identifier @id - blog post id
Read more

docusignapi - Documents restrictions within a package -

i have looked through docusign documentation, stackoverflow , google without success. when creating package, possible restrict signers able view pages of document ? let's borrower lisa smith should not allowed see pages 5 10 while second borrower can allowed see pages 1 5, possible within rest api ? thanks you can use docusign document visibility feature. if send document containing multiple files , want control files each recipient sees, can use document visibility accomplish this. common scenario want recipients see files need sign. document visibility, can create 1 document files intended individual recipients, rather having create separate document each recipient. using document visibility can set access @ document level. setting access @ page level not supported. see answer on how set documentvisibility using rest api. for more context, excludeddocuments property on page .
Read more

javascript - angular.forEach loop with $http.get -

i want create array containing objects firstly, first array server containing list of devices [ {accountid : "sysadmin",deviceid : "123"}, {accountid : "sysadmin",deviceid : "3"} ... ] then create second array containing objects each object represent device(deviceid) , contains array of events of device server i loop upon first array : $scope.myarrayofdevices = []; angular.foreach(response, function(device){ $scope.myobject={}; $scope.myobject.device = device.deviceid; $http.get('events') .success(function (data) { $scope.myobject.events = data; }); $scope.myarrayofdevices.push($scope.myobject); });//end loop i events data server correctly . but, when check $scope.myarrayofdevices array first object deviceid , no event array , second object deviceid , events array correctly like : [ {deviceid : 123, events:}, {deviceid : 3 , events : array...
Read more