...column values as first. psc_name result should come second with the 2 columns concatenation. 2. query should work irrespective of no stop words. Query is working fine in some cases, but its not working some scenarious. Thats need to fix Here is the Query : SELECT refpsc.* FROM iae_reference.ref_product_service_code refpsc WHERE 1=1 AND
Looking for expert system engineer who can consult and giv solution how to fix on slow query. our project is about ecommerce system and handle multi-product what we found problem is - search product - import product via CSV (which has many process behind) we want fast speed and good approach. we usign laravel backend MySQL DB You can setup
I have txt log files with data. I need to parse data and seperate it into two files. With the data that is seperated i need to seperate it again and then query my database to determine which files do not exist to add data not already there.
It is a tiny task: Creating little function (in a separate module) to query sqlite3 DB to find if particular record exists (I will give the query). If exists, return True or False. Then [url removed, login to view] the function. -Db, table already there -Query already there
I need to someone to help me create a dynamical data structure query in MySQL, with an output from parent to child, as the following: Level | ParentID | ChiledID Output notes: - The results must be in the same order as you see in the excel file. - The query must get the output dynamically. For example, when I insert new level into the table
Create a C# Windows Forms application that allows for a single image object(size 50 by 50 pixels) to be displayed at the top left corner of the form (Form size should be fixed at 400 by 400 pixels).After every 20 milliseconds, this image will move clockwise by 5 [url removed, login to view] every corner, the image object should display a different [url removed, login to view] process should
Hello! Need help to build a laravel query. I'm trying to access the latest messages from a table with content: message_id -> incremented value from_id -> can be either $userId or another id to_id -> can be either $userId or another id message -> the message created_at -> timestamp A user's user id can appear in both the to and from column
...to use database query results. I only have basic web development experience. I just need help adding these database results... <?php $connect = mysqli_connect("localhost", "user123", "pass123", "page_list"); $query ="SELECT page_name, page_url FROM page_list ORDER BY page_name"; $result = mysqli_query($...
...proposal. I found a plugin that attaches an Excel file with the notification message when a form is sent with Gravity Forms under Wordpress. I need this plugin modified to send CSV plain text file instead. Must be well programmed and documented (inline). [url removed, login to view] The Admin Field Label must be
I want to make a Round Robin configuration setting in the Kannel for the below message sending given that I have 2 SMSC(SMSC0 and SMSC1). When no SMSC is present in the query string, I like to use SMSC0 and SMSC1 in a Round Robin fashion. This is something like making a Default SMSC setting that will handle those things not explicitly handled by any
...a switchboard that contains a logo, picture, and buttons to open other forms, one of the forms should be a split form, a form with multiple fields from multiple tables etc.. full details in phase4 file do corrections (if any) to the msaccess db based on the ERD and phase3 file if you can't deliver it ON or BEFORE Saturday *PLEASE DO NOT APPLY*
...(for example 100km) of a given point. I looked at ST_Buffer but not sure if this will work. All I need is someone to make the query for me and for it to work. To give you the table names for this query, please see below a query used for DIFFERENT application. It retrieves 1 polygon for each point: SELECT * FROM raw_sa1regions2011 where st_contains(SHAPE
Need SQL SERVER Expert Who can build a n level query for json data coming from multiple tables
Hello! We are displaying data from a mySQL 5.1 database on our website. In the past we used an SQL query to gather the following fields from a table: - first_name - city - state - profession - date_of_birth where the "status" field of the user was confirmed. In the past this was easy because all the users were stored in one table (wp_net_user)
Query performance improving in bucketing using map reduce or any algorithm with Hive, comparatively should show the implemantation in Hadoop , on any data set ....for example I wanted to create a single bucket for different different buckets to show that improved performance comparatively than the existing system