Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
FEAShane
Starting Member
3 Posts |
 Posted - 2005-11-10 : 15:02:46
|
| Hello, we am looking for someone to help us write and implement an SQL database to integrate with our ecommerce database system. The query needs to be written in SQL and we dont have a clue how that is done so I am looking for an expert. We are willing to pay for your service so if you are interrested please contact us at shane@frontendaudio dot com or 803-738-1222. Ask for Shane.Shane Selbywww.frontendaudio.com |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-10 : 15:12:04
|
| We produce an ecommerce system that (in standard form) accepts up to 5,000 orders a day and costs around $100,000 - $200,000. It is usually uneconomic (flexibility and commensurate complexity outweigh what the client can reasonably be expected to tool-up for) for less than 1,000 orders a day. Is that what you are looking for?Kristen |
 |
|
|
FEAShane
Starting Member
3 Posts |
Posted - 2005-11-10 : 16:28:41
|
| We dont need a ecommerce site. We simply need a SQL database written for a single query we are trying to do. The query needs to be written and integrated into our current import/export system. Shanewww.frontendaudio.com |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-10 : 22:20:58
|
| "We simply need a SQL database written for a single query we are trying to do"One query? If you explain what it is I, or someone else here, will probably knock it up for you.Kristen |
|
|
|
FEAShane
Starting Member
3 Posts |
Posted - 2005-11-11 : 09:07:54
|
| Here is what I am trying to do:I am trying to create a “rewards” program that will give customers a % discount on their purchases once they have reached a certain threshold of spending. I can easily do this by applying a percent discount to their account. This is a feature of the software. However, I will need to monitor customer spending levels on a frequent basis. I figure the best way for me to do this is to export this information to an excel file so I can review and edit it. I need the ability to export the following information: customer id's, overall dollar amounts they have spent with our company, and their percent discount (typically 0 until they reach the threshold). Once I have this database I can easily see the spending activities of all customers, quickly apply percent discounts, and import this back into the system.If anyone can help I will be forever grateful! |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-11 : 10:36:54
|
| Can you provide the DDL for the Customer and Transaction History tables (or the equivalent tables that are needed to show the "overall dollar amounts") please.Just to confirm: 1) Your ecommerce database system uses a Microsoft SQL Server database.2) You want a SQL query that will output Customer IDs, Percent Discount and Total Dollar amount they have spent (over some period of time - lifetime of customer??)3) You would like this information in an Excel spreadhseet, and you will do your calculations in ExcelKristen |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-11-11 : 11:59:23
|
| 'be careful'IF the benefit of your rewards system is part (or a side-effect) of the terms and conditions of the site, then this style of 'semi-integrated/adhoc' generation or determination of rewards could cause you a) logistical nightmares b) accounting difficulties and c) legal difficulties...if people don't get the rewards that are due to them.Provided the numbers are low and your manual controls are good, Excel may be fine, otherwise you may need to scale up to a more robust rewards system/process. Either way you will need some kind of extraction process as you initially describe. |
|
|
|
|
|
|
|
|
I need help with SQL!