Lukket

Create a Custom SQL Server for Checking and deleting

Hi, The code what i need is Simple:

1. I have two tables called as Sequence and the Newsfeed

The newsfeed PK ID is the key which also exists in the sequence table and sequence is stored in newsfeed table,

even the sequence table has the sorting order too but that s not used.

now what i am trying is:

select * from newsfeed where id in (select fk from sequence where pkid = 1000) - if the internal sub query has some records it will give me a some values maybe 5 or 10 records or sometime 1 and if it does not have any record it will return me nothing, now if it returns me nothing, i will do another query which is like this select * from newsfeed where id = 1000 and it will return me the value

then based upon o am getting the sortorder of the id from the newsfeed table.

and then it gives me the record of that table with sortorder

here comes the tricky part:

sortorder: ID

25 5252

26 5255

i am deleting the 5252 record and that 5252 sortorder is 25 so i am deleting 25 and then before 25 its 24 and after 35 it is 26

so what i want s the sorting f the records which are after the deleted records:

so it will be like this;

sortorder: ID

25 5252 - because this has been deleted

25 5255

and so on

so the sequence will be have to fixed.

i showed an example of 1 record but if there are more records then that needs to be fixed too,

anyone who bids please understand this structure because this is what i have to do, a udf or single query or stored proc will work here

Thanks

Max i can pay is $15 Canadian Dollars

Evner: Microsoft SQL Server, SQL

Se mere: sql check constraint examples, sql server alias not working, insert update delete in asp.net using sql server, sql server database alias, sql server create alias, sql server check constraint expression, check constraint sql server, sql check constraint multiple values, create invoice sql server 2005, create custom installer sql server, dynamically read excel create table sql server, create table sql server using, create table sql server generator, create table sql server, create form sql server

Om arbejdsgiveren:
( 10 bedømmelser ) Winnipeg, India

Projekt ID: #17213367

23 freelancere byder i gennemsnit $24 på dette job

$45 CAD på 1 dag
(14 bedømmelser)
4.1
vw7590795vw

Please message me and send me some sample data. Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 8 years and 6 months experience in SQL Server. Please let me know more details and when Flere

$14 CAD på 1 dag
(21 bedømmelser)
4.0
yubor

hi, I have deep knowledge in sql development and certified as expert (mcse: data platform).

$15 CAD på 1 dag
(19 bedømmelser)
3.8
$24 CAD in 3 dage
(7 bedømmelser)
3.3
AntonBliznetc

Hello I can do that in less 2 hours. Task more for reviews. Result 1 QUERY. Thank. ____________________

$15 CAD in 0 dage
(8 bedømmelser)
2.4
jmcdador

I have sufficient experience in SQL Relevant Skills and Experience Oracle PL/SQL MySQL SQL Server

$20 CAD på 1 dag
(0 bedømmelser)
0.0
mohdmujtabaali

Hi! We can work further also. I am full time sql developer in 1 erp vendor company in hyderabad India. I have more than 6 years of experience working on sql. Regards, Mujtaba. Whatsapp; +919032805349 Relevant Skills Flere

$15 CAD på 1 dag
(0 bedømmelser)
0.0
$25 CAD in 2 dage
(0 bedømmelser)
0.0
jackvera

Good Morning, I need more information about the process you make, maybe by skype you can show me to mke a better construction. basically, the process has two elements, the one you describe and a LOG of process. I going Flere

$138 CAD in 3 dage
(0 bedømmelser)
0.0
$25 CAD på 1 dag
(0 bedømmelser)
0.0
$25 CAD på 1 dag
(0 bedømmelser)
0.0
ohmygolly

You need a trigger that fires after delete row which updates then every subsequent row. I'll do it in one day

$15 CAD på 1 dag
(0 bedømmelser)
0.0
$25 CAD på 1 dag
(0 bedømmelser)
0.0
$20 CAD in 3 dage
(0 bedømmelser)
0.0
dkjain1406

I am new at freelancer.in but I have many years of experience in SQL Server. Written many complex queries. To be more flexible, I would like to write stored procedure here . in your example: "i am deleting the 52 Flere

$15 CAD in 2 dage
(0 bedømmelser)
0.0
$20 CAD in 5 dage
(0 bedømmelser)
0.0
$10 CAD in 5 dage
(0 bedømmelser)
0.0
sergimoreno1993

Indicate the type of database to generate a code that does what you want. In principle it would be an automation to perform the regularization by itself, in case it can not be regularized only by the database, it would Flere

$20 CAD in 10 dage
(0 bedømmelser)
0.0
TeamEcho

Hey, Here my linked [login to view URL] i'm located in Toronto if you want to get in touch personally

$15 CAD på 1 dag
(0 bedømmelser)
0.0
$10 CAD in 2 dage
(0 bedømmelser)
0.0