tsql - SQL Server : coalesce, the part of string is missing -


i have code:

declare @results varchar(500)  select      @results = coalesce(@results+', ', '') + convert(varchar(12),k.t1) (     select          '('+cast(count(distinct(g.roomid)) varchar) + ') '+ rt.classname t1              db_pms.guests g         left join db_pms.roomtypes rt              on rt.roomtypeid=g.roomtypeid              g.groupid = 47 ,          g.status >= 0     group          g.roomtypeid,         rt.classname ) k  select @results results

the part

select      '('+ cast(count(distinct(g.roomid))as varchar) + ') '+ rt.classname t1      db_pms.guests g     left join db_pms.roomtypes rt          on rt.roomtypeid=g.roomtypeid     g.groupid = 47 ,      g.status >= 0 group      g.roomtypeid,     rt.classname

returns 

(1) Люкс (4) Полулюкс (2) Стандарт dbl (6) Стандарт twn (1) Стандарт+ twn

and after using

select @results = coalesce(@results + ', ', '') +  convert(varchar(12),k.t1)

i 

(1) Люкс (4) Полулюкс (2) Стандарт (6) Стандарт (1) Стандарт

as can see part of string column missing. can fix it?

your varchar(12) small hold results, due way mysql (and sql server) counts length varchar. example, running query:

select length( 'Стандарт twn' )

will give length of 20! need increase length, , fine.

sql fiddle showing results: http://sqlfiddle.com/#!9/9eecb7d/5661/0

in sql server may wish consider use of nvarchar well.


-

Comments

Post a Comment

Popular posts from this blog

facebook - android ACTION_SEND to share with specific application only -

in android application have 4 buttons facebook , viber , telegram , whatsapp , want share different content based on each button. for example if user clicks on viber button want user action_send share content viber only. i found this explains how facebook , twitter seems it's calling specific class name of application don't know applications wanna use except facebook. all android apps have unique id, first have check if these apps installed in user's device , can pass unique id via intent sharing. according below: unique ids different apps : viber : com.viber.voip telegram : org.telegram.messenger whatsapp : com.whatsapp check if these apps installed , if installed send messages through intent. private void sendmessage(context context,string message, string appids) { final boolean isappinstalled =isappavailable(context, appids); if (isappinstalled) { intent myintent = new intent(intent.action_send); myintent.settype("text/p...
Read more

python - Creating a new virtualenv gives a permissions error -

i'm getting following output when running virtualenv newvenv . traceback (most recent call last): file "/usr/local/bin/virtualenv", line 5, in <module> pkg_resources import load_entry_point file "/usr/lib/python2.7/dist-packages/pkg_resources.py", line 2727, in <module> add_activation_listener(lambda dist: dist.activate()) file "/usr/lib/python2.7/dist-packages/pkg_resources.py", line 700, in subscribe callback(dist) file "/usr/lib/python2.7/dist-packages/pkg_resources.py", line 2727, in <lambda> add_activation_listener(lambda dist: dist.activate()) file "/usr/lib/python2.7/dist-packages/pkg_resources.py", line 2227, in activate self.insert_on(path) file "/usr/lib/python2.7/dist-packages/pkg_resources.py", line 2334, in insert_on self.check_version_conflict() file "/usr/lib/python2.7/dist-packages/pkg_resources.py", line 2373, in check_version_conflict...
Read more

go - Idiomatic way to handle template errors in golang -

say have html/template following: <html> <body> <p>{{somefunc .somedata}}</p> </body> and somefunc returns error. there idiomatic way deal this? if write directly responsewriter , status code 200 has been written before encounter error. var tmpl *template.template func handler(w http.responsewriter, r *http.request) { err := tmpl.execute(w, data) // "<html><body><p>" has been written... // err? } preferably return status code 400 or such, can't see way if use template.execute directly on responsewriter . there i'm missing? since template engine generates output on-the-fly, parts of template preceding somefunc call sent output. , if output not buffered, (along http 200 status) may sent. you can't that. what can perform check before call template.execute() . in trivial case should enough call somefunc() , check return value. if choose path , return value of somefunc() c...
Read more