sql server - t-sql procedure has no errors but need to be enhanced -


i have written procedure in t-sql returns errorcount based on state code,fiscal year etc..., has 3 pieces involved: 1. returns inner join of 2 tables pull selective columns 2. case statement multiple value possibility coloffset 3. function return errorcount.

when run code gives output 3 separate tables, but, intend errorcount output. how can accomplish this. oracle equivalent used cursor. need use here?

here's code:

alter procedure [hsip].[errorcount] (     @cregion char(2) ='00',     @cstate_code char(2) = '00',     @nfy numeric(4,0) = 0,     @nreport_id numeric(2,0) = 0,     @nsection_id numeric(2,0) = 0,     @nsubsection_id numeric(2,0) = 0,     @ndisplay_number numeric(38,0) = 0,     @nquestion_number numeric(38,0) = 0,     @nquestion_part_number numeric(38,0) = 0,     @suser_id varchar(25) =null,    @nfy_st_question_dtl_table_id numeric(38,0))   begin      set nocount on;  --declare nfy_st_question_dtl_table_id integer  --declare ncolumn_index cursor declare @coloffset integer --@temptbl numeric(38,0)   select qi.region, qi.state_code, qi.fy, qi.report_id, qi.section_id, qi.subsection_id, qi.display_number, qi.question_number, qd.question_part_number  fy_st_question_detail qd inner join fy_st_question_info qi on qd.fy_st_question_info_table_id =  qi.fy_st_question_info_table_id qi.region = @cregion          , qi.state_code = @cstate_code          , qi.fy = @nfy          , qi.report_id = @nreport_id          , qi.section_id = @nsection_id          , qi.subsection_id = @nsubsection_id          , qi.display_number = @ndisplay_number          , qi.question_number = @nquestion_number          , ( qi.reporter_id = @suser_id or                qi.delegate_id = @suser_id or                qi.sub_delegate_id = @suser_id )          , qd.question_part_number = @nquestion_part_number ;           set @coloffset=             case            when (@nreport_id = 1 , @nquestion_number = 21)  17             when (@nreport_id = 1 , @nquestion_number = 32)  16             when (@nreport_id = 3 , @nquestion_number = 11)  15             when (@nreport_id = 3 , @nquestion_number = 12)  27         end;       select [hsip].[geterrorcount](@nfy_st_question_dtl_table_id, 0, @coloffset)as errcount;      end

thanks,

comment out or delete select statements generate tables don't want in output.


-

Comments

Post a Comment

Popular posts from this blog

angular - Is it possible to get native element for formControl? -

i've got angular2 reactive form . created formcontrol s , assigned input fields by [formcontrol]=... . understand creates nativeelement <-> formcontrol link. my question: possible nativeelement formcontrol ? wanna myformcontrol.nativeelement.focus() i can share 1 terrible solution works me. in reactive forms can use either 1) formcontroldirective ts mycontrol = new formcontrol('') template <input type="text" [formcontrol]="mycontrol"> or 2) formcontrolname ts myform: formgroup; constructor(private fb: formbuilder) {} ngoninit() { this.myform = this.fb.group({ foo: '' }); } template <form [formgroup]="myform"> <input type="text" formcontrolname="foo"> </form> so these directives write patch like 1) formcontroldirective const originformcontrolngonchanges = formcontroldirective.prototype.ngonchanges; formcontroldirective.proto
Read more

unity3d - Rotate an object to face an opposite direction -

i have object , b. when click on object b, rotates object b (a faces b). b doesn't face a. need following : when faces b, need face opposite direction. have code rotating @ b. how rotate face opposite direction after that? vector3 targetdirection = target - transform.position; float step = speed * time.deltatime; vector3 newdirection = vector3.rotatetowards (turretdome.transform.forward, targetdirection, step, 0.0f); turretdome.transform.rotation = quaternion.lookrotation (newdirection); you object facing object b, want inverse direction of object after that? objecta.transform.rotation = quaternion.inverse(objecta.transform.rotation) but lets assume example turretdome object a, (negate direction): turretdome.transform.rotation = quaternion.lookrotation (-newdirection); naturally, both of these snippets not show how smoothen rotation, seem know how use time.deltatime. just incase unsure, quaternion.lerp this
Read more

javascript - Why jQuery Select box change event is now working? -

i working on product filters user select select box according his/her preference not getting selected value user in jquery. html code:- <select name="product_filter" id="product_filter"> <option value="price_low_first">price : low high</option> <option value="price_high_first">price : high low</option> <option value="latest">latest</option> <option value="popular">most popular</option> </select> jquery code: $(function () { $("#product_filter").change(function () { alert("hi") var selectedtext = $(this).find("option:selected").text(); var selectedvalue = $(this).val(); alert("selected text: " + selectedtext + " value: " + selectedvalue); }); }); hi believe code perfect. once please check jquery.min.js
Read more