Database

Select distinct * into newtablename This will put distinct records into a new table, you then need to deal with your problem. I suggest you engage a consultant to design your data structure for you or get a book on database and data design and start learning. Never underestimate the power of human stupidity RAH

That is not a problem. Simply determine which query returns the most columns, and add dummy columns to the other queries, such that each query returns the same amount of columns. use 0 for columns with numerical values, and '' for columns with text values. So for example: SELECT NumericalColumn1, NumericalColumn1, textColumn1 FROM Table1 WHERE blabla UNION ALL SELECT NumericalColumn1, 0, '' FROM Table2 WHERE blabla UNION ALL SELECT 0, 0, textColumn1 FROM Table3 WHERE blabla My advice is free, and you may get what you paid for.

Your logic must be really really really complex, if it can not be translated to a WHERE clause. However assuming that you are right, you can always at least cut out some part of the records with the WHERE clause. Look at the search logic you have written in your application, find the single largest search parameter, and translate only that to sql. My advice is free, and you may get what you paid for.

You could employ schema to segregate your objects (I don't and think it would be irritating to have to include schema in every query), otherwise you have to live with your decision to apply user level permissions to database objects. I'm curious, do your users access your database direct (SSMS/QA) or only through an application? Never underestimate the power of human stupidity RAH

Yes you can shrink the log file - look for shrink in BOL. If you have changed your logging method from simple to full then that will certainly make a big difference. Never underestimate the power of human stupidity RAH

There should be a 'lib' directory under the folder where the Oracle 9i client is installed. Add that directory to the directories that are searched during linking. :) Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]

If you don't want to use a SQL job, use a scheduled task instead; it is executed outside of the control of the SQLServer Agent Service. Not necessarily pretty, but provides a different level of control. Tim

you are right - (for now) its not important as to which value gets updated. The SQLServer version of the script simply updates the t2.Field with the last found record. So for 'n2' t2.Field1 will always end-up with value 'c' I was looking for an equivalent in ORACLE so that it will always update with the last row found. The actual issue is much bigger and i was looking for a quick-fix without introducing a major change. Looks like we need to address the issue with the current design before spending any further time on this issue, Thanks for your inputs. Cheers Kalyan

You're welcome :)

Nice :) --edit The first argument should be a provider; the name of the server has already been provided as "(local)" - this gets replaced with "Kibrom\SqlDev". Something like below should work; SELECT * INTO #MyTempTable FROM OPENROWSET( 'SQLNCLI', 'Server=(local);Trusted_Connection=yes;', 'Exec [dbo].[C_WEB_sp_RevenueAchievedByShow] 1,2' ) I are Troll :suss: modified on Friday, June 4, 2010 2:35 PM

Tom Deketelaere wrote: I don't know why but I'm in a picky mood today The example shows that picky is what's being trained - since the devil is always in the details :) I are Troll :suss:

Are you trying to use this DSN in a 32-bit application perhaps? I know the language. I've read a book. - _Madmatt

Let me try to rephrase this for you using sentence structure: "I am working with a windows app with sql database and vb. I have created 4 tables: singlecustomer jointcustomer address plotdetails I have created relationships with all 4 tables: singlecustomer related to plotdetails and address jointcustomer related to plotdetails and address I have created the database diagram and it shows all of the relationships. When I drag and drop a sql adapter to configure it, the database relationships don't look right in the query builder. In query builder when I add tables the first time, it shows a relationship. When I cancel it and add tables a second time in a different order, it shows a different relationship" Now, that's what your question looks like with proper sentence structure...however, it still doesn't make a lot of sense.

I think he needs to invert the 'p' to a 'b'. :) Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]

Sorry i posted in wrong forum..

You can use SOUNDEX[^] I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com

That would depend on your schema.

Insurance against insurers denying claims on spurious grounds based on arcane interpretations of small print. :) Regards David R --------------------------------------------------------------- "Every program eventually becomes rococo, and then rubble." - Alan Perlis The only valid measurement of code quality: WTFs/minute.