Re: Looking for a professional SQL programmer for a small job
From: Scott Schluer (usenet_at_webservicesinc.com)
Date: 11/15/04
- Next message: sg: "Re: update multiple values at the same time"
- Previous message: Joe Celko: "Re: TSQL Question. URGENT Help. Exists and Not Exists Question"
- In reply to: Aaron [SQL Server MVP]: "Re: Looking for a professional SQL programmer for a small job"
- Next in thread: Louis Davidson: "Re: Looking for a professional SQL programmer for a small job"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 15 Nov 2004 10:46:19 -0700
No, I don't plan on repeating it, just thought I'd try it one more time. I
know a lot of skilled programmers visit here, so I thought I'd give it a
shot before I pay for something like Monstor or E-Lance.
Scott
"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!
>>
>>
>
>
- Next message: sg: "Re: update multiple values at the same time"
- Previous message: Joe Celko: "Re: TSQL Question. URGENT Help. Exists and Not Exists Question"
- In reply to: Aaron [SQL Server MVP]: "Re: Looking for a professional SQL programmer for a small job"
- Next in thread: Louis Davidson: "Re: Looking for a professional SQL programmer for a small job"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
