Re: Looking for a professional SQL programmer for a small job

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 11/15/04 

Date: Mon, 15 Nov 2004 12:31:13 -0500

This isn't really a job board, and I hope you don't plan on repeating this
message every 4 days. Have you considered using Monster or eLance instead
of a peer-to-peer technical newsgroup? 

-- 
http://www.aspfaq.com/
(Reverse address to reply.)
"Scott Schluer" <usenet@webservicesinc.com> wrote in message
news:uVw$3izyEHA.2012@TK2MSFTNGP15.phx.gbl...
> Hi,
>
> I'm going to need to borrow someone who has a lot of experience building
> complex queries in SQL Server and who also has experience with ASP.NET
(just
> in case). I have two queries to build and while I know my way around SQL,
I
> need someone who can write two extremely efficient stored procedures for
me.
> I plan on heavy site usage and it's imperative these two queries operate
as
> efficiently as possible. I'd prefer someone who is Microsoft certified or
> who can at least demonstrate a thorough understanding of SQL and query
> performance.
>
> One is a seach query that pull rental properties from a database based on
> search criteria that the user enters (city, state, zip -- either within
the
> given locale or within "x" mile radius of it -- I have the zip code DB in
> place, also bed, bath, min/max sqft, min/max rent, etc. There is also a
> dropdown list of lease terms (1 month, 6 month, 1 year, etc). The user can
> pick/choose as many of those as they want. Also included is a checkbox
list
> of amenities (pool, tile flooring, walk-in closets, etc). The query should
> rate results based on a percentage match of all critera, but should not
> really exclude properties whose amenities don't exactly match. We should
> still return properties with amenities they didn't choose, or if it
doesn't
> have the amenities they want, but we'd display them further down the list.
>
> Also, I will be allowing users to save search queries so that the
> application can e-mail them as soon as a matching property is posted to
the
> database. I'll need the query written to go through the database table for
> saved queries when a property is posted, determine whether or not that
query
> matches the posted property, and add a record to the mailing table if it
> matches.
>
> I'll provide much more detail to whomever I hire for the job. I have the
> forms and database tables designed and online, all I need are the two
> queries. Please respond to the group or to:
>
> scott@webREMOVETHECAPLETTERSservicesincDOTbiz
>
> Thanks!
>
>

Relevant Pages

  • Re: access 2003
    ... I removed the parameters from the form query source. ... boxes from the form header, events, code, etc and ran the form query source ... forms queries and the SQL because syntax of the SQL will change randomly. ... the Access 97 database, I wouldn't have thought any expressions would be ...
    (microsoft.public.access.conversion)
  • Re: access 2003
    ... I removed the parameters from the form query source. ... synchronize combo boxes to the detail section or the parameter form query ... forms queries and the SQL because syntax of the SQL will change randomly. ... the Access 97 database, I wouldn't have thought any expressions would ...
    (microsoft.public.access.conversion)
  • Re: Query In BE database
    ... that would give the users "live" access to the underlying queries. ... When selected from the drop-down list box, I what the the query that is ... What Is A Remote Query? ... point your local query to a query that was in another Access database. ...
    (microsoft.public.access.queries)
  • Re: merge multiple databases
    ... You need to create a new Access datafile (mdb) to store all in. ... Open the newly created Access database. ... Click on the Queries icon. ... "Create new query", then select lnkDrive as the table to ...
    (microsoft.public.vb.general.discussion)
  • Re: merge multiple databases
    ... You need to create a new Access datafile (mdb) to store all in. ... Open the newly created Access database. ... Click on the Queries icon. ... "Create new query", then select lnkDrive as the table to ...
    (microsoft.public.access.queries)