MadJack McMad's Q&A profile

• SQL Server how to write Crosstab Queries

  I need to write Crosstab Queries just like this, Qty + previous qty = TOT QTY TOT 1 1 5 6 3 9 9 18 2 20 Sorry, I didn't mean to imply that we support the ORDER BY clause on windowed aggregate functions yet. In case it is not clear, the specification for range/rows within each group is defined as part of the windowing functions feature. And SQL Server currently supports ORDER BY clause only for the ranking functions (RANK/DENSE_RANK/NTILE/ROW_NUMBER). And also the ORDER BY doesn't support NULLs ordering. For the windowed aggregate functions (SUM/COUNT/AVG/MIN/MAX), only the PARTITION BY clause is supported. ...Show All

• Visual Studio Team System LOC reporting

  I am working with the TFS cube and trying to get meaningful data out of the LOC counters. (add / modify / delete lines of code). However, these numbers seem skewed because they count automated code generation. Such as vbproj files and wsdl files that are auto generated by VS. Also our build types in TFS are counted as line of code. Is there any way to remove these LOC from a report Thanks for your help, -Nate Thanks for your help, That worked great, next question. How would you go about finding the LOC for one branch within a project Thanks again, -Nate ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Bones and X Importing

  Hey all, Took a look around and couldn't find a post about a similar problem on the forum, and just wanted to know if anyone encountered any problems importing an x file that included a skeleton, I created the following test animation (forget the animation at the mo, it doesn't seem to get past the importing stage let alone processing) of a cube in Maya 7, importing it using the directx X importer plugin for maya from the august SDK (the december one crashes everytime i try to use it, and i have yet to try the february one). When i so much as add the x file to my project, without referencing it in the code (so all it goes through is the content X importer and default Model XNA processor) and try to build it returns the error: 'Error 8 Vert ...Show All

• SQL Server Ole DB Destination - Fast Load - Permissions

  All, If I use an OLE DB Destination with Fast Load, and enable check constraints, I would expect to see this work as BCP would in this scenario on 2005. However, instead, I get the error ALTER TABLE permissions required. I understand that when using BCP, if you disable check constraints and triggers, then you need alter permissions. But, when you explicitly enable these, then you do not need this permission. I would expect the same behaviour in SSIS, but I am not seeing it. Fast Load seems to always require ALTER TABLE permissions. Can anyone confirm/deny this Thanks, dcb99 dcb99 wrote: Phil, I've tested with with the constraints checkbox checked and without. (The other checkboxes ...Show All

• Windows Forms WebBrowser History Problem

  Hey, I am using the same code I have in my webbrowser program that I used for the bookmarks, but I checged everything int he bookmark code to the name History instead of Bookmark, So I fixed 7 errors and thought it would work but then I got a runtime error when the form opened up, it was: An unhandled exception of type 'System.StackOverflowException' occurred in SurfScape1.exe For this line of code: this .TheCollectionOfHistory = value ; in this little group witch is all I need to show you guys becuase I dont think the other lines of code do anything with this...but here is what the group of code this line of code is in: public List < History > TheCollectionOfHistory { get { return this .TheCol ...Show All

• Visual Studio 2008 (Pre-release) The Security Support Provider Interface (SSPI) negotiation failed.

  I have WCF service hosted in a windows service with wsHttpBinding. In my client application, added service reference feature by using http://mytestsite.com:8001/MyServices.RecordsReceiver . But I keep getting the error mentioned in the subject. Any pointer or help will be greatly appreciated! Here is my client config file: < xml version = " 1.0 " encoding = " utf-8 " > < configuration > < system.diagnostics > < sources > < source name = " System.ServiceModel.MessageLogging " switchValue = " Verbose,ActivityTracing " > < listeners > < add type = " System.Diagnostics.DefaultTraceListener " name = " Defaul ...Show All

• Visual C++ need help to deal with char* pointers on COM interfaces

  I need to reimplement legacy COM interfaces (derived directly from IUnknown). A lot of methods on the old interfaces are equivalent to the following: HRESULT setValue (const unsigned char* value); HRESULT getValue (unsigned char* buffer, int bufferSize); The pointers on both methods are in fact the addresses of unsigned char arrays, which may be allocated on the old COM client's stack. The COM server needs to use the pointers either to fetch a C-style string (in setValue method), or fill up the client's buffer up to the buffer size (in getValue method). See the big problem (flaw) here The COM server must be able to access the COM client's internal memory directly. But the problem is, that can't happen all the time, because COM ...Show All

• Visual Studio Express Editions How do I total a DataView column?

  I have read in a text file into a datatable and filtered it using a dataview. Presuably these are all strings. How would I total up one of the columns of the dataview Thanks for your help but I figured out how to do it using SQL commands. It works, so I presume it's right. I used this code type[0].Total = dvTxn.Table.Compute("SUM(TotalTransactionAmount)", "ProcessingCode = 'Declined'").ToString(); type[0].Count = dvTxn.Table.Compute("Count(TotalTransactionAmount)", "ProcessingCode = 'Declined'").ToString(); It counts the rows based on a filter and sums them up also. And strings are fine as everything is then output into HTML with no further calculations performed on them. ...Show All

• SQL Server Linked Server Object Listing

  In SQL 2000's Enterprise Manager, upon selecting a linked server the accessible tables and views would be displayed in the right pane. This does not seem to be the case with SQL 2005's Management Studio. I'm seeing this behavior (or lack thereof) with links to a variety of platforms: Sybase ASA, Oracle, and MSS 2000. To rule out a permission problem, I've confirmed the ablity to query sysobjects, ALL_TABLES, etc. Is this a driver or configuration problem, or is this functionality simply absent Try manually issuing select * from sys.servers while running under the same security context you use while in SSMS. You should be able to see rows for any linked server you have a remote or linked login to ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Using standard gamepad on PC ?

  Still havent got my hands on an XBox - but what to buy a gamepad i can use for testing on my PC. Can i use a standard gamepad for XNA development on PC or do i need to buy the specialized controller for windows the "Xbox 360 Wired Controller" and the "Xbox360 controller for Windows" are identical. you can use either one. I'm currently using two wired controllers ...Show All

• Visual Studio Sending CDM_GETFILEPATH message to subclassed save as dialog

  Hi, I intendend to subclass the save dialog of every windows application. For VS2003 I am sending the CDM_GETFILEPATH message to the SHELLDLL_DefView window of the VS 2003 save as dialog to get the full file name that has been selected to be saved (Note that I am not launching this dialog. VS2003 does.). The SendMessage works fine however it returns a value of 0 which indicates that nothing has been copied into my buffer that will actually receive the file name. Kindly provide some inputs on the same. Thanks in advance, Vishal Hi , I am also facing the same problem. currently i am developing a dialog helper application which needs to hook the Open/Save dialog. If anyone have a solution p ...Show All

• Visual Basic VB.NET UserControl used in VB6 application

  Hi. I build in VB Net 2005 an usercontrol that contains a toolstrip.On this toolstrip I add in runtime 9 toolstripbuttons.The code in which I add those buttons is: Public Sub AddButtonsOnToolbar(ByVal intNob As Integer) Dim tsButtons(8) As ToolStripButton For i = 0 To 8 tsButtons(i) = New ToolStripButton tsButtons(i).Tag = i tsButtons(i).Image = System.Drawing.Image.FromFile("D:\Work\Controale_Espot\Pictures\01.gif") tsButtons(i).AutoSize = False tsButtons(i).Size = New Size(48, 48) tsButtons(i).ImageScaling = ToolStripItemImageScaling.SizeToFit If i = 0 Then tsButtons(i).Margin = New Padding(80, 5, 0, 2) Else tsButtons(i).Margin = New Padding(10, 5, 0, 2) ...Show All

• Visual C# Changing Type during runtime

  In response to my previous thread which can be read here , I've decided to create a new thread because although I mention this problem in my previous thread, this is a different subject. To recap, I have a class Shape, which will have many inherited types. In a class Physical, I have a Property which returns a Shape object. Many classes inherit from Physical, and each inherited class will need the capability of allowing the user to change the Shape Type during runtime. I came up with a decent solution, but was wondering if anybody knows, or can think of a better way(s) to solve this: [ BrowsableAttribute ( true ), ReadOnly ( false ), TypeConverter ( ty ...Show All

• SQL Server Problem getting some users to be able to run reports (probably security of some sort)

  I am able to deploy and run reports from my screen at work, but some non-developers cannot run them. They can see the reports, but get the following error message when they click on the report: An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server machine, or enable remote errors -------------------------- ----- - I assume the preceding error has something to do with credentials. I am using Windows security authentication for this. One user has worked through this and is now getting cannot run report query (one of the repo ...Show All

• Microsoft ISV Community Center Forums select rows

  Ok i have a problem that I dont understand. I guess its easy if you know it but I dont and its really bugging me..I try to select several rows by writing: startRow = relativCell.Offset(k, 0).Row endRow = relativCell.Offset(j, 0).Row Rows(startRow, endRow).Select this is obviously wrong but how do you write it The two first lines are correct but the line RoWs(.....).Select is faulty inside the parenthisis. Please help me out if you know this!!! Hello, Provided there are no blank rows between the first row and last row: select the start row however suits your needs and then Selection.CurrentRegion.Select instead of Rows(startrow,endrow).select All the contiguous cells will be s ...Show All