Find Jobs
Hire Freelancers

edit this code sql server 2014

$10-30 USD

Completed
Posted about 6 years ago

$10-30 USD

Paid on delivery
I have code sql server I want to modify it to be simple and fast It works continuously and does not stop 1-If the condition is not met Return to condition check again 2-If the check condition is correct - go to Next 3-When you finish code Return to first condition check again delete from [SMS].[DBO].[M_Out] MERGE [SMS].[DBO].[M_Link] USING ( SELECT * FROM [SMS].[DBO].[M_Log] RIGHT JOIN [SMS].[DBO].[M_Link] On [login to view URL] = M_Link.link_UserId where Id >= 0 and log_Id IS NULL ) as sdjj ON[SMS].[DBO].[M_Link].link_UserId = UserId WHEN MATCHED THEN UPDATE SET link_check = case when [login to view URL] >=1 then '1' else 0 end ,log_StatusCode = StatusCode ,log_Id = Id ; WAITFOR DELAY '00:00:01' MERGE [SMS].[DBO].[M_Link] USING ( SELECT * FROM [SMS].[DBO].[M_In] RIGHT JOIN [SMS].[DBO].[M_Link] On [login to view URL] = M_Link.link_UserId where Id >= 0 and In_id IS NULL and link_Status IS NULL ) as fgfgf ON[SMS].[DBO].[M_Link].link_UserId = UserId WHEN MATCHED THEN UPDATE SET link_Status = case when MessageText like '%رصيد%' or MessageText like '%لديك%' then '1' else 0 end , In_id = Id ,Reply_Message = MessageText ,Reply_SendTime = SendTime ,Reply_ReceiveTime = ReceiveTime ,Reply_UserId = UserId ; WITH CTE AS( SELECT [link_MessageTo], [link_Gateway], [link_UserId], RN = ROW_NUMBER()OVER(PARTITION BY link_UserId ORDER BY link_UserId) FROM [SMS].[DBO].[M_Link] ) DELETE FROM CTE WHERE RN > 1 delete from [SMS].[DBO].[M_Out] if not exists ( select top 1 1 from sms.dbo.m_link where link_check = 0 )RETURN WAITFOR DELAY '00:00:05' INSERT INTO sms.dbo.M_Out (MessageTo ,MessageType ,Gateway ,UserId) select top 1 1 link_MessageTo ,link_MessageType ,link_Gateway ,link_UserId from sms.dbo.m_link where link_check = 0 WAITFOR DELAY '00:00:10' MERGE [SMS].[DBO].[M_Link] USING ( SELECT * FROM [SMS].[DBO].[M_Log] RIGHT JOIN [SMS].[DBO].[M_Link] On [login to view URL] = M_Link.link_UserId where Id >= 0 and log_Id IS NULL ) as sdjj ON[SMS].[DBO].[M_Link].link_UserId = UserId WHEN MATCHED THEN UPDATE SET link_check = case when [login to view URL] >=1 then '1' else 0 end ,log_StatusCode = StatusCode ,log_Id = Id ; WAITFOR DELAY '00:00:15' MERGE [SMS].[DBO].[M_Link] USING ( SELECT * FROM [SMS].[DBO].[M_In] RIGHT JOIN [SMS].[DBO].[M_Link] On [login to view URL] = M_Link.link_UserId where Id >= 0 and In_id IS NULL and link_Status IS NULL ) as fgfgf ON[SMS].[DBO].[M_Link].link_UserId = UserId WHEN MATCHED THEN UPDATE SET link_Status = case when MessageText like '%رصيد%' or MessageText like '%لديك%' then '1' else 0 end , In_id = Id ,Reply_Message = MessageText ,Reply_SendTime = SendTime ,Reply_ReceiveTime = ReceiveTime ,Reply_UserId = UserId ; delete from [SMS].[DBO].[M_Out]
Project ID: 13598144

About the project

1 proposal
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
I am having more than 8 years of experience in IT industry.I have worked on .net(c#.net,vb.net,asp,asp.net,mvc) with sql server 2005/2008/2012/2014/2016 and oracle(pl/sql). I can provide you better solution by utilizing my knowledge and skills.
$50 USD in 2 days
4.9 (25 reviews)
4.7
4.7

About the client

Flag of YEMEN
taiz, Yemen
5.0
2
Payment method verified
Member since Mar 28, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.