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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-27 : 08:02:50
|
| John writes "If you were integrating a feed of end of day stock price information (open, high, low, and closing price) for 5,000 companies, how would you do it? You are responsible for the development, rollout and ongoing monitoring and maintenance of the feed. Describe the different methods you considered and why you would recommend your approach. The feed would be delivered once per trading day in a comma-separated format via an FTP site. The feed will be used by 1000 daily users in a web application." |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-10-27 : 08:05:03
|
| Ooh Ohh I know!I'd ask for help with my homework and get a job I wasn't qualified for.Damian"A foolish consistency is the hobgoblin of little minds." - Emerson |
 |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-10-27 : 11:23:48
|
| Just tell them you'd implement a normalized, highly-scalable, robust XML web service using polymorphism, cascading style sheets, inheritance and AJAX.I guarantee you'll impress them and get the job! |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-10-27 : 11:32:32
|
| Just make sure that it leverages e-enabled best-of-breed enterprise paradigms, cause nobody wants a product that doesn't.http://www.dack.com/web/bullshit.html |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-10-27 : 11:59:02
|
| Strange - I did exactly that a few months ago.It's fairly trivial and everything needed is on my web site.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-10-27 : 13:57:31
|
| Actually, you can just use the Stock Price Integration Wizard. It's all drag-and-drop. |
|
|
|
|
|
|
|
|
Stock Price Integration