Home Forums SQL Server 2005 SQL Server 2005 General Discussion TSQL copy data in weekdays RE: TSQL copy data in weekdays
zhtway
Old Hand
Points: 325
More actions
August 21, 2010 at 4:16 am
#1210006
Hi,
I have just tested with SQL Agent.
I don't know how to retrieve date from Holiday table.
use testDB
Insert into Pickup (StaffID, RouteID, PickupDate)
select StaffID, RouteID, (getdate()) from Routes