Fix Issue in SQL Query mentioned in Job Description

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]

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 different parts of the world.

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

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 can reach me at any time on online . I have also a few clarifying questions on the project.I’m an Expert, Honest, Sincere, Quick learner and Responsible worker as I’m taking my work like my Responsibility. kind regards.

I have an expert in SQL query. these days am working on a PHP websites those reviews in some product.

I want to apply for this project because of a great command on sql queries and recently build a project on leave management system

Having 3 + years in writing SQL queries. Can solve the issue in few hours. can help you beyond the query.

I have 4 year experience SQL database Developer,creating tables,stored procedures,functions and triggers ..Sql query

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 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.

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.

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_STATUS = 0 BEGIN Set @StrWhere = @StrWhere + '@Var like ''%'+ @keyw +'%''' --- contact skype_id: thinguyendinh86 FETCH NEXT FROM keyw_cur INTO @keyw END CLOSE keyw_cur; DEALLOCATE keyw_cur; Print @StrWhere

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 only. You need not use PATINDEX.

I have more than 4 years of experience in database administration and making MIS writing queries to fetching data in Oracle and SQL Servers.

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 OtherDesc LIKE keyw GROUP BY Id , [Name] , Descr , OtherDesc HAVING COUNT(1) = (SELECT COUNT(1) FROM @TempKeys)

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 doing DB design. Here is few technologies I have mastered since last 9 years and can deliver the best solutions if you get me hired. 1) Sql Server 2005/2008/2012 2) MYSQL, MS Access 3) Oracle (PL/SQL) 4) SSIS, SSRS , SSAS and Power BI 5) Data analytics using R-Programming and SAS