Database

Wombaticus wrote: Would Connector/NET make a difference? Mostly performance, and a lot of it. Have you read this[^]? Wrong is evil and must be defeated. - Jeff Ello[^]

indian143 wrote: wrote it with a tool. Oh I knew that, no one I know will write joins like that. I was interested in whether Jorgen hand coded the changes, he did and deserves your up vote. Never underestimate the power of human stupidity RAH

The usage of tempdb is highly depend on the queries you run - if you use, for instance, a lot of temporary tables (even local one) it will all go to tempdb... Please read here to understand the usage of tempdb: http://msdn.microsoft.com/en-us/library/ms190768.aspx[^] I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)

Tim Carmichael wrote: While VB 6 may have it issues, I have written and used in production many applications written in VB 6 pulling data from SQL Server without issue. Ditto. I never claimed that VB6 has issues with SQL Server - merely that it existed before Sql 2008. VB6 does not know about Sql2k8, and I doubt that new released Sql versions are tested for backward compatibility for a discontinued product. Tim Carmichael wrote: I suspect it is with the coding, not the underlying foundations. I agree with the first part of this statement, and explained how the underlying foundation can cause this. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

actually I am using workbench and sqlyog for browsing the database. executing insert or delete, ExecuteNonQuery return the expected number of rows to be affected on the console, but when i look on the database the affected rows is not there. even i will execute directly it to workbench or sqlyog i got the same behavior.

You probaly want a JOIN in the FROM part -- JOIN the result_table to temp ON some key you haven't mentioned. You'll never get very far if all you do is follow instructions.

Seeing is believing. try this: http://sqlfiddle.com/#!3/1fa93/13028

I must filter/select every ObjectID with PropertyID=QueryString value and PropertyListValueID=QueryString value Initial structure: +----------+------------+---------------------+ | ObjectID | PropertyID | PropertyListValueID | +----------+------------+---------------------+ | 1828 | 41 | 171 | | 1828 | 41 | 170 | | 1828 | 46 | 184 | | 1828 | 47 | 189 | +----------+------------+---------------------+

Do some research into the MERGE keyword, it caters for this requirement (I think as I have not used it). Programming by error - one of my pet peeves, if this turned up in any of our code reviews the dev would be castigated. Never underestimate the power of human stupidity RAH

If you User id is int then no need to put single query. And in TransTime put single quote instead of # select ID as found from TransLog where UserID=61 and TransType='0' and TransTime ='28-04-14 08:46:46' Sankarsan Parida

You're welcome. :) Best regards, Andrius Leonavicius

avi_dadi2002 wrote: my query is fetching 500 million records Seriously? Try calculating how long that would take at 500 records per second.

Sorry - never read your question properly... (Not sure about DB2) but in any case... Perhaps UNION ALL is what you are looking for. (Columns in both selects must be the same) select p, q, r from XXX5T.MyDB5T.MyTable UNION ALL select p, q, r from XXX5T.MyDB5P.MyTable also see Linked Servers http://msdn.microsoft.com/en-us/library/ms188279.aspx[^]

See Select ... WHERE ...[^]

Check the DAY component of the logout datetime value! Never underestimate the power of human stupidity RAH

As mentioned in the Lounge, remove that setting as it is new to 2014. There are only 10 types of people in the world, those who understand binary and those who don't.