October 25, 2006 at 7:27 am
in MS ACCESS, I always create a table and delete all the record and fill with the table with data. It acts like temp table. It seem in the SQL server. they do not do that any more. Why ?
Thanks.
October 25, 2006 at 8:58 am
Can you try to explain what you need in more details... I have no idea where you are having difficulties.
October 25, 2006 at 11:12 am
I have employee table which contain the cost center and employee training log. some employee take the training multiple time.
I need to get the percentage of training for the cost center.
In MS Access, I will create a table called stat with the fields ccnumber, total employee count in the cost center, completed training count, incompleted training count, percentage.
Every time when user submit the request with the new cost center, I will delete all the record in stat and replenish with new data.
I do not know whether I should do the same thing like that or some one have the easier way to acomplish to get the result.
Thx.
October 25, 2006 at 11:16 am
You really don't need to do this in sql server (unless dealing with millions of rows and multiple tables). You can use a derived table to get the results in a single query.
If you start a new thread including the table definition, some sample data and the required results, you'll get a promt response.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply