create and post dataset from sproc

[kaijanm]

Hello. Thanks in advance for any help.

I need to have a sproc that takes a customer ID and a date and generates a dataset based on the inputs and their values in a benefit table and some calculations based on these fields and then inserts the dataset into the billed charges table.

I'm converting an access front end/sql back end database to have a .net front end. Access takes the initial data and populates a local table, then based on the user inputs, populates another table and post the data from the second table to the billed charges table on SQL Server. I'd like to do all of this in a sproc.

Any brilliant ideas?

Thanks!
Kimberly

 

[mrdenny]

ok, that should all be possible. What's your question?

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[kaijanm]

Any ideas on the best way to do this? Select the records into a temp table and append that onto the real table or what? I've actually never used temp tables, so I'm not sure how to do that. Can you point me in the right direction?

Thanks!

 

[mrdenny]

From your description it sounds like you should be able to do this with a single select statement for each step.

Denny

--Anything is possible. All it takes is a little research. (Me)