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

571

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

Leaderboard

View all

Netaji Junghari

+79

George

Lokendra Singh

-1

View all

Yesterday's leader

Netaji Junghari

Bangalore (India)

897

103.8k

852

Member of the month

Shafaet Hossain

C#, .NET, ASP.NET, Blazor

Dhaka (Bangladesh)

711

9.7k

1.3k

Speaker of the month

Shubhankar Banerjee

Blockchain, Solidity, Polygon, C#, NodeJS, HTML, C Language, C++, JavaScript, CSS, ReactJS, MySQL

Kanpur (India)

156

117.7k

11.8k

500

Upcoming events

View all

Suggested for you

View all

Adriancs

Sandeep Mishra

Pradeep Sahoo

Aakash Chhillar

Habibul Rehman

Forum Statistics

Please welcome our newest member Adarsh Manepalli.
3,078,351 users have contributed to 147,418 threads and 483,404
In the past 24 hours, we have 4 new threads, 21 new posts, and 68 new users.
In last week, the most popular thread is 'Get 24 months rollover value from database'.