Gianni Marzaloni's Q&A profile

• SQL Server Predict Probability in Decision Trees

  Hello, I installed the bike buyer example and i am learning the DMX language. Now i wrote the following query (using MS decision trees): SELECT T.[Last Name], [Bike Buyer], PredictProbability ( Predict ([Bike Buyer])) AS [Probability] From [v Target Mail] PREDICTION JOIN OPENQUERY (....... And so on..) Now the result is surprising to me. In the resulttabel all the probabilities are equal. Bike Buyer Probability 1 0.99994590500919611 0 0.99994590500919611 0 0.99994590500919611 0 0.99994590500919611 0 0.99994590500919611 1 0.99994590500919611 and so on. Now i am wondering what predictProbability means. I thought that PredictProbability meant the probability that the prediction is correct. Now all the probabi ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Looking for a Risk Starter Kit

  im looking for a starter kit to handle a risk like game of terratory conquest. if anyone knows a good spot please let me know. ive done searches but havent found much. thanks There really isn't one. I can think of about 5 ways to implement a Risk-like game off the top of my head, all different. Your best bet is to learn game programming fundamentals. From there, I don't think you'll have any trouble implementing a game like that. When it comes to game programming, there are no real "short cuts". Even with a "starter kit", you still need to master the fundamentals. ...Show All

• SQL Server Stored Proc for creating and inserting into a table

  I am having some trouble populating a table with values from other tables: I am creating the stored proc as follows: CREATE PROCEDURE make_temp_stat (@from datetime, @to datetime) AS DROP TABLE tempTable Create tempTable ( NumApplications (int), NumStudents (int), NumTeachers (int) ) //Then I insert the values into the table as follows INSERT INTO tempTable (NumApplications) SELECT Count(*) FROM [dbo].[CASE_APPLICATION] WHERE (OPEN_DT>= @from AND OPEN_DT <= @to) INSERT INTO tempTable (NumStudents) SELECT Count(*) FROM [dbo].[CASE_STUDENTS] WHERE (APP_DT>= @from_dt AND APP_DT<= @to_dt) INSERT INTO tempTable (NumTeachers) SELECT Count(*) FROM [dbo].[CASE_TEACHER] WHERE (JOIN_DT>=@fro ...Show All

• SQL Server import database

  I need to import a database from MS SQL 2000. I created the database. Then I create the database scripts and run them in sql express but I get this error. "The specified schema name "username" either does not exist or you do not have permission to use it." I have also tried to use DTS on MS SQL 2000 to export the data into text file. I do not have the ability to copy the mdf files and attach them in SQL express or make a backup. Hi, Its self Explainatery message, it means that the Schema or User (Owner) does not exists on the system you are trying to run the script, create a similar user /change the schema in script . Do you have proper privilege !!! Refer some link below, it wil ...Show All

• Visual C# Transaction Problem!!!

  You should create methods in Bank and Account class that will return what you need. You can use either generics and in this case for example you will have method GetAccounts in Bank class with return type List<Account>, or you can build your own collection type of classes for Account and Transaction class. Also you should have a method in Account class like GetTransactions. For transfering money from one account to onother you will have a method in Bank class for example TransferBetweenAccounts(Account fromAccount, Account toAccount, decimal amount) which will do the transfer. This method will be a litle more complex, because you should check that fromAccount has the balance bigger or equal the ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Getting adapter format BEFORE device creation?

  I have a fairly simple problem. I'd like to see if the screen is wider than 1280 or not, before deciding on a 1280x720 backbuffer or a 1024x640 backbuffer. The latter will make the game (in windowed mode) work better on 1280x800 or 1280x1024 displays, which are pretty darn common these days. (Meanwhile, for Xbox, I'll just hard-code 1280x720) However, when I create the graphics device manager inside the constructor of my game, I can't seem to actually read the current display mode / adapter format in any way, because they are all NULL. So, to get this data, I have to create the device first. But to create the device, I have to first get the data. Catch 22! I'd prefer not to have to resort to P/Invoke -- is there a way to do this within pla ...Show All

• Visual Studio I need help with installing SQL Server 2005 Express

  Dear MSDN, I'm having a problem with installing SQL Server 2005 Express. In the past, I installed Visual Studio 2005 Beta (with SQL Server 2005 on it) and it runs fine. But I made a mistake uninstalling the beta version. I used the Control Panel and uninstalled the components in random order. When I installed the Express Edition, SQL Server 2005 Express failed to install, but Visual Studio 2005 Express is running fine w/o SQL Server on it. I need to install SQL Server 2005. Please help me how to fix this. Thanks. wow if it failed to clean up from the removal tool....wow. let me suggest something else. Create a temp user account (another one) on your system (with admin priviledges) and t ...Show All

• Software Development for Windows Vista Communication with external applications

  Hello, I've been trying the hands-on labs and now I'm developing a simple workflow myself, but I don't really know how to communicate between an external application and the local workflow. I know that lab05 deals with a similar topic but I've found that the communication was only between a LOCAL application and the workflow but not with an external application. Now I'm trying to follow the expense reporting application in lab01 (resources folder) and I try to see how it communicates with the workflow. I've seen it uses .NET Remoting to create an instance of the remote class, but I don't get to understand well what it does because the same project has together the remoteservices class and the localservices class. Please can someon ...Show All

• Visual Basic vista style gel buttons...

  like I see in Windows Media Player 11 and elsewhere The play button and other controls are gorgeous running on XP. Are those commodity items yet I would love to make some custom forward/backward buttons and see the blue bleed out effect in my current controls in my vb.net winforms app. 1.  Are they simply standard .bmp or some other format that can be easily added to an existing .net control such as a button, checkbox or radio button array 2. Are there tools that make this doable for the developer or is this still in the domain of a graphic artist or developer in the know I don't have the time, as is the usual case, for an immersion course in a graphics package such as Photoshop or Paint Shop Pro. Thanks, -Gre ...Show All

• Visual Studio 2008 (Pre-release) Can a Trigger match against a value taken from another property?

  Is it possible to set up a trigger based on the value of another property I tried using the Binding syntax, but it seems that the comparison value can not have a binding in it: <Trigger Property="ProgressBar.Value" Value="{Binding Path=Maximum}"> What I am trying to achieve is a progress bar that is only visible when it has a value that is not the minimum or the maximum. I can get it to work if I hard-code minimum and maximum values, but I want the style to be applicable to any progress bar with any value for maximum and minimum. The other thing I tried was binding the Visibility value to the Value value using a Converter that would return Visible or Hidden appropriately, but to do this it needs to know ...Show All

• SQL Server FiscalWeekOfQuarter missing

  When I build a time dimension, FiscalWeekOfQuarter does not show up. On the following MSDN page it is listed as an attribute. http://msdn2.microsoft.com/en-US/library/ms175662.aspx#time_dimension_attribute_types Anyone know how I can add it Thanks. Can you describe the steps you took to build the dimension I just ran through the dimension wizard, building a server-based time dimension and an attribute of type "FiscalWeekOfQuarter" was created by the wizard. I also looked at an existing time dimension I had based on a dimension table and I can select "FiscalWeekOfQuarter" as the Type for an existing dimension attribute... Dave Fackler ...Show All

• SQL Server How to guarantee unique of columns > 900 bytes

  We have an app that threads together emails coming out of Exchange, using their messageid. To ensure threading works correctly, we need to ensure uniqueness of messageid, which we do with a unique index (we also need to be able to lookup by messageid when a message comes in). We are currently porting the app from Oracle and PostgreSQL to SQL Server and are having problems with the 900 byte max length of an index. The problem is that the maximum size of a messageid (according to the Exchange docs) is 1877 bytes. How can we guarantee uniqueness gavrilenko_s wrote: You also can use triggers to maintain uniqueness. My understanding is that a unique constraint or index is considerably faster than d ...Show All

• Visual Studio 2008 (Pre-release) FlowDocument and DataBinding

  Hi all! I can't see any way of data binding a FlowDocument to a RichTextBox or a FlowDocumentPageViewer. Is this possible Here's the context: I have a business objects that has a rich text property. This rich text needs to be displayed in a list, in a detail panel and also can be edited in a dialog box. Thank you, Ronan. "This rich text needs to be displayed in a list" - if you could use plain text (no formatting) with \r\n for newlines then you could bind the text to a Run.Text property. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. xbox 360 live vision

  hi guys, not sure if this question belongs here but will game express studio have access to the xbox 360 vision camera i mean developing games using the camera thanks in advance I'm going to guess that it's not going to make it into the initial release, probably a patch. And that just for displaying a video stream not for doing something like TotemBall. It might not even be available in GSE, you'll probably need the Pro version. ...Show All

• Software Development for Windows Vista Database Update Concept

  Hi, We often need to query or update data from/to Database within the business processes. If we use WF Workflow to handle those process, which of the following practices is recommended: 1) Use the SQLDatabase Activity to query or update the database by the Workflow engine directly, or 2) Use the CallExternalMethod to ask the Host Application to perform the query or update. For example, in a bank money withdraw workflow, it might involves a Query (for available balance), and Update (latest balance after the withdrawal). Andy Either of these approaches will work, it just depends on where you want to keep your logic and how you want to structure your application. If you already have logic ...Show All