Encerrado

Sql DBA - Need a query / stored procedure for searching multiple tables for a text box on site

sql server 2012

windows server 2008

My site has a search box on on top. I want the search to search for the following;

zipcode

address

street name

ID number "MLNumber in our db"

Description

city or state

I am looking for a dba to review the tables and decide on best way to search.

You will need to return the ID for each record so we can map them.

4-5 tables in DB

each table has about 50+ columns

VIEW 1 OF 5 TABLES BELOW... THE OTHER 4 ARE VERY SIMILAR

Habilidades: Administração de Bancos de Dados, MySQL, SQL

Ver mais: top searching, top query, sql dba, mysql dba, map box, DBA, db query, mysql number sql, mysql windows server 2008, query text mysql, web crawler search text box web site, site dba, state zipcode address, search city zipcode, mysql search address table, sql dba query, query sql windows, sql multiple tables, state city mysql table, query sql dba, multiple address map, windows server 2008 mysql, procedure mysql, mysql procedure, mysql stored procedure

Acerca do Empregador:
( 65 comentários ) Houston, United States

ID do Projeto: #6793392

29 freelancers are bidding on average $125 for this job

truongnguyen86

Hi there, i'm expert on SQL, actually i've done many project like writing procedure to produce the report, pls share me more your requirements. Waiting for your feedback. Thank you

$150 USD in 3 dias
(148 Comentários)
6.5
customizedata

Please provide me the site address along with the db script. I have a large experience of writing queries and Stored procedures. 1- Do you want that search is on the basis of keyword written in the textbox from fron Mais

$100 USD in 3 dias
(134 Comentários)
6.3
feninsoftech

Hi, This will be achieved by joining these tables and filtering all these columns with OR operator. I have 9 years experience in SQL Server 2005|2008|2008R2|2012 and involve in designing databases, Indexing Strat Mais

$222 USD in 3 dias
(29 Comentários)
6.0
arpitutrivedi

Hello, Thanks for additional information to project requirements. My bid amount stays same. I may have additional questions on how search text would be searched if I am awarded this project. For example, if user sea Mais

$111 USD in 3 dias
(43 Comentários)
5.1
shadowdancerlv

The key to this solution is to present a unified list of records from each of the tables via the UNION operator While searching all of the tables I can return the list of id and the tables they come from. That way y Mais

$147 USD in 2 dias
(10 Comentários)
4.6
bspanovic

Hello I'm Microsoft Certified Database Developer & Administrator and this query I could solve you in 1 hour. I will prepare you best variants and suggest indexes. I believe that best solution will be combination Mais

$30 USD em 1 dia
(10 Comentários)
5.4
abdellatif81

Hello, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years of experience working around databases and SQL development arou Mais

$98 USD in 2 dias
(14 Comentários)
4.5
RKYSP

Hi, I am an individual freelance, having more than 10yrs of exp in developing applications, window & web based, using .Net (C#.Net, Asp.Net (MVC), XML, WPF, WCF (Webservices) kendo ui, MySQL and SQL Server etc). Mais

$100 USD in 2 dias
(5 Comentários)
3.6
ForeignTree

i can write the query in next few hours so we may set it a stored procedure or as a query only

$111 USD in 0 dias
(1 Comentário)
2.9
grundahl

Hi, I'm an expert DataBase Administrator. I can do your job very efficiently. Sincerely yours, Eric

$94 USD in 2 dias
(1 Comentário)
2.6
ekajgho

Over 14 years of experience in Microsoft Technologies. MCTS (Microsoft Certified Technology Specialist) on Web Applications Development with Microsoft .NET Framework 4 (Exam Code: 070-515). Functional experience incl Mais

$166 USD in 3 dias
(1 Comentário)
2.1
shawnmcginty

I'm an SQL expert, been working as a Microsoft SQL DBA for 5 years. I can write whichever queries and/or stored procedures you need.

$111 USD in 3 dias
(1 Comentário)
1.8
bhoopendravw

first of all , 4-5 table with 50 columns ?? we need to rethink the design. i m sure there is something wrong with ur design. let me have a look, i can redesign the table and import all the data into new databse in n Mais

$111 USD in 3 dias
(1 Comentário)
1.0
fazeelraza

Hello, Sir. I am willing to make make such SQL query for you. PM me for further discussion. Thank you!

$100 USD em 1 dia
(2 Comentários)
1.5
arunnehru3

Right now i'm working in Database domain only ,so i can do this project well ,

$155 USD in 3 dias
(0 Comentários)
0.0
mpenroz

Soy experto en Sql Server, para realizar tu requerimiento necesito la estructura de las tabla afectadas con algunos datos para probar. Saludos.

$222 USD in 2 dias
(0 Comentários)
0.0
bs4y1964

Dear Ladys, dear Gentleman, We would like to submit you an offer for your project. Despite more than 25 years of market presence, we are here on this web portal one of the 'young' provider. We would like to introdu Mais

$149 USD in 2 dias
(0 Comentários)
0.0
omiortiz

Hello , My name is Omi Ortiz, and I’m a developer based in Albany, NY. I saw your listing, and thought I’d be a good fit for the role. I have done may jobs like this one and I am willing to work until you are satisf Mais

$133 USD in 2 dias
(0 Comentários)
0.0
artemoleynik

Have experience of writing queries and stored procedures. It is necessary to elaborate on the job. You can communicate via e-mail

$35 USD in 3 dias
(0 Comentários)
0.0
rkeshari91

A proposal has not yet been provided

$155 USD in 3 dias
(0 Comentários)
0.0