wesneon's Q&A profile

• SQL Server Compare Two Dates

  I need to compare tow days and number of hours between two days. Then I need to deduct non-business days and hours (Business days: Monday-Friday and Business Hours: 7:00am-7:00pm) from this and find net hours. How can I do this Following might help you http://www.sqlteam.com/forums/topic.asp TOPIC_ID=61519&whichpage=1 http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html http://www.databasejournal.com/features/mssql/article.php/3502256 http://codeinet.blogspot.com/2006/08/auxiliary-calendar-table-for-sql.html http://www.tek-tips.com/faqs.cfm fid=2968 Gurpreet S. Gill ...Show All

• Visual Studio Express Editions Single Instance application crashes with an exeption...?

  I was making a program that I wanted only 1 copy to be running at a time. If its multi instance, I can run it over and over. If its single instance, instead of letting just 1 copy run, whenever a second copy is launched, both it and the first copy CRASH with some fatal exception error. I'm simply checking off the "Make single instance application" option under the "Windows application framework properties" section. Why does this make the program crash o.k.,. I’ve found my work around so I’ll say what happened and how I got around it for the other following in my foot steps.( Well the not crashing , which is a start ) But before I do I’ve expend on my old problem and answer a couple of points. 1/ handler code was in applic ...Show All

• .NET Development Importing access database (.mdb) to mysql

  Hi I have a complete database which is written in access and which I would to convert to mysql. In my program I could like to use JDBC driver to integrate with mysql database. Does anyone know how this can be accomplished Dan I'm not sure if I fully understand your question, but Access can only operate through ODBC, although you can use JDBC with ODBC if, for example, you have a Java app. You didn't really indicate what you're using to develop the app although I assume it's a .NET desktop or web app. On the other hand, if you just want to export the data from Access to MySQL you can create linked tables in Access to corresponding tables in MySQL using ODBC ...Show All

• SQL Server Service Pack update

  Good morning. Is it necessary to run the service pack (I'm upgrading SQL 2K from SP3a to SP4) on the clients, as well To update any connectivity tools, etc. Thanks. Chris Hi, the most update from SP3a to SP4 where just for the server engine. You don’t necessary need to install that, although it won’t break anything. So it’s up to you. I always installed that on my clients to keep the most current service pack. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. GetVariableByName returns value?

  when i call effect->GetVariableByName it always returns a value, i never get NULL back even if what im looking for does not exist, how can i check if a variable with a certain name exists (without having to iterate over all variables in the shader) ...Show All

• SQL Server Parameter Getting Disabled

  Hello every body, I have a scenario where i have 6 parameters Servername Drive Asofday ProjectedDays Percentage Limit Nooddaystocalculateaverage. The report functionality is working fine with the provided parameters,but the problem is one of the parameter Asofday is getting disabled until then servername and drive are provided and a click on the other remaining three parameters. i have default for this asofday for today, and i feel that because of default parameter only it is getting disabled. i removed the default and is working fine wihtout getting disabled. As this Asofday is of thirdplace in parameters list, i moved it to firstplace,it works fine here also. What is happening when i supplied default and ...Show All

• Visual Studio Express Editions Add Inherited Form...

  My MCSD training kit says that in Visual Studio, you have the ability to add an inherited form by clicking Project -> Add Inherited Form... . However, In Visual C# and Visual C++ Express Edition (I don't know about Visual Basic Express), this option seems to be missing. I also notice that you can't add an inherited form via Add new item... or Add New File... . Don't get me wrong, I won't really mind missing this feature from the express editions (I wasn't aware of the feature until my MCSD training kit pointed me to the menu item). However, the examiners will probably not like that excuse. Should I just skip the chapter on inherited forms I wonder if I can inherit a form manually class DerivedForm : BaseForm { ... } Inheriting ...Show All

• Visual Studio Team System get list of files changed after a specific label

  How can you get a list of all the files under a team project that have changed since a particular label was cut on that team project You mean something like tf merge /candidate /format:detailed It's an interesting idea I haven't seen suggested before and wouldn't be hard to implement. We're already adding a /format:detailed flag to tf merges so it's not out of the question. ...Show All

• Smart Device Development rapi.AcitiveSync

  How can i understand/control the failure of rapi connection from the code while developing a simple device application thanks... Most of the RAPI calls return error codes and you can use GetLastError() function to see the error info and use appropriate program logic to code againt such errors. Info on GetLastError http://msdn.microsoft.com/library/default.asp url=/library/en-us/wceappenduser5/html/wce50lrfcegetlasterrorrapi.asp MSDN Info about RAPI http://msdn.microsoft.com/library/default.asp url=/library/en-us/apippc/html/ppc_api_template_yjfpo.asp Manav ...Show All

• Smart Device Development is it possible to copy an already installed certificate?

  Hello, I was wondering if it's possible to copy a certificate in one of the store of the device. If so, how Regards I mean I would like to know if it's possible to replicate completely a certificate in one of the device store I'm just affraid that hackers may be able to do that to run their programs on our devices or using our program on their device. ...Show All

• Visual C# Code conversion C to C# problem with bitwise << shift

  Please could someone tell me why the following code snippet in C# produces an error "cannot implicitly convert type 'int' to 'ushort' " on the bolded line public ushort [] table = new ushort [256]; public ushort XMODEMcrc( byte byt, ushort crc) { crc = (crc << 8) ^ table[byt ^ (crc >> 8)]; return crc; } This exact code works in C. I don't see anywhere where an int type is used Many thanks Les I'm guessing that the fact that there are literal ints in the statement might be casting the entire statement to int. Either way, this compiles for me: public ushort[] table = new ushort[256]; public ushort XMODEMcrc(byte byt, ushort crc) { crc = (u ...Show All

• Windows Forms how to use picturebox

  Hi! I have a question that how to use picturebox. If I want to load pictures from a file. My reference says something like; pictureBox1.Image = Image.FromFile( ); What would it be after FromFile Should I put file address of the pictures Thank you for help. Problem mitigated. Turns out the Access DB I was using was giving problems in the way it was handling the image. I rebuilt my DB using SQL Server and everything works fine. Thanks. ...Show All

• SharePoint Products and Technologies Sharepoint and AD Distribution Groups

  I was wondering if there was a way to either import or synchronize distribution groups between active directory and sharepoint. Thanks in advance! ...Show All

• SQL Server How to relate InstanceID of RunningPackage object to logging?

  Iterating through Running packages as in this code from MSDN: RunningPackages pkgs = app.GetRunningPackages("yourserver"); // Enumerate through each package in the collection and display some data. foreach (RunningPackage package in pkgs)     {         Console.WriteLine("InstanceID: "+package.InstanceID);         Console.WriteLine("PackageDescription: "+package.PackageDescription);         Console.WriteLine("PackageID: "+package.PackageID);         Console.WriteLine("PackageName: "+package.PackageName);         Console.WriteLine("UserName: "+package ...Show All

• Visual Studio Express Editions Movement

  It has been a while since I have last used visual basic, and I forgot how to make movement using a timer. Can someone help me A very general answer for a very general question: In the timer tick event have something like: Control.Location = New Point (X,Y) ...Show All