Terminé

Fix Issue in SQL Query mentioned in Job Description

Décerné à:

ibrahim20

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]

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(0 Commentaires)
0.0

21 freelance font une offre moyenne de $24 pour ce travail

hamzzaamalik

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(20 Commentaires)
4.9
psranjana

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)
2.4
dataEntryExperty

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?

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(3 Commentaires)
2.1
fazeelraza

Hi, I can fix a query for your system. Come on chat for further discussion. Thank you!......................

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
0.3
deepakparmar0909

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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
vw1366081vw

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
zeek87

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
CoolTechie07

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
thind86

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
abss81

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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
krishnaagr89

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
aldrinmachado

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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
reddyjagan

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
ravitejainwhite

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
ervjain89

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
TahaShakir40

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
jainajay401

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
sunilmudunuri

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0