Jes Sie

Jes Sie

  • 737
  • 1.2k
  • 284.4k

Insert Random Number To Table Every 30 Days

Oct 9 2018 11:51 PM
Hello DBA's, I need your assistance. I need to insert a random numbers (9 numbers) to my table every 30 days. I have a query to generate the random numbers but I don't know how to insert it every 30 days.
 
  1. INSERT INTO [dbo].[tblVehicleType2]  
  2.            ([ChassisNumber])  
  3.        SELECT FLOOR(RAND() * POWER(CAST(10 as BIGINT), 9))  
 
 
Any help is hightly appreciated. Thanks in advance. 

Answers (3)