sql - Update table using stored procedure -


we getting data excel source , keeping in temp table , updating target table using temp table stored procedure.i facing problems 'comments' column in target table if new comment comes in should prepend existing comment. riddle here target table column combination of input parameters , fields along comments.eg: 

[target.comments] = '[manager ' + @getdateparameter +'' + uploaded + '] ' +temp.comments + '' + target.comments.

when new record comes in today, 

comment  =  [manager1 may_9_2013 uploader1] robert in canada

if run again in day , there no update (it should check existing comment) in comment 

comment  =  [manager1 may_9_2013 uploader1] robert in canada

if there update in comment on may 15 th should be

comment = [manager1 may_15_2013 uploader1] robert moved away canada , in us.[manager1 may_9_2013 uploader1] robert in canada

how achieve this? thanks.

your don't provide real info write code (are looping, inserting in single statement, etc), try this:

update y     set yourcomment=t.newvalue+isnull('; '+y.yourcomment,'')     yourtable                y         inner join yourtemptable  t on y.pk=t.pk     t.newvalue not null

i coded place "; " between comments, can remove if not necessary. replace "t.newvalue" string concatenation forms new comment.

this schema problem. should create comments table, split out different values own columns, , have 1 row per comment. @ point, insert , no updates or concatenations. can use view or in application processing combine them user presentation.


Comments

Post a Comment

Popular posts from this blog

linux - xterm copying to CLIPBOARD using copy-selection causes automatic updating of CLIPBOARD upon mouse selection -

i've tried various ways coerce xterm (versions 285 , 292) copy selection clipboard clipboard whenever press ctrl-shift-c. promising way far has been, in ~/.xresources, put this: xterm*vt100.translations: #override \ ctrl shift <keypress> c: copy-selection(clipboard) \n\ ctrl shift <keypress> v: insert-selection(clipboard) ctrl-shift-v works perfectly, copying has nuance... if restart xterm, highlighting text puts things in primary clipboard; expected, proper, default behavior. if hit ctrl-shift-c, copies current selection clipboard clipboard. the bug, however, if highlight text after first time pressed ctrl-shift-c, you'll see highlighting copies both primary and clipboard. cannot figure out how stop xterm updating clipboard upon selection... , doesn't make sense me in first place. i said, @ specific point in time, copy selection clipboard... yet starts updating automatically upon selection after doing once... anyone have workaround...
Read more

c++ - qgraphicsview horizontal scrolling always has a vertical delta -

Image
i've subclassed qgraphicsview custom canvas used in cad application. i've reimplemented qgraphicsview::wheelevent check keyboard modifiers control key and, if control key pressed, zoom. i'm trying implement horizontal scroll when user holds shift , uses wheel. the problem i'm having horizontal scrolling always scrolls 0.279. not huge problem, hugely annoying , points else being wrong. so, here questions: is right way implement horizontal scrolling? if not, is? how eliminate delta of 0.279? thanks in advance. code , sample output below void myview::zoom(int delta) { double factor = pow(1.2, delta/abs(delta)); this->scale(factor, factor); } void myview::scrollhorizontal(int level) { qpointf center = maptoscene(viewport()->rect().center()); qdebug() << "center: " << center.x() << ", " << center.y(); centeron(qpointf(center.x() - level, center.y())); } void myview::wheelevent(qwheeleve...
Read more