Trevor2006's Q&A profile

• SQL Server Data Mining Clusters

  In a response posted Nov 21 (Clustering Dimension), Jamie wrote... "The only option of using a table-based model as a dimension is to write out the cluster labels and simply make the cluster label as a dimension attribute. You could even append the cluster label to the source data (e.g. the customer table) and not have a seperate dimension, simply a browseable attribute on the dimension of interest" Jamie, can you provide more information on how to do this We'd like to have a series of clusters in an existing household dimension. That is, we need multiple occurences of cluster model results over time browsable in the source cube. I've looked at the data source, dimension, and cube created by the data mining model, but I d ...Show All

• Visual C# report logging

  hey guys, i'm relatively new to c# and i've got a important project using c#.. why blame my school.. anyway, the project i'm working on, involves the saving of Logs.. for reference.. however, these logs only store 1 entry at any given time. should there be more than one user accessing the database at one time, it might cause the system to crash. it'll be so darn helpful if anyone can tell me what method i should do and stuff. or perhaps a certain phrase i can use to search up on relevant information. i'm in need of help badly.. thanks in advance. If you absolutley must use a flat file then you need to research file locking, the is sometimes performed by creating a lock file with the data file, such as data.lock. ...Show All

• SQL Server Can/should I put SP1 on SQl 2005 Evaluation version?

  This will become a recommendation for my customer; we are struggling with performance on this new install which is temporarily done with the Evaluation version and I see a Service Pack has been published. Please advise ...Show All

• SQL Server have a problem with pericision

  I have been working on an application which require as much percision as we can get. We have defined all numeric values as (38,16) however when ever we divide a number by the result of a built in function it truncate the percision to 5 decimal place this cause us to have a small but enoying loss in the numbers being caculated we need a minimuim of 8 decimal places or better is there a work around or solution for this problem in sql server 2005. The more percision the better. example: select tna/(select sum(tna) from taum) from taum where fund_id = 2345 the result is always 5 decimal places even though fund_id tna = 2569698.23 and sum(tna) =98745612325879.36 which should equal .00000002602341683313994 instead the result = ...Show All

• .NET Development build query based on user input criteria (search function)

  I have a search form which contains a set of search criteria and a datagridview. the datagridview is populated by entering none or some of or all of these critera and click on "search" button. the search criteria are: name, dob, gender, date_time_registered, active , etc. I am able to build a simple query for each possibility, e.g. only search for one field, or search for all fields, or search for any 2 or these fields. This is rather inefficient. Is there a way to build one query to accommodate all possibilities I tried to do something like this: SELECT * FROM patient WHERE name = AND dob = AND date_time_registered = AND active = assume user only specified two criteria: name and active, I did this in my code ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Non axis aligned bounding boxes

  Tried rotating my bounding boxes, when my picking stopped working I realized they're meant to be axis aligned only. Can anyone point me towards code for non AABBs that would also support intersection with a Ray object Cheers Collision between a ray and an oriented bounding box is the same as a ray with an axis aligned bounding box. Simply transform the ray by the inverse transform of the oriented bounding box then check the collision with the ray and AABB. ...Show All

• Software Development for Windows Vista Vista RC2: Please help, whats wrong with this function

  I have a lot of functions in my c++ application that is implemented like this: ===== VARIANT TestFunction() { _variant_t vRet; vRet = (_variant_t) _T("TESTING ONLY"); return vRet; } I call it like: _ variant_t vTest; vTest = (_variant_t) TestFunction(); ===== But when I execute it in Vista, my application crashes after the TestFunction is called. It crashes under comutil.h under the function CheckError. The code works well in XP/2K. Thanks ...Show All

• SQL Server How to pass a table name as a parmater in SQL Task

  I am trying to execute an SQL task in a ForEach container that is the table name for a select statment I want to execute (table name is passed from a rowset created before the ForEach container). ForEach Container is looping correctly (I've used a watch to make sure each of the table names in the previous rowset are being passed correctly). I want to use the table name to execute the following query: Select count(*) as TableRowCount from MyLinkedServer... (with as the table name) Problem I am having is that the SQL Task Editor keeps placing a space between the last period and the parameter and then telling me it cannot parse the SQL. I tried: Declare @SQL varchar(255) Set @SQL = 'Select count(*) as TableRowCount from ...Show All

• Windows Live Developer Forums Is there any place where I can purchase the bird's eye view images that are found in the msn virtual earth?

  These photos are great, better than what google earth offers. Microsoft does not offer their bird's eye view images for sale nor do I know of any third party that offers them. Yes VE has a nice advantage over google earth in that VE has birds eye imagry which google earth doesn't. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Please Post First Impressions Here.

  For the working stiff's like myself, could those of you who have successfully downloaded GSE post you first impressions here. Thanks. It definatly looks like a great framework! I started working on my game using XNA, and so far I haven't run into any problems! Although the naming convetion in the framework is different from the one I use, it shouldn't cause problems. Once we get some good tutorials out, I'm sure we will be seeing some good games. Also, the documentation rocks! GJ Microsoft. ...Show All

• Visual C# Same KEY & IV for TripleDES Encryption as well as Decryption in 2 different Win Services.

  Hi, I want to encrypt as well as decrypt a file using TripleDES. My problem is that I am autogenerating the KEY & IV while encrypting the files. As per my project requirement, I have to keep both Encryption & Decryption parts in two differents windows services. Can any one please guide me how to supply same KEY & IV for both I am using the following coding for encryption & decryption: //.......................... private static void EncryptData(String inName, String outName, byte [] tdesKey, byte [] tdesIV) { //Create the file streams to handle the input and output files. FileStream fin = new FileStream(inName, FileMode.Open, FileAccess.Read); FileStream fout = new FileStream(outName, ...Show All

• Internet Explorer Development Error message when closing browser in IE7

  I have three computers, one PC and two Notebooks, with IE7 on all three. Whenever we close our browser, our computer either freezes/crashes or we get the report error message. I downloaded the program again, on all three, and we still have this problem. What suggestions does anyone have to fix this problem You have to go to control panel & then to add/remove programs. Then you have to find any toolbars-yahoo toolbar, google toolbar... & remove all of them & then restart the computer & then try. it should work. ...Show All

• SQL Server formating integer

  hello. A question please. I am new on Sqlserver. Could anyone say me how must I format an integer to string. example I have: 0001 (integer field of 4 positions) and I'd want to see it "0001" (string) Thanks... It seems like there is a better way of doing this, but one way is something like: select right('000'+convert(varchar(4), 1), 4) as [4-digit integer] -- 4-digit integer -- --------------- -- 0001 ...Show All

• SQL Server SSIS interview questions.

  Could some of the expert(s) list interview questions that might come up when applying for ETL/SSIS developer I or II positions. Thanks LOL... its a joke... There is truth that its likely harder to come from being a pro in DTS and "adjusting" to SSIS than just learning SSIS from scratch without knowledge of DTS. ...Show All

• Visual C# How export a gridview to excel using c#

  How export a gridview to excel using c# thanks! there are a couple of options, unfortunately for us since its WinForms based, there is apperently an easier way to do it in ASP.NET if we were using ASP.NET in order to help better, could I ask - how are you populating data into the datagridview Are you entering it manually or have you databound it from a dataset, using a DataAdapter to fill the dataset with records ...Show All