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'
-----------------------------------------------------------------------------------------------
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?
$20 USD Om 1 dag
5,0 (8 omdömen)
4,1
4,1
6 frilansar lägger i genomsnitt anbud på $27 USD för detta uppdrag
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 businesses, I offer the technical expertise you are seeking for your web developer position advertised on this site.
My professional experience includes using programming languages such as HTML, CSS, PHP and JavaScript to create various features for client & admin websites. I also have experience in developing and managing MySQL databases.
As a web developer focused on customer satisfaction, I manage all aspects of web development development, launch, maintenance and user support. I enjoy the client-facing role and working hard to produce high-quality deliverables.
I look forward to meeting with you this week and discussing the details of this position.
Sincerely,
Ethan Ivanov