Jon Stroh's Q&A profile

• SQL Server Drillthrough returning sets of duplicate rows

  Drillthrough appears to be showing multiple rows for each single record that should be displayed. For example, in my fact table, there is a single record for each trip. The following MDX query returns a single cell with a trip count of three. SELECT NON EMPTY { [CP Date].[Date by Month].[Year].&[2002] } ON COLUMNS , NON EMPTY { [Commodity].[Commodity by Type and Group].[Commodity Type].&[Other] } ON ROWS FROM [Barge Trip] WHERE ( [Measures].[Trip Count] ) 2002 Other 3 If I drill through on that cell, exactly three records should be returned. However, in actuality, 12 rows are returned - three sets each having four identical rows. To drill through, I am simply adding the D ...Show All

• SQL Server Help with simple insert, how to use primary key?

  Ive added a primary key called ID to my table, now my insert stored procedure dont no longer work. i want an unique identifier for each row. heres my stored procedure:   CREATE PROCEDURE composeMessage -- Add the parameters for the stored procedure here @username varchar ( 24 ), @sender varchar ( 24 ), @date dateTime , @subject varchar ( 255 ), @message varchar ( 2500 )     AS BEGIN   insert into Messages ( "Username" , "Sender" , "Date" , "Subject" , "Message" ) values ( @username , @sender , @date , @subject , @message ) END GO           &nbs ...Show All

• SQL Server Select GetDate() Just the month or year

  I wonder if someone can help me with getting JUST the month and year from SQL DB. Using the Select Getdate() Statement. If I need to use another one that would work that would be appretiated as well. Thanks! There are several ways to accomplish your task. In Books Online, look up [Functions], then [Date and Time Functions]. To retreive the current month as a number, use: SELECT month( getdate() ) SELECT datepart( month, getdate() ) To retreive the current month as a name, use: SELECT datename( month, getdate() ) And to retreive the current year, use: SELECT year( getdate() ) SELECT datepart( year, getdate() ) ...Show All

• Visual Studio Team System SQLCMD :connect not allowed?

  In a post-deploy script, I want to connect to another server using :connect $(TargetServer) which works in the sql management console SQL editor window. But during build, I get the following error: Error TSD164: Syntax checking failed : Incorrect syntax near :. sorry, still not working! Even a simple file with only this in it produces build-errors: :connect "d03" GO Error: Error TSD164: Syntax checking failed : Incorrect syntax near :. need urgent work-around!! ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Breaking changes from MDX?

  Hello there, I have a question: when will we learn what kind of breaking changes will XNA bring if compared to MDX Also, what will be the extent of those changes Will they mostly be refactoring changes or will there be serious changes in the coding way compared to MDX Also I read soomewhere that XNA will have font and UI features. What kind of UI features are we talking about :) Widgets and the like Thanks in advance! Are you going to make them similar (compatible) to Avalon (please please :-) ) I presume you are gone make them XML based. Will you publish the chosen format before the next release of XNA so people can make there customised solutions compatible I hope you have a very nice day Bill Spinhoven ...Show All

• SharePoint Products and Technologies Cell Formatting Task Pane

  Anyone know how to get the Cell Formatting Task Pane to appear I closed it and now have no idea how to get it back! Thanks Stephen, but I'm not sure what you mean. I don't see any Data/Cell Formatting menu item or context menu. I see a Data View menu but all of its entries are grayed out and none of them say Cell Formatting. ...Show All

• SQL Server Adding Identity

  how can i change a column attribute using alter table in sql server 2005. i want to add an identity property to my column userid , which deosn't have an identity property defined when created. i tried this. alter table userlookup alter column userid int identity ( 1 , 1 ) not null i got this error: Incorrect syntax near the keyword 'identity'. There is no sql statement to alter an existing column and add Identity property. You can use GUI (SSMO /EM) to do this, but internally, it drop the table and recreate the table with identity column. You can run a trace and see this. Another method will be add a new column with identity column and the drop the old column and renam ...Show All

• Windows Forms How to number displayed rows in DataGridView

  I am trying to create a column in DataGridView1 that will number the displayed rows beginning with 1. My thinking is that I need to display the row index value for each row in a column. It doesn't necessarily have to be the header row, but that is what I am using with this code: Me .DataGridView1.Rows.IndexOf(HeaderRow.Value) = Integer .ToString() I have tried several variations on this without success. Am I headed in the right direction with this Yes, that works just fine. It gives the same look as a successful query result in SQL Server Management Studio. Thanks again, Ken. ...Show All

• Smart Device Development Capturing Incoming call number and Rejecting

  Hi, I am creating application for PPC 2003 and Windows Mobile 5 using VB.Net CF In my application i need to listen incoming call, capture incoming call number and rejecting incomming call. Can you pl help me on this. Thanks Ravi Kanth ...Show All

• SQL Server manual way to rename instance of analysis server?

  is there a way to manually rename my instance of analysis server 2005 i have a 32bit machine, and the 32bit version of sql server 2005 and analysis server 2005 installed, yet i continually get an error. this happens on my servers too, which are all 32 bit. does anyone know of a manual work around ( via regestry maby) to rename an instance Yes, there is a way to rename the instance. Search for ASInstanceRename.exe program under %Program Files%\Microsoft SQL Server. But, as Darren has suggested, you might want to not do it right away because it might not fix your problem and make things even worse since it is unknown what is causing your current problem. The utility operates on registry, service control mana ...Show All

• Visual Basic Listbox right click & context menu

  First off let me tell you all that I haven't been able to get a context menu to come up when I left click on an item in my listbox let alone a right click. What I need to do is this. I need to right click on an item in my listbox and have a menu of choices such as "view, delete, copy" (like right clicking on the desktop) come up, then choose one of those items. Any and all help would be much appreciated. Thanks, RobertMC Christopher, I have Form1 and I have Listbox1, however the only type of contextmenu I can put in is ContextMenuStrip1, which shows up in the bottom window, and a box at the top saying "ContextMenuBox" "Type text for ToolStripMenuItem". I should ...Show All

• Visual C++ System::String^

  I am developing an application in visual c++ using VS 2005. I am reading data in via the serialPort dataRecieved class. This returns a system string, and I am assuming that the string is an array of unsigned characters. The trouble is I am unsure how to access individual data bits within the string. I can perform an if statement to check the contents against a set value. if(myString->Text == "hello world") But......I want to perform something like a switch statement so I can test the 3rd character against a set value, say... "x" or something similar. Can I do this When I have attempted it, I receive errors stating that a switch cannot be performed on a system string - IT IS ILLEGAL - apparent ...Show All

• SQL Server Modify the fontweight of a text in execution time

  Hello! Is it possible modify the font weight like the code below iff(Field.Nam.Value = myValue, FunctionBold(Field.Nam.Value), Field.Nam.Value) Is there a "FunctionBold()" if not exists, how can I make this, by other way Thanks a lot You can use the property of the Font weight and use an expression rather than a fixed value. Choose the expression value and put in your logic in there to determine which weight should be displayed. IIF(Field.Nam.Value = myValue, "PlaceHeretheStaticValueoftheCombobox", "PlaceHeretheStaticValueoftheCombobox") HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio Express Editions clock time

  what is the best to keep track of time What I want to do is calculate time worked in the morning and in the afternoon. For example: person clocked in at 7:55am clock out for lunch at 12:10pm clock in from lunch at 1:15pm clock out for that day at 5:22pm Is there an easy way to calculated this or I am basically going to have to do all the calculation in the code thanks you can use a class called TimeSpan: http://msdn2.microsoft.com/en-us/library/system.timespan.aspx a TimeSpan calculates the duration/time interval between times. Example: DateTime d1 = DateTime.Now; DateTime d2 = DateTime.Now.AddHours(1); TimeSpan diff = d2 - d1; MessageBox.Show(diff. ...Show All

• Windows Forms SaveFileDialog how to use?

  I have a richtextbox1 on a child form inwhich I write a small bit of text in. I then want to save the text from this richtextbox into a .txt file. I have got the saveDialog menu at the bottom of my screen But I am unsure how to correctly make this all work. I know there should be some dialog.filter and index for txt files code somewhere but I dont know where. The code i have done so far is :- private void saveToolStripMenuItem_Click( object sender, EventArgs e) { DialogResult dr = saveFileDialog1.ShowDialog(); if (dr != DialogResult .OK) return ; else { StreamWriter sw = new StreamWriter ( "filename" ); sw.Write( ); //What should I put in the Write function } } Also is ope ...Show All