Database

What all I have to check for access permissions. I am using an Online DB and my application is a Windows application in VB6. I have checked the remote connection property of my SQL Server and it is ok. Then i also checked the DB name and connection string (given by the hosting site) and found no errors. Can u pls help me to find out a solution. Thanks for your quick reply

HI pls try below code Select C1, C2, C3, C4, case when (C1 + C2) = (C3 + C4) then 'Match' else 'Unmatch' end as Result From ( Select Row, Max(C1) as C1, Max(C2) as C2, Max(C3) as C3 , Max(C4) as C4 From ( Select ROW\_NUMBER() OVER (ORDER BY TABLE\_A.Field\_1) AS Row, TABLE\_A.Field\_1 as C1 ,TABLE\_A.Field\_2 as C2 ,'0' as C3 ,'0' as C4 From TABLE\_A Union ALL Select ROW\_NUMBER() OVER (ORDER BY TABLE\_B.Field\_1) AS Row, '0' as C1 ,'0' as C2 ,TABLE\_B.Field\_1 as C3 ,TABLE\_B.Field\_2 as C4 From TABLE\_B ) as OuterTable group by Row ) as FinalTable n yes let me know which sql version u r using because in sql 2008 we have merge statement too... i hope this will help you .. Reasons are not Important but Results are Important. http://www.sql4professional.blogspot.com Swati Tripathi

And if that fails: http://tinyurl.com/2wbzbr3[^] CQ de W5ALT Walt Fair, Jr., P. E. Comport Computing Specializing in Technical Engineering Software

XML is good for configuration. If you are concerned about it growing large, then I doubt it is configuration. If you need a database, then try to be as database agnostic as you can be so different clients can use different databases -- make it configurable.

The data types being indexed does not have impact on the size used to store the indexes. What you described indicates even more indexing is needed for the database table since some simple "select" queries are very slow. You may need to remove some indexes not being used by the program and add some new indexes based on the queries frequently conducted. When the needed index does not exist, "select" queries on such large tables will be very slow. I was once amazed by how much performance gains was brought by adding proper indexes when I was working on a large database table (similar to your case). So it may worth a try to get a close look at the database to find out what you need for it.

yep, Google is American, and very NTSC at that, Never The Same Content. As is most of the internet. :laugh: Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] I only read formatted code with indentation, so please use PRE tags for code snippets. I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page).

Cross-post, answers go here[^] :) I are Troll :suss:

You can get the SQL Server Compact runtime from http://www.microsoft.com/downloads/details.aspx?familyid=85e0c3ce-3fa1-453a-8ce9-af6ca20946c3&displaylang=en[^]. There's a readme file on that page, but I think you just need to run the installer -- that's all I did for our platforms here. Dave ---- Data Exploration and Data Profiling Tools

padmanabhan N wrote: i have to update only A with B... If that`s the case then simply update columnA with columnB eg: update mytable set mytable.columnA=mytable.columnB where ..... When you fail to plan, you are planning to fail.

with Account(AccountID) As ( select AccountID from Accounts A where AccountID = #AcountNumber# union all select A.AccountID from Accounts A, Account B where A.ParentAccountID = B.AccountID ) SELECT sum(totaldebit) TotalDebit FROM Account, AccountsBalance where Account.AccountID = AccountsBalance.AccountID replace #AcountNumber# with your account number (probably use variable/parameter). Hope this will help you :cool:

hi , sir iam waiting for your reply

You might also want to look at an outer join. I wrote something about this a while back: http://www.citrustechnology.com/blog/20100113

I was sitting out on my porch having lunch when I realized what your problem may be. I remember there was a property (don't know it right now .. you'll have to search for the obvious in your XAML) which was basically binding to an event to tell the control when to rebind it's data. You need to find that property and bind it to the combobox SelectionChanged event.

Since CDOSYS is a builtin tool in ASP.NET, you may be more likely to get an answer in the ASP.NET forum instead of the SQL Forum.

Thank your, I will give it a try in the Visual Basic forum. I could not find a VS-forum. Guess you meant the VB-forum.

That sorted it out alright. Thanks very much.

I can only confirm that I currently run it on XP (SP3) but it has been on my system since the release of XP. So XP, XP (SP1), XP (SP2) are also all OK. Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”

I had an old boss who swore by this route, in favour of my NOT IN solution above. He said it was much more efficient. He was right, and I forgot about that whole conversation till I saw your answer.

May be of some use. We have recently released a Free tool to check conection strings. It won't debug the TCP/IP stream, but will help you see the database at the other end. http://www.citrustechnology.com/product/data-provider-explorer