pivot - error in my procedure while pivoting table -

-

i have following procedure

delimiter $$  create definer=`root`@`localhost` procedure `samp`() begin declare startdate date; declare enddate date;  set session group_concat_max_len = 3000000000;  select min(from_date) startdate requestor_employees emp_code=2145;  select max(to_date) enddate requestor_employees emp_code=2145; call fill_calendar(startdate,enddate); set @test =(select concat('select concat(em.fname,'',em.mname,'',em.lname) project_manager,pm.project_name,re.req_id,re.from_date,re.to_date requestor_employees re inner join requestor_master rm on re.req_id=rm.req_id inner join project_master pm on rm.project_auto_id=pm.project_auto_id inner join employee_master em on pm.pm_emp_code=em.emp_code re.emp_code=@id , re.flag in("na","ma","nd","md") group pm.project_name'));         set @result= (select distinct concat('select project_name,',group_concat(months),' (',@test,') `e`')from( select concat('select ',    year(datefield),' year  ,"" "jan"  ,"" "feb"  ,"" "mar"  ,"" "apr"  ,"" "may"  ,"" "jun"  ,"" "jul"  ,"" as"aug"  ,"" "sep"  ,"" "oct"  ,"" "nov"  ,"" "dec"') months calendar) d);     prepare stmt @result;     execute stmt;     deallocate prepare stmt;  end

i error in pivot table below:

call samp() error code: 1064. have error in sql syntax; check manual corresponds mysql server version right syntax use near 'select 2016 year ,"" "jan" ,"" "feb" ,"" "mar" ,"" "apr" ,""' @ line 1 1.030 sec don't know going wrong new procedure , pivoting.someone me solve this


Comments

Post a Comment

Popular posts from this blog

ios - MKAnnotationView layer is not of expected type: MKLayer -

-
Image
so code works fine logger riddled message. there way rid of or suppress it? postannotation.swift class postannotation: mkpointannotation { //mark: properties let post: post //mark: initialization init(post: post) { self.post = post super.init() self.coordinate = cllocationcoordinate2d(latitude: post.latitude, longitude: post.longitude) self.title = post.title self.subtitle = post.timestring() } } adding annotation let annotation = postannotation(post: post) self.map.addannotation(annotation) func mapview func mapview(_ mapview: mkmapview, viewfor annotation: mkannotation) -> mkannotationview? { if annotation mkuserlocation { return nil } var annotationview = mapview.dequeuereusableannotationview(withidentifier: "pin") as? mkpinannotationview if annotationview == nil { annotationview = mkpinannotationview(annotation: annotation, reuseidentifier: "pin")
Read more

ZeroMQ on Windows, with Qt Creator -

-
i have installed zmq link given below on windows 7. http://zeromq.org/distro:microsoft-windows 1) have c++ project in qt-creator , i'm using zmq c++ binding (zhelpers.hpp etc). 2) have added .lib installed zmq folder qtcreator 3) while compiling, compiler looks _imp__zmq_verion, in .dll files present in .lib have __imp_zmq_version. 4) causing undefined reference zmq_version. anyone else faced problem , has solution ?
Read more

unity3d - Unity SceneManager.LoadScene quits application -

-
i have 2 different scenes 1 named 'main' , other 'game' both added scenes in load. when use scenemanager.loadscene("game"); works no problem when tried return main scene code if (input.getkeydown (keycode.escape)) { scenemanager.loadscene("main"); } strangely game quits. thanks. sorry interruption. somewhere on other script found code. if (input.getkeydown (keycode.escape)) { application.quit (); } that's bad, know...
Read more