We are in the process of stress testing our application which uses postgres db (8.0 on windows XP) as the back-end. The application is j2ee based and uses the connection pool facility of jboss.
The DB log consistently reports the following error after 3 min of stress (50 db calls/sec -...
hi,
I think may be you should consider having a 'Clustered Index' on this field. That way the data could be ordered and stored in the table. What's more it also maintains an index.
hi there,
I think what you may be looking for is a 'CASE' statement inside the SQL.
Lets assume 'Income' and 'Expenditure' are columns and 'Balance' is a computed column.
Its value is equal to (Income - Expenditure) and is always a number or NA ie 'Not Available'.
Your Query will go something...
I too faced the same problem. But fortunately the value is truncated only when displaying on the 'Query Analyzer'.
When the same query is run through an application like 'asp', the results appear as expected(without any truncation).
Shyam
I too faced the same problem. But fortunately thew value is truncated only when displaying on the 'Query Analyzer'.
When the same query is run through an application like 'asp', the results appear as expected(without any truncation).
Shyam
hi bob,
I was just wondering and very curious as to what could be the requirement wherein the same field in tab2 had to be a foreign Key to two tables tab1 and tab3.
Ideally for a look-up detail relationship,
if both tab2 and tab3 are details, they should have had their corresponding fields...
hi there,
i think malcom has given us a great and efficient solution to reorder records.
i will just list it out once again for your reference.
declare @variable int
set @variable = 5
update project_fund_allocation
SET @variable = year = @variable + 1
The @variable will be the seed value...
I will use an example and try to explain how to work around this problem. It works.
It is called building perspectives from a table. It is also called building cross tabs from a table.
Assume the following table
Investors_ Table
Investor_ID[tab]Year[tab] Amount...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.