Edit Code sql server simple
$10-30 USD
Paid on delivery
I want
Edit Code
When inserting the date
I want a difference of 30 seconds
Increases 30 seconds per row
sql server 2014
---------------------------------------------------------------------
INSERT INTO [SMS].[DBO].[Out] (MessageTo, MessageText, MessageType,Gateway,UserId,Scheduled )
SELECT ('hhh'+ Mobile) as MessageTo , ('hhf' + ' ' + '( '+ Actual_Balance +' )' + ' ' + 'hhff ') as MessageText, '[login to view URL]', 'COM64' , Act_Code ,DATEADD(second,(rand()*60+1), DATEADD(minute,(rand()*20+1) , getdate()))
FROM [SASDbforme2018hdedh].[DBO].[Account] where Eng_Name like '1'
-----------------------------------------------------------------------------------------------
Project ID: #16339232
About the project
Awarded to:
Hi I can solve this right now for you, Your SQL CODE is adding a Random seconds that goes from 1 to 60, you want to change that to always 30 seconds. That's it?
6 freelancers are bidding on average $27 for this job
Greeting, I have understood your Edit Code sql server task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in SQL
Dear Hiring Manager I can finish immediately. Looking for a creative and knowledgeable Web Developer? Search no further, because I am ready for the job. With 5 years of web development experience for global business More