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 |
|
JAdauto
Posting Yak Master
160 Posts |
 Posted - 2007-02-12 : 14:34:43
|
| I have a problem with one of the processes in our application. It takes a new client about 8 hours to process a monthly routine. This is not acceptable. A client may have 4000 members to process. We gather all the members that will recieve a statement and then process their charges one by one and put the data in statement tables to be printed. There is a lot of processing via SQL statements, data objects, vb code, etc. It is by far the most complicated piece of code we do in our system. My boss wants all of it moved into a stored procedure to try to speed up the processing time. I dont even know if what all we do is possible. He emailed me a stored procedure that another vendor does that seems complicated as well. I have tried to do just one little piece of this processing by doing an Insert Into to build one record, but we get the data from so many different tables. We may get the period info from one table, the sorting settings from another table, the dates from another table. I cannot figure out how to get all the data from all the different places into one statement. And this is just probably 1/32 of the processing that it does. I am not asking anything specific I guess. I am just very overwhelmed. I am pretty knowledgable in T-SQL syntax and have written some pretty complex Select statements, but we do all of our data updating through the data objects, not via a Insert and certainly not all in one SP. If anyone has any information that they can share (links, websites, etc), I appreciate all I can get. Thanks so much,JAdauto |
|
|
|
|
|
General SP Help