SQL statement problem

As the error indicates, there is a primary key field in your table and the table already has a row with value 1000 in the table. Now you are trying to insert another row, with value 1000 in the same field, which SQL will not allow. There is no fix to the SQL statement, giving error is the correct functionality. What needs to be done is to go to the source of the insert statement, and make sure such a row doesn't exists, before issuing the insert statement. Can you please discuss, to understand from where the SQL is issued, and if this is some thing I can fix.

A proposal has not yet been provided

Hi I have been working with MSSQL for over 15 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 the 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, Nice to meet you. I am Manh from vietnam. I have 8 years experience in Software development. I am very good at SQL. I understand your requirements and very interested in your project. Please feel free contact me. We can discuss further on your project. Thank you and have a good day

I can fix this SQL statement violation error problem. I will complete this work in a day. Looking for your reply to start this work immediately.

Hello, I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I am having 6+ years of experience in Web Development. I have worked on below technologies/languages/database server. - Asp.net,C#.net,Asp.net MVC - Linq to SQL,Entity Framework - Javascript,Jquery,KnockoutJS - Crystal Reports,DevExpress Reports - SQL server,SSIS Package,SSRS Reports - Facebook Graph API - Application Security Remediation - SVN,TFS I love working on SQL and query/sp optimization . I can achieve the results that you are asking for. We can discuss further on chat(Skype:mahajan344). Looking forward from your end. PM Thanks Nikhil Mahajan

Hi, I can do the task, just provide me access to the server and let me see the insert statement you are executing Si quieres podemos hablar en español Saludos

This means that primaty key is duplicated, There are couple of resons: 1. multiple rows inserted with one key 2. trying insert new row with existed key I can exam you DB to find issue

A proposal has not yet been provided

This is simple issue to resolve and I can finish the task within no time (less then 30 mins). Let me know when I can start on task.

Hello, Can you send details please to check the issue. I am available to check right now. Regards,

SQL Server DBA with 4+ years of experience, I have expertise in performance tuning, index building, constraints checking. I would still request you to please share the remote details, so that I can work on this immediately and help you solve this issue. Thanks

Hello Sir/Madam I have solid experience as Oracle, SQL Server, Sybase, Access DBA. I am SQL server certified DBA in both as DBA and Designer. I worked as DBA in USA for 13 years. I came back recently to start my own work. I have a number of excellent reference as DBA, Architect and Modeler. Please take a look at my resume and you will find that I am the best fit for this job. I have just completed couple of projects on database and the clients were from Australia, Canada, GB, USA and Russia. Currently I am working on a USA project Please see the review. Appreciate your kind attention in this regard, Warm regards,

Hi There, My name is Au. I have been working with SQL more than 5 years. I wish have chance to assist you with this work. Thank you so much for your consideration me. Best Regards, AU

A proposal has not yet been provided

Dear Sir, I am having 8+ Years of experience and can serve your requirement with ease and will provide you the robust solution and services even after successful release, so requesting to kindly consider my bid for further discussion. 10$ only .......... where i can get only 5$.

Hi, I can help you solve the issue as I have 13+ years of experience in sql development. please share me further details regards Babu

La propuesta todavía no ha sido proveída

I can solve this is 5 min, as I am very good ins ql server, Let's chat an solve this, I am working on sql server from last 6 year. Issue description - there is already a item in table with id 1000

Hi, i'm SQL expert and i could help you in this problem. For this i need the database and the exact error displayed.