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. INSERT INTO [dbo].[tblVehicleType2] ([ChassisNumber]) SELECT FLOOR(RAND() * POWER( CAST (10 as BIGINT ), 9)) Any help is hightly appreciated. Thanks in advance.

Hello, For insertion every 30 days, I suggest you to create job. https://www.c-sharpcorner.com/UploadFile/raj1979/create-and-schedule-a-job-in-sql-server-2008/ Go through the above link

Thanks Piyush and Madan for your response. I did it in the backend of my application. private void InsertNewLicense() { DateTime datecreated; JesapDataAccess date = new JesapDataAccess(); datecreated = date.GetLicenseCreatedDate(); string licenseCreated = datecreated.ToString(); string today = DateTime.Now.ToString(); int LicenseCreated = Libraries.DayNum(today, licenseCreated); if (LicenseCreated >= 30) { JesapDataAccess.InsertNewLicense(); } }

For this you have to create web jobs .

Answers

Insert Random Number To Table Every 30 Days

Jes Sie

603

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.

INSERT INTO [dbo].[tblVehicleType2]
([ChassisNumber])
SELECT FLOOR(RAND() * POWER(CAST(10 as BIGINT), 9))

Any help is hightly appreciated. Thanks in advance.

Answers (3)

Next Recommended Forum

Regex Password for 8 chars

custom authorization mvc

Forum Statistics

Please welcome our newest member Abhishek Yadav.
3,089,464 users have contributed to 147,411 threads and 483,549
In the past 24 hours, we have 4 new threads, 11 new posts, and 142 new users.
In last week, the most popular thread is 'what is Pandas how to use?'.

Upcoming Events

View all

Vibe Coding Bootcamp
Software Architecture Conference - 2025
AI Agents Conference - 2025