Database

Create a mapping table that maps the company name from the 2 source systems to your system. This will work but is a solution fraught with disaster, presumably there is no control of the source systems input (excel as a data source :(( ) so whenever a user miss types a company name your mapping goes into the garbage. Never underestimate the power of human stupidity RAH

yes, normally I would use Select Idx, but on samples I use the most simplified syntax. The bad news is that the first two examples work on MySql but not on MariaDB. The third syntax doesn't work on any DBMS, but I never used it and got it yesterday from the internet because I was desperated. I always thought that MariaDB is fully compatible to MySql, but this is unfortunatelly not true. Really bad news for those who migrated a productive system from MySql to MariaDB and are using systax like that :(

SQL Server if you can.

Tridip Bhattacharjee wrote: please share the knowledge. Has already been shared. Google, and you'll find blogs/articles like this[^] one. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

Thank you Jschell, I managed to fix the problem.

This is the fourth repost of Service exposed as a API Service VS Exposing as an stored procedure - Design and Architecture Discussion Boards[^]; please follow the rules.

Thank you

Hi Eddy Vluggen, It helps me a lot. :) :thumbsup:

Use joins, not a where condition SELECT ED.EmployeeId, ED.FirstName, ED.SurName, GROUP_CONCAT(EC.Contact) FROM EmployeeDetails ED INNER JOIN EmployeeSex ES on ED.SexId = ES.SexId LEFT JOIN EmployeeContacts EC on ED.EmployeeId = EC.EmployeeId WHERE ED.EmployeeId = 'emp_password'; If there are instance where an employee does not have an assigned sex, change the INNER JOIN to a LEFT JOIN ========================================================= I'm an optoholic - my glass is always half full of vodka. =========================================================

That is your job, I don't run MySQL. You need to get to know PL SQL or search the support sites for specific problems you run into. There is nothing in there that is specific to TSQL. Never underestimate the power of human stupidity RAH

TheOnlyRealTodd wrote: I mean, if this is something that will seriously take 6 months of dedicated study Not sure how to address that part. A database admin who comes into a shop with no other admin should have about 5 years of experience doing just that. So 5 years of a 40 hour a week job. A place that wants to hack it a bit more with small initial aspirations but whose goal is to deliver a product could get by with a developer who has had 2 years of experience working with databases via a programming language (so familiar with the database but primarily programming is C#, Java, etc.) TheOnlyRealTodd wrote: How do most coders do this? Do it every day for years. TheOnlyRealTodd wrote: Since this will be a data-driven application Very little that isn't but that doesn't insure that you must use a database. TheOnlyRealTodd wrote: Please, don't worry about me being overwhelmed...I'm actually loving getting into all So dive in. You can't learn it if you never start. There are books about programming with databases. You should find one of those. Database design is a different issue just as design itself is a different issue and I have never found a book that really teaches design well (of any sort.) The basics of programming however does lend itself well to books. If you don't mind reading then one that focuses on database programming and another that attempts to teach database admin will, over time, help. I have never been a DB Admin but the admin books I do have have been helpful. As a suggestion try to keep your design as simple as possible.

Maybe should try OPTION(RECOMPILE), so the execution plan is different every time.

After looking at your code, are you sure the value of the "param_country" is a quoted, comma separated list of values ? For example an IN clause would look like this: "select * from myTable where location in ('USA','CANADA','MEXICO') Check the value of the sql_command.Parameters("param_country") right after you populate it with values. BTW: There may be limitations to the number of values you can have in an "IN" clause. I remember from a while ago Oracle had a 1000 item limit, just something to think about. david

Thank you for the help so far. I'll ask if I have permission to conduct a pentest, then I'll try to setup the software to conduct a check.

Your first point isn't a dealbreaker, it's easy enough to change collation in Sql Server or NLS-settings on an Oracle db. Wrong is evil and must be defeated. - Jeff Ello