SQL Script - Resequence ID/ParentID in a Tree Table

Hi I have been working with MSSQL for over 17 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have designed and the Developed the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2 Enterprise Edition. The database is being updated daily from the core system with txt or excel files via SSIS or with direct connection at mainframe’s DB2 and a numerous of KPIS are being daily updated during the ETL. For isolation reasons the KPIS are replicated to another DB (with transactional replication) which exploits dashboards via Power BI and reports via SSRS to the consumers. Some KPIS are being replicated with merged (bidirectional) replication. Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL. Several other reports are daily automatically produced and sent via email to the recipients. Finally I have designed and developed the bank’s crm DB which is published on the intranet. The DB holds full information about the customers (Customers,Addresses , Financial Data , Contacts , campaigns , etc) and covers 4 countries. To achieve this i have made partitions over the country code. The size of the Reporting DB, is about 4TB and consists of about 4.000 objects and the replicated KPI DB is 350GB. Best Regards mpalgeo

Hello, I am a Microsoft Certified Solutions Master: SQL Server (on-premise and Azure). I am a SQL Server Consultant working as a Developer and DBA, I have had 14 years experience with on-premise and 3 years experience with Azure. I have experience with many companies large (particularly large government departments with 100,000+ users). If you have any questions let me know.

Hello, I have read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I am having 8+ years of experience in Web Development. I have worked on below technologies/languages/database server. - Asp.net,C#.net, MVC - Linq to SQL,Entity Framework - Jquery,AngularJS,NodeJS - Crystal Reports,DevExpress Reports - SQL server,SSIS Package,SSRS Reports - Web API 2, WCF Rest WebService - Application Security Remediation - Penetration Testing - OWASP 10 - SVN,TFS,Git I love working on SQL and query/sp optimization . I can achieve the results that you are looking for. We can discuss further on chat. Looking forward from your end. Thanks

Hi I am a database expert with 12 years experience in handling MS SQL databases. I have worked as DBA for large ERP databases and use to write and do performance tuning for SQL queries, procedures and triggers. For this case I can create a stored procedure for you, which you can run periodically to resequence the ID and Parent ID as and when required. Once I have the details, I can either connect on team viewer to you server and work there, or setup the tables on my database and send you the final script alone. Look forward to hear from you. Thanks Roni

Hello, I'm sql server expert and have passed all three exams here in freelancers. I am surely can do this reorder script for you . Please share the details with me so that I could start thanks

Please review my profile. I have 7.4 years experience in SQL and 4.7 years experience in SSRS, SSIS. Please let me know more details and when we will start. Sky pe jikenjd

A proposal has not yet been provided

A proposal has not yet been provided

Greetings, I'm professional database expert with 9+ years experience. Currently I'm working as DBA and DB developer in one of the leader company. As you can see in my profile, I have deep experience of same jobs like database administration and development by remotely. I'm top expert. -- Best regards, Davit Dartsimelia Senior Database Administrator & Developer

I have been working with MS SQL for over 6 years. I have created complex scripts as per client requirement. I should be able to help you with your requirement.

Bid Summary SQL queries with MS SQL server Project Requirements SQL queries with MS SQL server Relevant Skills and Experience computer programming, SQL programming, MS access programming Proposed Milestones $100 USD - completion

strong ms sql development skills having worked on various clients due to main career in the IT consulting space... experience with sql 2005,2008,2008r2,2012,ssis,ssrs,queries,views,triggers,procedures,cursors,scripts

Hi, I have 15+ years experience in SQL in database platforms such as MSSQL and Sybase ASE. is both id and parentid in the same table or different tables? how big (number of rows) is the table? is it ok if table is locked and all rows get updated in a single transaction and this would depend upon number of rows. regards Babu

Hi, I'm a french software engineer, and I worked for 10 years for compagnies, as well as MySQL and SQL Server databases. Now I'm a freelancer. For your project, I am available from now, and for the time you want. If you have any questions do not hesitate to contact me. Best Regards.

This can be a great opportunity both for you and me - I get my first review and start building my reputation; you get highest-quality work done for less money since currently I need reputation more than I need money. I am extremely experienced SQL developer who is all about outstanding performance and quality. Regards, Kaloyana Manova

I have 5 years of experience in SQL database and performance optimisation.

A proposal has not yet been provided

A proposal has not yet been provided

A proposal has not yet been provided

A proposal has not yet been provided