Search results for query: *

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 -...

Why not delete all rows from tbl1 and then ... 'Insert into tbl1 select * from tbl2'. since they seem to have the same structures.

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...