> Hey guys,
> I need an SQL command to change all of the pay periods.
> like I need to make anyone that has a SBR that is 15 hours set the pay period to quarterly
> and everything else needs to be set to monthly
Try Something like:
Set PayPeriod = "Monthly"
Where Exists (
Select AccountID From SubAccounts
Where SubAccounts.CustomerID = MasterAccounts.CustomerID
AND AccountType = "15 Hours"
Repeat the above changing PayPeriod and AccountType. You can
also change PayPeriod and "Where Not Exists" to get all others,
without changing AccountType.