...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 refpsc.active_ind='Y'
...macro for Access and Excel that will apply a filter (this filter will always change depending on search term needed.) to multiple tabs (Access) or worksheets (excel) that I need this filter applied. I'd like to be able to filter one worksheet apply the macro and all tabs/worksheets will reflect the filter. I'd also need an easy way to clear all exis...
...within each XML file needs to be updated based upon a matching field in an MS Access table. The XML files are NOT uniform in data element structure, the schema can be a bit different from XML file to XML file. The high level process flow is to compare one field of a table to one specific element in the XML file and update the 3 related data elements as
I need a group caricature of men sitting around a table eating and drinking. The table should have 6-8 people with 4-5 actual caricatures somewhat resembling certain people. It will be used for an invitation. The attached file will give you an idea of what's required. Am very flexible on timeline (doesn't need to be completed for a month or two). it
Show me how to configure and create filters using FacetWP and Woocommerce, I have a demo site and I tried to configure Facetwp plugin but I was unable to see it working. I think my site has something wrong.
I need a design for manufacturing a rotating table with following specifications. a) Height of the table – 1300 mm b) Outer diameter of table – 1000mm c) Legs to have lockable wheels for free movement of table. d) All materials to be made of MS / IS2062. Please revert for any clarifications.
Small frontend website which makes use of a single PostgreSQL-Table. Implement basic CRUD functions with some contraints Requirements: - Knowledge in PostgreSQL, Angular, PHP - Has do be completed with all requirements fullfilled until 20th December 2017 Only application with links to last projects (using Angular) will be considered. There
Please look at the google Folder that i have shared with you. [url removed, login to view] please take a look
I want machine that can folding a paper to bag. Size machine like photostat machine. Can be many drawer for different type of folding
I need some help in creating report, dashboards, pivot tables on Intersystem Deepsee. Excellent knowledge of Crystal report, Intersystem Deepsee and SQL is very important.
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 use an RSS feed to read through projects from two different freelance platforms. It's just too many links. I can't read them and put together proposals everyday myself and i need help. I have very specific criteria that i look for that i have posted here. i want someone to read the RSS feed that i provide, and check each project to make sure that they do match the criteria only w...
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.