mitchwardrop's Q&A profile

• SQL Server Efficient way than IN statement

  I have two tables JDECurrencyRates and JDE Currency Conversion I want to insert all the records all the records from JDECurrencyRates to JDECurrencyConversion that does not exists in JDECurrencyConversion table. For matching I am to use three keys i.e. FromCurrency, TO Currency and Effdate To achieve this task i wrote the following query INSERT INTO PresentationEurope . dbo . JDECurrencyConversion ( Date , FromCurrency , FromCurrencyDesc , ToCurrency , ToCurrencyDesc , EffDate , FromExchRate , ToExchRate , CreationDatetime , ChangeDatetime ) ( SELECT effdate as date , FromCurrency , FromCurrencyDesc , ToCurrency , ToCurrencyDesc , EffDate , FromExchRate , ToExchRate , GETDATE (), GETDATE () FROM ...Show All

• SQL Server Set date format in SQL?

  Hello, I have a column heading called Date, & I want to set the date format to 'mm/dd/yyyy', how do I set it so that all the date will display in this format: mm/dd/yyyy Thanks How a datetime column is displayed is controled by the client rather then the SQL Server. SQL Server stores the datetime in a format-neutrual way so that it can be easily converted to different format. So the question really is what kind of application are you using to access the datetime column For an ASP.NET application, you can easily set the format string to control how datetime is displayed. ...Show All

• SQL Server Private NIC Duplex Settings

  Hi All, Are there any issues with configuring the Private adapter of a SQL 2000 SP4 Cluster for 1Gig/Full (HP DL380 G4) I am using a standard cross cable to connect the NICs. Additionally they are being teamed with HP Network Config utility for network fault tolerance. I know best practice states not to team private adapter but it is set for NFT, is this OK Thanks, T ...Show All

• SQL Server Log File Filling Up

  We have a 1gig log file that is filling up in about 20 minutes. We really don't have your typical DBA's. I am a developer and I am trying to figure out why it is filling up so fast. The last thing I have done to try and see where the problem is to run a trace file. I 'think' I was able to have the trace on when the log file filled up again. However, I'm not really sure what to look for or what is causing this problem. Can someone please help I'm running Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4) We have lots of apps going against the DB (front-end, batch processes, etc). However, the acting ...Show All

• SQL Server SELECT Syntax question

  Hi, Simple question: Is there any way to write this in a shorter form: SELECT fcol like 'X' or fcol like 'Y' or fcol like 'Z' Maybe something like (which I know it won't work but just to give you an idea what I am looking for) SELECT fcol like ('X' or 'Y' or 'Z') I know of this (Full query), but it doesn't work with WILD card characters select ftype from engecnentries where ftype in ('%cone%','%basin%') any ideas If you pass the list of values as a comma-separated string for example you can parse the individual values using an inline TVF or non-inline TVF and use query below: select e.ftype from engecnentries as e where exists(select * from splitstr(@searchvalues) as s whe ...Show All

• Architecture SOA - Transaction/compensation/cordination

  I have a challange. I have multiple services that are located on different server setups. They are build stateless N-tier architectures based on single call remoting. The services do not support the flow of transactions. This would also couple the services an go against the very idea of service orientation. But ..nevertheless, one needs to perform business operations that span multiple services. How do I best support this. Should I have the programmers do custom compensation code very time (clean-up) and accept that if something crashes the data is inconsistant or should I try to find/implement some kind of common cordination What are my choices There are several alt ...Show All

• Windows Forms datagrid column headers fire the click event

  VS 2003 I have a datagrid, and on the click event I process the selected row. You click the selector on the left side of the row. If you click any of the column headings, the click event fires for the row that currently has the focus. So if you are just trying to drag and re-size columns, it fires and process that row. I just want my code to execute if you click on the record selector to the left. How can this be done Thanks We are a very small company, two programmers in the middle of Kansas. We have lots and lots of MS ACCESS applications for small businesses. We want to migrate away from ACCESS and have chosen VB .NET. I have written five small embedded apps in VB .NET to run on hand held ...Show All

• Visual Studio Express Editions Error While Coding!!

  I am following a book's direction to code, but when i entered this startment ' For intForLoopCtr = 1 To CInt (txtNoPics.Text) ' <<<<<<<< then it said 'intForLoopCtr" is not decared....... so anyone have any idea to make it decleared OK I'll lay this out clearly. You are using variables such as blnFullSetComplete before you have declared them. You need to use a statement like dim blnFullSetComplete as Boolean beforehand to specifically declare the variable and type prior to using it. This is probably because you have used option explicit on. It doesnt matter the variable name, type or construct you are using it in - the same thing applies - you need to declar ...Show All

• Visual Studio Team System Team Build unable to Run Auto Builds now

  For some reason today, when I run a build type (automated build) thru the VSTS Interface. I get the following message back: "Failed to retrieve data from the server. Please verify the network connection and try again." I have no problem building the Solutions manually. Only encounter problems thru the Build Type. I see the following in Event Viewer on the Team Foundation Server log: " An unexpected condition has occurred in a Team Foundation component. The information contained here should be made available to your site administrative staff. Technical Information (for the administrative staff): Date (UTC): 5/17/2006 9:01:20 PM Machine: DALENG01 Application Domain: /LM/W3SVC/3/Root/Build-5-127 ...Show All

• Windows Forms User control in designer

  Hi, Can anyone tell me what is the user control life cycle when its dropped in to a visual studio designer I mean, I have a new windows application project created in visual studio 2005 and a new form added. Now I create a new user control extending it from UserControl. Add few properties in user control and few events. Now when I drop this user control in form, i want to know what designer does to display it on the form and what event's would be fired and which events wouldn't fire . Reason of asking such question is, I have a user control and when i drop it on a form, it fires its load event and I was under impression, it would not fire load event when control is in design mode. It must fire it when its in RunMode. I do check Desig ...Show All

• Visual J# Is it possible to Drag & Drop j# browser control

  Hello I’m trying to learn j# browser controls and I’m stuck in a moment when I like to build a graphical interface. Is it possible to create browser control in such a way as normal windows form just by drag & drop components I'd like to use If it is possible, can I ask for some example, cause it will help me to get how it works here. Do you mean when you design the GUI for your J# Browser Control in Visual Studio You have to use the AWT/Swing API for J# Browser Controls. That is not supported in design time in Visual Studio. Win Forms are supported in design time (UserControls) for ".NET Browser Controls", you can find more about this if you search for "C# Browser Controls" or "C# Appl ...Show All

• SQL Server OpenQuery() to Linked Server hangs, leaving SPID with open tran, then templog.ldf grows without limit.

  Hi, We have a customer that is using SQL Server 2000, and experiencing the following intermittent problem -- occasionally templog.ldf will grow and grow until it fills the entire disk. This is a rare problem, it has happened less than 10 times in the past two years, for a job that runs once a minute. But it has happened on 3 different SQL Servers, (two production servers, and one test server). Our suspicion is that the root cause is an OPENQUERY() to pull data from a linked server (Oracle database on Unix). We have seen that these OPENQUERY() statements occasionally hang and cannot be killed. The OPENQUERY() is used to populate a local table, and when we originally populated permanent tables with OPENQUERY(), then there would be a ...Show All

• Windows Live Developer Forums IRC-Channel for VE?

  he, what about an IRC-Channel about Virtual Earth, to share ideas, and get help a bit more quickly than just thru the forum If somebody wants to setup a channel on any network, post the network name and channel name, i definitely will be there. just use mIRC 6.21 ( http://www.mirc.com ) install it, start it, in the options choose the network 'quakenet' and connect when connected, just type /j #VirtualEarth and youre in ...Show All

• SQL Server Error -2147024809 An error has occured on the computer running IIS

  I am sync. for the first time (Merge Replication using SQL 2005 and Mobile) and this error keeps poping up on the emulator. I am tring out the tutorial. :) boss on my butt. Does anyone have any ideas or a solution to this...your help is WELL APPRECIATED ... Error code: -2147024809 zo The error codes from the runtime is as follows: Error Code: -2147024809 Message: An error has occured on the computer running IIS. Try restarting the IIS Server. (Tried several times) Minor Error: 28022 Source: Microsoft SQL Server 2005 Mobile Edition ...Show All

• Visual C# Why is there a PDB file in my projects Release folder?

  This is probably a deployment question, but there doesn't seem to be a deployment section in .NET Development Forum. I thought the PDB file was only for debugging purposes, so why is there a PDB file in my bin\Release folder What are the (dis)advantages of including this file in deployment It started happen in Visual Studio 2005 only, In Visual Studio 2003 it did never happen so the thing you can see that in Visual Studio you could debug assemblies only in debug mode but in 2005 you can also debug when its set to Release. Lets have more comments ;-) ...Show All