|
i.j.russell wrote: Has it only just started happening as you say that the code is 5 years old?
Well it appears that on the development server the primary key exists, but on the rest of the servers(staging, QA, and production) it has either been deleted or never published. Probably it wasn't working in a roll-out and never got put back in.
i.j.russell wrote: Does it always cause a PK violation?
Always. They have managed to get the row inserted with the violation. Since The stored procedure calls another stored procedure to do the actual insert
i.j.russell wrote: Are you only inserting into 1 table?
Yes
i.j.russell wrote: Are all of the datetime values obtained from the same source?
Yes, there is a GetDate() inside the insert statement.
i.j.russell wrote: Is the datetime value different for each insert?
We have waited from 15 seconds to a few minutes and we always get the issue.
I realize, like everyone else, that this isn't advisable but this method seems to be carved in stone. Since I recommend an int column and they tell me that can't be the problem. If the world was a best case scenario, we probably wouldn't have a job to go to.
If you can tell me why this is bugging out when I'm not violating the date millisecond issue.
The PK is has 7 columns in it. Each isd an int field and thier exactly the same except for the GetDate() column, which is at the end
-- modified at 17:06 Thursday 17th August, 2006
--------------------------------------------------------
1 line of code equals many bugs. So don't write any!!
My mad coder blog
|
|
|
|
|
Well I thank you for trying to help.
The problem actually was that we had bad test data. It tried to update many rows and couldn't and somehow forced at PK issue.
Odd.
It works fine now. And they seems to think its okay to keep it datetime. I guess once a customer calls in they will want to change it.
Thanks.
--------------------------------------------------------
1 line of code equals many bugs. So don't write any!!
My mad coder blog
|
|
|
|
|
create table MyTable
(
MyCol datetime
PRIMARY KEY CLUSTERED
)
insert into MyTable (MyCol) values ('2006-08-17 15:36:13.779')
The value is rounded to '2006-08-17 15:36:13.780'
insert into MyTable (MyCol) values ('2006-08-17 15:36:13.781')
the value is rounded to '2006-08-17 15:36:13.780'
Strange...not sure why this is. No time to research right now. But, this may be what is causing the primary key violation.
--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters
|
|
|
|
|
yeah every 3 milliseconds is treated as the same number.
I found tons of documents at MSDN for it
--------------------------------------------------------
1 line of code equals many bugs. So don't write any!!
My mad coder blog
|
|
|
|
|
What are the exact times that are causing problems in your table?
--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters
|
|
|
|
|
I want to get the rows having non-repeated values.
E.g if we have 4 rows having data
12
9
13
12
then result set should be 9 and 13.
Do good and have good.
|
|
|
|
|
select a.col1 from
(
select distinct col1, count (col1) as Repeated from
dbo.YourTable group by col1
) a
where a.Repeated < 2
how vital enterprise application are for proactive organizations leveraging collective synergy to think outside the box and formulate their key objectives into a win-win game plan with a quality-driven approach that focuses on empowering key players to drive-up their core competencies and increase expectations with an all-around initiative to drive up the bottom-line. But of course, that's all a "high level" overview of things
--thedailywtf 3/21/06
|
|
|
|
|
Thanks for ur reply. ............it is working....
Do good and have good.
|
|
|
|
|
SELECT MyColumn
FROM MyTable
GROUP BY MyColumn
HAVING COUNT(*) < 2
|
|
|
|
|
Hi there,
I need to read data from a excel spreadsheet, show on a webpage and insert into a sql server 2005 database. Need to do it in asp.net 2.0, using ado.net and VB(or C# samples will also help).
Can anyone point me to the right place?
|
|
|
|
|
Do you have a standard format for the spreadsheet you are reading? If so you can execute a SQL DTS package and read the data via ado.net.
how vital enterprise application are for proactive organizations leveraging collective synergy to think outside the box and formulate their key objectives into a win-win game plan with a quality-driven approach that focuses on empowering key players to drive-up their core competencies and increase expectations with an all-around initiative to drive up the bottom-line. But of course, that's all a "high level" overview of things
--thedailywtf 3/21/06
|
|
|
|
|
Hi,
Is it possible to connect to a MySQL databse with c# asp.net without having to install anything extra to mysql?
I think MySQLDirect.NET is what im looking for but its not free, is there a free alternative to this? I don't need all the bells and whistles just something that I can use to connect with, do lookups and send commands.
Basically I just want to access the database using built in fuction of .net if possible, or if not some class that I could include, as i don't have direct access to the server it will be on so won't be able to install extras.
Hope that makes sence
Thanks in advance
|
|
|
|
|
u can download mysql.net connector from mysql.com. after that add its reference to yr project. then u can use it as u use SqlClient or OracleClient namespaces.
|
|
|
|
|
|
Try this for your connection string:
string conString = "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=C:\myDB.mdb;"
Steve
|
|
|
|
|
Hi every body i need to know how to do one think.So i have to table one is Employer other is customerEmployer.Employer have idEmployer,name.CustomerEmployer have idemplpoyer and idcustomer.
SO my question is please give me query who give it to me employer.name with max customet how to do that???
N.Nikolov
best regards
when i want to read something good just seat and type it
|
|
|
|
|
Your tables are:
Employer
--------
IdEmployer
Name
CustomerEmployer
----------------
IdEmployer
IdCustomer
This describes two thirds of a many-to-many join. The missing information is likely to be
Customer
--------
IdCustomer
{other columns}
papa80 wrote: SO my question is please give me query who give it to me employer.name with max customet how to do that???
What do you mean by max customer? What is a max customer? What defines the customer as being the max?
If you mean the MAX(IdCustomer) then:
SELECT Employer.Name
FROM Employer
INNER JOIN CustomerEmployer ON CustomerEmployer.IdEmployer = Employer.IdEmployer
WHERE IdCustomer = (SELECT MAX(IdCustomer) FROM CustomerEmployer)
|
|
|
|
|
is my bad.Ok i need to show employer.name with max number of customeres do you know how will look now that query???
when i want to read something good just seat and type it
|
|
|
|
|
SELECT Employer.Name, CustomerCount.NumCustomers
FROM Employer
INNER JOIN (SELECT IdEmployer, COUNT(*) AS NumCustomers
FROM CustomerEmployer) AS CustomerCount
ON CustomerCount.IdEmployer = Employer.IdEmployer
|
|
|
|
|
that is give me error
Msg 8120, Level 16, State 1, Line 25
Column NumCustomers is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
how to solv it??
when i want to read something good just seat and type it
|
|
|
|
|
Colin Angus Mackay wrote: SELECT Employer.Name, CustomerCount.NumCustomersFROM EmployerINNER JOIN (SELECT IdEmployer, COUNT(*) AS NumCustomers FROM CustomerEmployer) AS CustomerCountON CustomerCount.IdEmployer = Employer.IdEmployer
You need to add ORDER BY CustomerCount.NumCustomers DESC to give you the maximum first. To get only the maximum, use SELECT TOP 1 Employer.Name, etc.
SELECT TOP 1 Employer.[Name], CustomerCount.NumCustomers
FROM Employer INNER JOIN (SELECT IdEmployer, COUNT(*) AS NumCustomers
FROM CustomerEmployer
GROUP BY IdEmployer) AS CustomerCount
ON CustomerCount.IdEmployer = Employer.IdEmployer
ORDER BY CustomerCount.NumCustomers DESC
Ian
-- modified at 9:26 Thursday 17th August, 2006
|
|
|
|
|
Thank you very much.That is what i need.This code is great.
when i want to read something good just seat and type it
|
|
|
|
|
can anyone pls say in what kind of a scenario can i go for System.Data.Oledb and System.Data.Odbc. Is there any difference in their performance. will it suit well for Oracle.
-----------------------------------------------------------------
where there is a will there is a way
|
|
|
|
|
There is a specific Oracle provider that you can use. You should use the most specific provider for your database rather than one of the generic providers such as Odbc or OleDb
|
|
|
|
|
Hi guys,
Good Day!
My back-end in my system is MS SQL SERVER, the major scenerios here are, it performs weekly autoupdate for the database and the data is so huge.. then, evrytime its updating the transaction log is occupying more space in the drive and encounters error if i set it to restrict file growth or in uncheck automatically file growth (it says that i need to set more size for the transaction logs or else it will not perform)..
My problem here is how can i delete the tranasaction logs automatically or limit the size without encounter the error everytime i update the database, since my system does not need that?
Hope your response, guys... Thank you in advance....
regards,
JayR
|
|
|
|