sql server - Max() function not returns the max value -

-

i used max() retrive max value column. returns wrong output. here max() returns . kindly suggest

select seq_no appltype app_no = '01'

output : 1,2,3,4,5,6,7,8,9,10

select max(seq_no) appltype app_no = '01'

output : 9 can't able attach image new stack overflow.

the field seq_no not numeric type. please try query:

select max(cast(seq_no int))    appltype   app_no = '01'

Comments

Post a Comment

Popular posts from this blog

php - Hide output during test execution -

-
i have var_dumps in php code (i understand there must none in end, still), , while tests running outputs non necessary information console, there method ignore code execution? i've tried /** * @codecoverageignore */ and // @codecoverageignorestart print '*'; // @codecoverageignoreend but ignores coverage, , still executes code. you can set setoutputcallback nothing function. effect suppress output printed in test or in tested class. as example: namespace acme\demobundle\tests; class nooutputtest extends \phpunit_framework_testcase { public function testsuppressedoutput() { // suppress output console $this->setoutputcallback(function() {}); print '*'; $this->assertfalse(false, "don't see *"); } } you can find reference in doc hope help
Read more

java - Drawing vector images on PDF with PDFBox -

-
i draw vector image on pdf apache pdfbox. this code use draw regular images pdpage page = (pdpage) document.getdocumentcatalog().getallpages().get(1); pdpagecontentstream contentstream = new pdpagecontentstream(document, page, true, true); bufferedimage _previmage = imageio.read(new fileinputstream("path/to/image.png")); pdpixelmap previmage = new pdpixelmap(document, _previmage); contentstream.drawxobject(previmage, prevx, prevy, imagewidth, imageheight); if use svg or wmf image instead of png, resulting pdf document comes corrupted. the main reason want image vector image png or jpg image looks horrible, think gets somehow compressed looks bad. vector images shouldn't happen (well, when export svg paths pdf in inkscape doesn't happen, vector paths preserved). is there way draw svg or wmf (or other vector) pdf using apache pdfbox? i'm using pdfbox 1.8, if matters. i this, not directly. in first transform svg documents in pdf documents ...
Read more

Qt4: how to send QString inside a struct via QSharedMemory -

-
i have struct struct control_data{ int column_number; qstring cell; }; i need send thread of qsharememory. read can't because qstring contains pointers inside. other ways? you have serialize struct byte array. can convert qstring const char* this: mystring.tostdstring().c_str(); but serializing qstring should work. the first step serialize struct qdatastream using qt, example here . then once struct can read , written can pass shared memory. a complete example of using qsharedmemory can found here . here relevant code: // first, test whether shared memory segment attached process. // if so, detach if (sharedmem.isattached()) { sharedmem.detach(); } ... qbuffer buffer; buffer.open( qbuffer::readwrite ); qdatastream out( &buffer ); out << youstruct; int size = buffer.size(); // size of int + size of qstring in bytes if ( !sharedmem.create( size ) ) { return; } // write shared memory sharedmem.lock(); char *to = (char*...
Read more