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

From: Louis Davidson (dr_dontspamme_sql_at_hotmail.com)
Date: 11/15/04


Date: Mon, 15 Nov 2004 13:12:38 -0600

Is is considered wrong to post jobs like this? I had wondered about this.
I know of a company that has an opening for the very type of person who
frequents these newsgroups, but I was never quite sure if it was a good
idea. I will say that 8 years ago I got my first real job from a headhunter
that posted in to a newsgroup :)

-- 
----------------------------------------------------------------------------
Louis Davidson - drsql@hotmail.com
SQL Server MVP
Compass Technology Management - www.compass.net
Pro SQL Server 2000 Database Design - 
http://www.apress.com/book/bookDisplay.html?bID=266
Note: Please reply to the newsgroups only unless you are interested in 
consulting services.  All other replies may be ignored :)
"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message 
news:uDf53kzyEHA.2200@TK2MSFTNGP09.phx.gbl...
> 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: Index Seek (or) Index Scan in Execution Plan
    ... your queries do run better when you use them. ... Run your query with and without the hint, ... SQL Server MVP ... >>>> It is preferable to not use index hints, ...
    (microsoft.public.sqlserver.server)
  • Re: Index Seek (or) Index Scan in Execution Plan
    ... your queries do run better when you use them. ... Run your query with and without the hint, ... SQL Server MVP ... >>>> It is preferable to not use index hints, ...
    (microsoft.public.sqlserver.programming)