sql - Using a temp table to insert in stored procedure -


i have view trying declare temporary table in sql. i'm declaring it, getting error "must declare scalar variable @temp". i'm not sure why error occurring. below code stored procedure. end goal able use temp table's values on insert within stored procedure.

use [database]  go  set ansi_nulls off  go  set quoted_identifier off  go  alter procedure [dbo].[procinsertdrivetimeclaimcomponents]     declare @iterator int     declare @rowcount int     declare @temp table       (          rowiterator int,          intclaimnum int,          chrstscode  varchar(50),          chrcontnum  varchar(5),          chrcvgcode  varchar(5),          intcontcode int,          chrcontsfx  varchar(5),          chrdlrnum   varchar(5),          chrpgmcode  varchar(15),          chrversion  varchar(15),          chrcvgtype  varchar(15),          chrronum    varchar(15),          dtmrodate   datetime,          intchecknum int       );      set @iterator = 1     set @rowcount = (select count(*)                        viewdrivetimecontracts)      while ( @iterator <= @rowcount )       insert @temp                   (rowiterator,                    intclaimnum,                    chrstscode,                    chrcontnum,                    chrcvgcode,                    intcontcode,                    chrcontsfx,                    chrdlrnum,                    chrpgmcode,                    chrversion,                    chrcvgtype,                    chrronum,                    dtmrodate,                    intchecknum)       select *         viewdrivetimeclaimrows        rowiterator = @iterator    begin       insert tblclaimcomponents       values      ('cr',                    @temp.intclaimnum,                    '999999',                    'description',                    @temp.chrcvgcode,                    @temp.intcontcode,                    @temp.chrcontnum,                    @temp.chrcontsfx,                    @temp.chrdlrnum,                    @temp.chrpgmcode,                    @temp.chrversion,                    @temp.chrcvgtype,                    'complaint',                    @temp.chrronum,                    @temp.dtmrodate,                    'a',                    0,                    0,                    0,                    'n',                    0,                    0,                    0,                    1,                    'y',                    0,                    '',                    '',                    '',                    0,                    0,                    'n',                    'n',                    0,                    'zingo',                    '01/01/2014',                    'zingo',                    '01/01/2014',                    'pd',                    1,                    null,                    null,                    0,                    '90444444',                    null,                    null,                    null,                    null,                    0,                    0,                    0,                    0,                    0,                    0,                    0,                    0,                    null,                    '01/01/2014',                    'zingo',                    'comment',                    '')        set @iterator = @iterator + 1   end

@temp table variable, if using columns variable, need put variable in from clause. therefore, last insert statement should this:

insert tblclaimcomponents values  select 'cr', intclaimnum, '999999', 'description', chrcvgcode .... --other values here @temp

Comments

Post a Comment

Popular posts from this blog

javascript - Jquery show_hide, what to add in order to make the page scroll to the bottom of the hidden field once button is clicked -

i have button on website when clicked, reveals map. button can seen when page first loads up, when clicked, section holding map slides open , goes out of screen since page loads @ top (normal). want page scroll down bottom of div select when button pushed, if map out of screen. if page scrolled down, , clicks show map button, don't want page jump bottom of map. i tried figure out myself, no luck. seasoned jquery coders able give me guidance? many thanks! map = mapdiv.gmap3("get"); infobox = new infobox({ pixeloffset: new google.maps.size(-220, -310), closeboxurl: '', enableeventpropagation: true }); mapdiv.delegate('.infobox .close','click',function () { infobox.close(); }); jquery(".slidingdiv").hide(); jquery(".show_hide").show(); jquery('.show_hide').click(function(){ lastcenter=map.getcenter(); jquery(".slidingdiv&quo
Read more

javascript - Highcharts multi-color line -

Image
i looking create highchart multi-colored line. if goes down under value, become red, , when comes on value, become green . here picture example: or maybe highcharts have other charts models differentiate high or low level color? you can achieve coloring using lineargradient coloring: color: { lineargradient: { x1: 0, x2: 0, y1: 0, y2: 1 }, stops: [ [0, 'red'], [0.25, 'yellow'], [0.50, 'green'], [0.75, 'yellow'], [1, 'red'] ] } here 0 in stops relates minimum value of series , 1 maximum value, , in between percentages between values. if find percentages according values prior creating chart use correct stops values make relate specific values in data (at least approximately). see this jsfiddle example .
Read more

javascript - Enter key does not work in search box -

tried search guys sorry. input in search box doesnt work (or search) when hit enter when user clicks search button. doing wrong? here code. thanks. <script type="text/javascript"> $(document).ready(function() { $("#submit").click(function() { var url = "http://asla.org/awardssearch.html"; url += "?s=" + $('#googlecse').val(); window.location = url; }); $('#googlecse').keydown(function(event) { if (event.keycode == '13') { $("#submit").click(); } else { //do nothing :) } }); }); </script> <form class="navbar-form navbar-right" role="search"> <div class="search"> <input id="googlecse" type="text" onblur="if(this.value=='')this.value=this.defaultvalue;" onfocus="if(this.value==this.defaultvalue)t
Read more