Fix SQL Query Issue.
What to fix: Need to fetch those records / rows that contains all keywords in any column in Name, Descr or OtherDesc Columns.
See txt file for details.
Important Note: Please read the txt file and prepare your queries if any before posting, otherwise the bid will be rejected.
Hello, i have experience in Sql server for past 4+[login to view URL] worked on many large sql query procedure and [login to view URL] sample query on the below link. [login to view URL]
21 freelance font une offre moyenne de $24 pour ce travail
Sir I have vast experience in databases,We can discuss more in chat about the details,u can view my profile and complete on time.I am a full time freelancer, working for more than 2 years now. Have clients from differ Plus
Hi, Could you please confirm that the query you are trying to fix is the final SQL statement - with the join to @TempKeys to retrieve the required data set from @CatalogSearch? Cheers, Ranjana
i will do that sql [login to view URL] much time you have? what you want to do with sql? i see that queries .please come on chat to describe what you want?
Hi, I can fix a query for your system. Come on chat for further discussion. Thank you!......................
I have total 6.3 yrs of experience in Oracle SQL and PLSQL developement. I have created the PLSQL block which will print the query statement without Hardcoding.
If I understood your problem, this is a possible solution for the attached txt: SELECT Id , [Name] , Descr , OtherDesc FROM @CatalogSearch INNER JOIN @TempKeys ON [Name] LIKE keyw OR Descr LIKE keyw OR Plus
I have more than 4 years of experience in database administration and making MIS writing queries to fetching data in Oracle and SQL Servers.
There is problem in your query. Can you post the full output of your queries to me? Also post one sample output with example data. Probably after joining the tables you need to filter the records based on distinct id Plus
DECLARE @keyw nvarchar(100) DECLARE @StrWhere nvarchar(max) Set @StrWhere = '' DECLARE keyw_cur CURSOR FOR SELECT keyw FROM @TempKeys; OPEN keyw_cur FETCH NEXT FROM keyw_cur INTO @keyw WHILE @@FETCH_ST Plus
I have found the issue with your last SELECT statement. Let me know if we can connect. I have experience with SQL Server DB2 SQL and Oracle SQL.
Hi,I have read your requirements of I need a calculator in C and I’m pretty confident that I will be able to get your work done within the given time your requirements conclude.I am very keen to discuss further. You ca Plus
Hey, Have thought of a approach to go ahead with your problem. We can use a join but will need some details about tables. Hit me up over chat box so that we can talk. Have a good day.
I have 4 year experience SQL database Developer,creating tables,stored procedures,functions and triggers ..Sql query
Having 3 + years in writing SQL queries. Can solve the issue in few hours. can help you beyond the query.
I have 8 years experience in writing query and i will be able to finish your task on [login to view URL] need to use a select query to fetch the data from table. SELECT DISTINCT Id, [Name], Descr, OtherDesc FROM @CatalogSearc Plus
I want to apply for this project because of a great command on sql queries and recently build a project on leave management system
I have an expert in SQL query. these days am working on a PHP websites those reviews in some product.
I'm an experienced freelancer database and report design, development and optimization with more than 9 years of experience . I have used Erwin tool for data modelling and i am well-versed with Normalization's for doin Plus