Hi. You must explicitly use UNION ALL when you need duplicate. If you using UNION already remove duplicates.

To solve mentally with no use of paper, I need to imagine 5 squares, made of stones laid out on a table. we have first square that is made of 10x10 red stones. second square is made of 10x10 red stones plus 1x10 green stones at top and 10x1 green stones at right, then to fill the square we have a 1x1 square of blue stones at top right corner. third square is made of 10x10 red stones plus 2x10 green stones at top and 10x2 green stones at right, we fill the square with 2x2 stones. etc... red stones are 500 (5x10x10) green stones are 200 (20 on second square, 40 on third, 60 on fourth, 80 on fifth) blue stones (squares of 1, 2, 3, 4) are 1+4+9+16 = 30 total 730 stones. 730 / 365 = 2.

Thank you, I'll double check once published.

Hello, i have an article (editing it since 2017... but have few times to work on it), if I open it on the editor page i see images, once i open it in the "my articles" section it does not show the images. Here are image urls: on the http://www.codeproject.com/script/Articles/ArticleVersion.aspx the image are linked to the https://www.codeproject.com/KB/recipes/1276311/Working/_INT_DIV_08.png, which is broken. Instead in the editor https://www.codeproject.com/script/Articles/SubmissionWizard.aspx the images are linked to https://www.codeproject.com/KB/Articles/1276311/Working/_INT_DIV_08.png which is actually working. Do i need to relink all the images in order to make it work again? Best

Hi, thank you for answering. I will follow your advice to publish all at once when ready then. My goal is show (to who is interested) ideas about how to create their own MP library, being myself just an amateur on this kind of stuff. I think to title the series "Teaching arithmetic to a computer" or maybe "The Big Integer Challenge" and divide the article into parts that could be viewed independently, all the code needed to study and build your own implementation is embedded on article. Part #1 the sum

Sample summary: * define sum, simple sum primitive to build long sum, base 10 * carry properties and implication * from base 10 to any other base (specifically CPU register sized digits) * The Long Sum algorithm, with flow chart * carry propagation, carry detection on higher level languages * listing in C language and x64 assembler with comments * bar chart for above implementation timings * Appendix

Part #2 the subtraction, Part #3 the multiplication Part #4 the division: this will probably be the longest one. Part #5 the arithmetic challenge: (did not start writing yet) * show how to use the toy framework i created in order to validate other implementation and compare performance to the reference implementation * evidence parts that need to be changed if porting the code outside of windows environment or different hardware platforms. * install Microsft assembler extension on Visual Studio * show how to create basic statistic from csv dataset generated by the program, * (maybe) challenge the community members to fork and create new fastest implementation In total the document should be like 50 printed pages if on WORD, kind of 8-12 pages per article. Could that be ok? Which is a good measure of an article lenght expressed as "printed page"? What about the source code, should I add it just once to the latest article? Because all the relevant sources are in a single project. Best Andrea

Hi everybody, in my few spare time I am creating a new article on the subject "multiple precision arithmetic" (MP for short). I wrote about arithmetics sharing code snippets, at the end of the article I will present source code which runs unit tests and most notably collects statistics of different MP implementation. I don't know what length an article should be, I just know the stuff I have is quite long. I'm afraid that a single long page could discourage audience, i could strip some paragraphs but I already removed much in the effort to balance clarity and brevity, I'd rather prefer to write a series of 5 articles. I did not found on guidelines "what when and where" it is considered good practice to split long articles into chapters. There are limitations? Suggestions? Best Andrea

Hello, about ten years ago, I developed my first and only one client app for a barcode scanner, it was a psion workabout scanner, i can't remember how, but I remember that PSION provided an API that allowed me to register my app into the scanner hardware and get the scanning codes as EVENTS instead of use keyboard emulation, the event arguments were a structure containing lot of metadata about the barcode, such as "barcode kind" geometries and so on, the event arguments also provided a raw byte array of scanning data, which I used to parse a bunch of GS-1 logistic labels. All the above just to say that maybe the hardware manufacturer could provide you the API you need to communicate with their hardware device / driver. Good luck

Hello, are you sure it's a deadlock or it is a generic timeout? A table can't deadlock just because many users try to insert. Deadlock means someone is blocking record A then try to lock record B while other process locked B then try to lock A. If that happens just have both the process lock the resources in the same order (first A then B) this will avoid the deadlock, by definition, and can be done saving all records sorted by primary key, for example, within a trasaction. Best Regards Andrea