On 9 Apr, 13:08, "Dan Guzman" <guzma...@[EMAIL PROTECTED]
>
wrote:
> > Any thoughts on a better method?
>
> You can use a CROSS JOIN to insert a row per PinNo as a set. =A0For
exampl=
e:
>
> INSERT INTO tblTimesheetInputDetail
> =A0 =A0 (
> =A0 =A0 fldPinNo,
> =A0 =A0 fldPayrollYear,
> =A0 =A0 fldPayrollWeek,
> =A0 =A0 fldPayrollDate,
> =A0 =A0 fldEntryType
> )
> SELECT
> =A0 =A0 tblBatchTimesheetInputDetail.fldPinNo,
> =A0 =A0 fldPayrollYear,
> =A0 =A0 fldPayrollWeek,
> =A0 =A0 fldPayrollDate,
> =A0 =A0 fldEntryType
> FROM dbo.tblBatchTimesheetInputDetail.fldPinNo
> CROSS JOIN dbo.tblBatchTimesheetPinNos
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVPhttp://weblogs.sqlteam.com/dang/
Superb - thanks very much.
Edward
|
