using pivot in sql how to split rows as main subject and sub subject of the main subject in single column -


enter image description here

now getting main subject 1 column , sub-subject column want combine 2 in single column

enter image description here


Comments

Post a Comment

Popular posts from this blog

javascript - How to bind ViewModel Store to View? -

i'm pretty new ext js , trying embed multiselect inside panel . the viewmodel has stores property can see here: ext.define('test.view.controls.search.searchfiltermodel', { extend: 'ext.app.viewmodel', alias: 'viewmodel.filter', data: { title: '' }, stores: { test: { fields: [ 'id', 'name' ], proxy: { type: 'ajax', url: 'api/test', reader: 'array' }, autoload: true } } }); i bind in view this: viewmodel: { type: 'filter' }, layout: 'fit', border: 1, plain: true, scrollable: 'y', layout: 'fit', bind: { title: '{title}', }, items: { xtype: 'multiselect', scrollable: false, allowblank: true, ddreorder: true, bind: { store: '{test}' }, valuefield: 'id', displayfield: 'name' } ...
Read more

dll - AutoIt (AutoItX) on C# Windows 7 App System.DllNotFoundException -

i have c# application uses autoitx automation. application works fine in windows 8.1 x64 environment compiled microsoft visual studio 2013 release 3. i pushed copy of app code bitbucket repository , cloned computer running windows 7 x64. autoitx version 3.14.2 installed , 32bit calls selected. application compiled using visual studio 2013 release 4 . the app compiled fine, first use of autoit functions resulted in error: an unhandled exception of type 'system.dllnotfoundexception' occurred in autoitx3.assembly.dll i tried following steps. app tested after each of these steps attempted register .dll manually using regsrv32 regsrv32 "c:\program files (x86)\autoit3\autoitx\autoitx3.dll" uninstalled visualstudio 2013 r4 , attempted reinstall visualstudio 2013 r3 {the installation of r3 failed because required internet explorer version 10 , version 11 has been installed on computer} r4 reinstalled uninstalled autoit , reinstalled selecting 64 bit li...
Read more

python - Alternative to referencing variable before assignment -

import time # define variables username = "username" password = "password" customer_info_file_path = "c:\\users\megam\pycharmprojects\general stuff\the square pie co\customer " \ "information\{}.txt ".format(name) username_entry = input("enter username\n>>") password_entry = input("enter password\n>>") if username_entry != username or password_entry != password: print("access denied\nyou have entered username or password incorrectly. please check password , " "account name , try again.\n") else: print("access granted") choice_menu = input("\na) view list of customers\nb) add customer\nc) delete customer\nd) log out\n>>") if choice_menu == "a": customer_info = open(customer_info_file_path, 'a', ) file = open(customer_info_file_path, 'r') output = file.read() ...
Read more