Slipper's Q&A profile

• SQL Server Long running Query

  Hi, I'm trying to optimize a long running (several hours) query. This query is a cross join on two tables. Table 1 has 3 fields - ROWID, LAt and Long. Table 2 has Name, Addr1,Addr2,City,State,Zip,Lat,Long. Both tables has LatRad - Lat in radians, LonRad- Lon in Radians. Sin and Cos values of Lat and Lon are calulated and stored to be used in the distance formula. What I'm trying to do here is find the nearest dealer (Table 2) for each of Table 1 rows. The Select statement takes a long time to execute as there are about 19 million recs on table 1 and 1250 rows in table 2. I ran into Log issues- filling the transaction log, so I'm c ...Show All

• SQL Server How to build a report from a cube in SSRS 2005

  Hi, All I am trying to create a report from analysis service cube but I am facing some problems. While creating new dataset in report designer, MDX query designer is not displaying while giving Sql Server Analysis Service in Data source. Please give the details of creating reports using cube. When you look at the data source, what is it's type It should be "Microsoft SQL Server Analysis Services" and not "OLEDB" if you want a multidimensional view of the data. ...Show All

• Visual Studio Tools for Office Appointments Start and End

  Hello! It is necessary for me to define Appointments Start time and End time from a selection in calendar. In the other words, User select a some region in Outlook Caledar (as before creating Appointment) and User press my button on panel. And I must to create my own Appointment in this region. For this I must to know the Appointments Start and End. How I can get It Sorry my english. Stanislav, You are on the right track for getting the start/end times of an AppointmentItem. In your code you would get the selection of the Explorer the user is in. You can grab the selected item instance and read the Start an ...Show All

• Visual Studio Failed to create wizard.

  Follow the steps in the Walkthrough: Creating a Wizard http://msdn2.microsoft.com/7k3w6w59.aspx use c#. After step 6, I got two warnings Warning 1 "I:\test\MyNewWizard\bin\Debug\MyNewWizard.dll" does not contain any types that can be unregistered for COM Interop. MyNewWizard Warning 2 "I:\test\MyNewWizard\bin\Debug\MyNewWizard.dll" does not contain any types that can be registered for COM Interop. MyNewWizard After step 12, I got a messagebox "Invalid at top level of the document". What's wrong Solved by set the ComVisible attribute to true in AssemblyI ...Show All

• Visual Studio MSDN (or MS Document Explorer) crashing like crazy

  does anybody know how to fix the following issue: Installed retail 2005 standard studio version on a machine which did have the beta version, yet it was removed with the tool provided my MS. The installed finished without issues, however as soon as I try to use the dynamic help's search button, the MS Document Explorer crashes. Hence MSDN library is halfway useless, because I can't search. If anybody has any ideas.... other than wiping my HD, please let me know thanx Have you tried repairing Microsoft Document Explorer 2005 This may help. Here's how: In Control Panel, click Add Or Remove Programs. ...Show All

• Visual Studio Express Editions My very first F5

  I just recently installed VB Express. Every time I press F5 (etc) to run a Windows Application project, the image of the form flashes on the screen and then I am immediately returned to design. Any ideas as to what I might be doing wrong hi, are you sure its windows application project because what do that is the console application not windows application, anyway try to use ctrl+f5 hope this helps ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. HOW TO: Dividing World into how many Objects?

  Let's say you're building an FPS and a series of obstacles on a terrain. Objects: a. Building A b. Building B c. Building C etc... z. Terrain (Landscape) You're building those 3D objects in Max or other tool. There needs to be collision detection between the SHOOTER and those objects. Will you load: a. ONE .X file with ALL objects b. ALL buildings as an object, Terrain as another c. EVERY object alone What's the best practice, perf wise, etc... Thx (d) any of the above, and then reprocess into whatever format seems to do best when you actually run a Vtune profile. Beware of premature optimisation. ...Show All

• Visual C# How get inner class info by Reflection

  public abstract class ClassBase { public abstract class InnerClassBase { } public void CheckInfo() { Type currentType = this.GetType(); //How to get method info of this inner Class } } public class TestClass:ClassBase { public new class InnerClassBase { public void Test() { } } } //Testing code TestClass test = new TestClass(); test.CheckInfo(); I'm not sure I understand the problem. You can't get a MethodInfo for a class. I'm also not sure what the purpose of the two InnerClassBase classes are. Classes aren't polymorphic so what's your reason for declaring a new InnerClassBase in TestClass ...Show All

• Windows Forms TableAdapter no update?

  Hello! I have create an application with vs2005. I work to a sql server 2005. I have problem to bind my control, modify my dataset but when i try tu update my tableAdapter, my data are not updated. I have create my TableAdapter by design.My code: this .suppliersTableAdapter.Update( this .desktopInventoryDataSet.Suppliers); I have not error. Have you got any idea Best regards, Wavemill Sorry, I have found the problem.It's an error of me. Best regards! ...Show All

• SQL Server Convert row data into Column

  Hi members I got the result set as shown below (By executing another query i got this). Month Status Count ===== ====== ===== April I 129 April O 4689 April S 6 July I 131 July O 4838 July S 8 June I 131 June O 4837 June S 8 May I 131 May O 4761 May S 7 But, I need the same result set as below Month I O S ===== = = = April 129 4689 6 July 131 4838 8 June 131 4837 8 May 131 4761 7 Can anyone provide me the tips/solution. I guess, the threader hate the hardcoding stuff like "I","S",or so, cause there might be other unposted status value. Here I post one dyna ...Show All

• Visual FoxPro DELETE SQL COMMAND->OPENS WINDOW

  THE FOLLOWING CODE: LOCAL tempproin TEMPPROIN =THISFORM.TEXT2.VALUE DELETE * from "C:\temppro\anazitisitrantempAtable.DBF" where anazitisitrantempatable.ar_ent==tempproin Whenever i run this code i get a window in which i have to select the dbf file !.i checked the spelling and its correct ,file exists,why does the window open Is the file open Maybe you'd be better using XBASE code: LOCAL tempproin TEMPPROIN =THISFORM.TEXT2.VALUE if not used(" anazitisitrantempAtable")    use anazitisitrantempAtable in 0 endif select anazitisitrantempAtable DELETE  for ar_ent==tempproin ...Show All

• Visual C# Can anyone solved this problem with Shockwave Player?

  Hi..alll. please see this problem on Visual Studio.net 2005 does anyone know the solutions..: http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx feedbackid=94b4aaf8-95de-4d45-9f37-58099fbffabf Best Regards.. sorry i didnt understand the users fix. .Can you tell me how i can solve the problem..or tell me if you have solutoins of you own.. thanks.. ...Show All

• Visual Basic Area Perimeter Calculator

  I'm having a problem and I'm wondering if anyone can help me I'm creating a calculator in Microsoft Visual Basic 6. It has 3 labels, 2 command buttons, and 2 textboxes. The command buttons are titled CALCULATE AREA and CALCULATE PERIMETER. The two textboxes each have a label pointing to them saying ENTER WIDTH HERE and ENTER LENGTH HERE. The textboxes are meant for the user to enter their length and width and when you hit the command buttons it should calculate the area or perimeter (depending on which command button you clicked) in the third label. I can't get it to work no matter what I do. Any help would be appreciated. The codes I'm usin ...Show All

• Visual Studio Express Editions web development

  Can visual web developer express be installed and run on the same machine that has  visual studio express installed By Visual Studio Express installed, I assume you are referring to VB Express or C#, or C++. But the answer is Yes. Here is a video on "Channel 9" that describes some of the nifty info about web development. http://channel9.msdn.com/Showpost.aspx postid=138769 Hope it helps. ...Show All

• Windows Forms Custom forms & GraphicsPath

  Hello, I create custom windows form using property Region. Form shape I create with GraphicsPath. And this working fine, but I tried in Paint method to draw thin outline using this code:   Pen pathPen = new Pen(Color.Red, 1);   e.Graphics.DrawPath(pathPen, this.formPath); and line is hidden on some places, on the left side of form all is ok but right and down&nb ...Show All