skylar119506's Q&A profile

• SQL Server start and end date of previous month

  I need start and end date of previous month, such as StartDate=07/01/2006 and EndDate=07/31/2006 for currentdate 08/156/2006 How can I do this Here's one method to find first-last dates in prevoius/current/next month set nocount on declare @date datetime set @date = getdate() -- the point in time from which to measure print '''Today''s date'' is: ' + convert(char(10), @date, 121) print ' ' -- date of the 1st of the current month select convert(char(6), @date, 112) + '01' as '1st this month' -- date of the last day of current month select dateadd(day, -1, dateadd(month, 1, convert(char(6), @date, 112) + '01')) as 'last this month' -- date of the 1st of the previous month select dateadd(month, -1, convert(char(6), @ ...Show All

• Visual Studio Express Editions Where do I start?

  I am 100% new to this and would like any information as to where I can learn the basics to get going with game programming. I am basically a new born trying to learn how to crawl. Please Help. Thank you. I'll echo the previous replies here: if you value your sanity, you'll start with a much simpler set of development tools. If you've never done any programming before, you have a long way to go before you're ready to make a game. I don't say that to discourage you -- quite the opposite! The fact is that game programming is one of the most difficult things you can do with a computer (on a typical desktop PC, games tend to place the highest demand on the system). If you've never written a program before, t ...Show All

• Visual Studio Team System Undoing exclusive checkouts

  All: My question/problem is this: A TFS user has a number of files checked out for exclusive checkout. The user has subsequently left the company. His domain user account has been deleted. We've tried a number of command line commands to unlock the files, undo the operation, delete the workspace etc. However these approaches all seem to require workspace/owner information, & are unable to find/process the workspace the files were checked out to. How can I undo/delete the checkout operation if the workspace or domain user account no longer exists Thanks in advance, Dave Riches Never mind. I tried the same logic the next day and it worked. Not sure what variables changed. Happy none-the-less. ...Show All

• Visual Studio 2008 (Pre-release) Successive Async Call problem

  Hello all, Just a question about best practices. I'm developping a Windows Application that discuss with some services. I have a method that can take a long. So i put this method OneWay. The problem is when the user on Windows application call more that one times this method (multi click on button) the server doesn't reponse to me. I think it lost the call and don't notify via callback mechanisme my client. What is the solution to don't have this problem Do i pool the client demand Thanks a lot for your help, Nicolas Waw :) Thanks for your great explications. Just a last question perhaps :p What about Visual studio with svcutil. Is the add service reference function customizable or is the service referen ...Show All

• Visual C# issue with figuring out .lib file and such...

  Hello, I am attempting this example I am newbie so let me clear myself what i understood and where I got stuck. http://www.codeproject.com/managedcpp/ijw_unmanaged.asp This solution contains three project 1) C # Class Library 2) C++ Managed Library 3) C++ Unmanged Console Application Am I correct If so Q. after Building 1) and 2) I get two .dlls. In this example's case they are ManagedClasses.dll and ManagedWrapper.dll. HOWEVER to build 3) I need four items, the above two .dll files, IManagedWrapper.h file AND ManagedWrapper.lib file. CAN SOMEONE PLEASE TELL ME HOW TO MAKE .lib file out of 2) Q. another question i have is about how to make this projects I mean When I create a C # library project in .NET 2005 it won't let me in ...Show All

• Visual Studio Team System Deleted Folder still visible- Can't remove

  I deleted a folder. Other users can't see the folder but I can. I checked and unchecked show deleted items just to be sure. I did Get Latest and Get Specific version on the entire project (with force get). I did refresh on the tree. I restarted the IDE. Still shows the folder after that. Is the folder a Team Project If not, can you dump the history of that slot (tf history $/path/to/folder;X1234 /i /slotmode -- no /r) ...Show All

• Visual Studio Express Editions Transfering sound files when you publish

  How would you go about when you publish the program that has sound files associated with it that they transfer to the other computer and when you use the setup to install it they are included I included them in the solution and they seem to be in the file folder on the other computer with a .deploy extention after the file name. And one more thing the following sub with the sound file path works fine on the computer that made the program but if you try to run it on anouther computer you installed the program on it still looks for the orignal path to the sound file thats not the same as the computer you install the program to. Sub PlaySoundFileEvening() My .Computer.Audio.Play( "C:\Documents and settiings\evening.wav" ...Show All

• Visual Studio Express Editions Data connection to SQL Server database file in VB 2005 Express Edition

  Hi, I install Visual Basic 2005 Express Edition on a server with SQL Server 2003. When to setup a data connection to SQL Server database file in VB there's an error message as the following: "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connection. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified). Help please. Thanks, yabing SQL Server 2005 Express edition won't cause conflicts with SQL Server 2000 That'd good. Thanks, yabing ...Show All

• SQL Server how to calculate the least anmongst a list of Quarters

  Hi, i get a list of Quarters that look like following as an input to my proc. 'Q306/Q106/Q406/Q405' I need to find out whihc one of the above is the least Quarter value. In the above example it is 'Q405' The Quarter values that come into the proc keep changing...It could be even 1 or 2 or 3 Quarters etc... Is there any datatype called Quarter in SQL Server.It shows Quarter as a key word... Can some one please help on this.... The split function is the function I posted.  The first parameter is the value and the second parameter is the delimiter. SELECT Value   FROM dbo.SplitData('Q106/Q206/Q306 Version1/Q406 Version2/Current','/') Hope this helps... ...Show All

• Visual Studio Visual Studio 6.0 Pro Installation: acmboot.exe

  Hi, I'm having problem of installing Visual Studio 6.0 Pro. It gives me the error of "Error lauching Dir\acmboot.exe." When I execute acmboot.exe directly, it says the parameter is incorrect. Does anyone know how to fix this problem I need Visual Studio 6.0 Pro on my computer urgently. Please help me as soon as you can. Thanks, Phuc H. Dao im afraid VS 6.0 is no longer supported and these forums are for Visual Studio.NET and the .NET Framework. I would suggest you post over at: www.microsoft.com/communities http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx dg=microsoft.public.vb.setupwiz&cat=en_us_28f1fb59-bb0c-44b8-8bcd-d12406fc5f3f&lang=en&cr=us hope it hel ...Show All

• Visual FoxPro Urgent please: how to filter, copy and paste rows with Excel?

  I have this Macro that really does exactly what I need, but I don't know how to convert it in my VFP program using DOM. I want to filter the rows with "*" in my column "D" and then copy and paste the rows to ANOTHER workbook. Here is the Macro: Range("A1").Select Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select Selection.AutoFilter Field:=4, Criteria1:="~*" Selection.EntireColumn.Hidden = False Selection.Copy Workbooks.Add Template:= "c:\templates\mytemplate.xlt" Windows("MyExcelWorkbook").Activate ActiveSheet.Paste thank you in advance! Karl After instantiating Excel to oExcel, and the cur ...Show All

• Visual Studio Team System Branching Strategy Validation

  Hello! The following is the branching strategy we used using a source control tool that worked perfectly well for our organization. We are now planning to move on to TFS. I have read through many documentations and forums on team foundation server but I never came across this strategy. Could you please evaluate this and let me know the cons and feasibilities of using the same strategy in TFVC. Product (Team Project) Project1 (TP branched from Product TP) | Proj1_Prod (branch of Project1) Proj1_QA (branch of Project1) Proj1_Dev (branch of Project1) | Proj1_Dev_maint (branch of Proj1_Dev) Proj1_Dev_bugfix (branch of Proj1_Dev) Project2 (TP branched from Product TP) …… Proj1_Dev_bugfix : Used ...Show All

• Visual Basic Illeagal Characters In Path Error.

  Hi, I have this error, Illeagal characters In path. I figured out it happend when the FILE NAME had spaces in it, so It took me one week to make it change the spaces to "_". In the debug I didn't have the problem any more. Now I installed the program, and it happend. I don't know the exact line, but if it's because of space it's in the Folder's name. SPACE ISN'T AN ILLEAGAL CHARACTER! Why does it happen Is it a bug in VS How can I fix it Thanks. I added some Try statements, and saw it's in the line: mProfile = Split(DecrypText( My .Computer.FileSystem.ReadAllText(FName)), vbCrLf) In a try which gave an error, the FName was: C:\Documents and Settings\GIL\Local Settings\Apps ...Show All

• Visual Studio Express Editions is it possible to turn off warning for a specific datatype not cls compliant in a module?

  for a given module for interfacing some IOLE, there were plent use of UInt32. Every instance is flagged as type of member '....' is not CLS-compliant. Would be nice if there is an option or way vo reduce the number of such warning in a given module same thing should apply to events dealling with event arguments thank you. after slapping on <CLSCompliant(False)> _ in front of the interfaces, classes and structure used for interfacign some OLE functions that I will not be touching, I managed to reduce the warning to 2 from 21! leaving only the acces of shared member, constant.... warning. Those items ahve already been tested and frozen. ...Show All

• Visual Studio Express Editions Sending text from VB form to Word

  I am using VB Express and Office XP. I need to send name/address data to Word for label printing. Library article says that I need the XP PIAs first, but the link doesn't work. Eventually found and downloaded them. However, I can't install as all I have in my start menu is "Visual Basic 2005 Express Edition" and cannot open a VS command prompt - see below. To install the Office XP PIAs On a computer with Visual Studio .NET installed and the extracted Office XP PIAs, on the Start menu, click (All) Programs , point to Microsoft Visual Studio .NET , point to Visual Studio .NET Tools , and click Visual Studio .NET Command Prompt . The Visual Studio .NET Command Prompt window appears. This facilitates the use of the .NE ...Show All