- The alarm didn't go off.  Kidding... it really did.  Unfortunately.

Broom Hilda having departed, I set about my assigned task. It seems Tubby thinks I can communicate in SQL as well as HTML. False, of course.

I refuse to do anything else on this little project.  It's not going well, and I'm just not clever enough to make a go of it.  (If you are, just yell.)  The project (using T-SQL) is to insert one row into Table "A" for the results of a select statement from Table "B".  Such that the select statement identifies 10 results in Table B that meet the criteria, a total of 10 rows need to be inserted into Table "A".  Along with that insert is some other variables, to be plugged in at the time of insert.  If you can read SQL code at all, it's likely going to be apparent that I cannot write it, eh?  Here's what I've got after 6½ hours:

/************************************************************************/
/* Posting Monthly PTO accruals to the dept time off database           */
/* Created by Frank Duck on behalf of Tubby                             */
/* Created on 11 September 2002                                         */
/* dept_post_monthly_pto.sql                                            */
/************************************************************************/

Declare
    @PostedBy int,
    @PeriodEarned smalldatetime,
    @Employee int
select
    @PeriodEarned = '09/30/02', -- ENTER the date of the month you're posting time for
    @PostedBy = 98289 -- 98289 used to indicate system functions for the TimeOff db

select EmplId from tbl_Employee where EmplId > 2000 and EmplId < 99999 and Status = 'Active'

/*set -- commented out... it no workie
    @Employee */

insert into tbl_Request (EmpId,Date,TimeType,Comments,RptHR,DateCreated,Hours,Editor)
    values(1935,@PeriodEarned,'PTO','Accrual',1,getdate(),14,@PostedBy)

insert into tbl_Request (EmpId,Date,TimeType,Comments,RptHR,DateCreated,Hours,Editor)
    values(@Employee,@PeriodEarned,'PTO','Accrual',1,getdate(),10,@PostedBy)

In the second insert, the objective is to get the 10 records (for example) that met the criteria of being between 2000 and 99999, and then insert one row for each of those ten records into the tbl_Request, so the process would create a total of 11 new rows (the first insert on 1935, and then the 10 results of the second select statement.  

Yes, it made my head explode, too.  HTML, now that makes sense.