rosie1475's Q&A profile

• SQL Server Logical XOR operator in T-SQL (SQL Server 2000)

  Hi all.... I was wondering why SQL Server 2000 lacks a logical XOR operator. Do you have a ready to use function that implements it How can I program one by myself I know that A XOR B is equivalent to NOT A * B + A * NOT B. So I tried to create this function : CREATE FUNCTION XOR ( -- Add the parameters for the function here @A BIT , @B BIT ) RETURNS BIT AS BEGIN RETURN NOT @A AND @B OR @A + NOT @B END But it didn't compile. How can I pass boolean values as parameters any other hint Thanks Jaime There is no boolean data type in TSQL and there are only few system built-ins like CONTAINS that can be used directly in a WHERE clause. So you need to use the XOR ...Show All

• SQL Server Are these queries possible without cursors or a while loop?

  I appreciate any help or advise! Thanks assuming the contents of the table are: 1 52 PUERTO RICO 2 52 PUERTO RICO 3 10 MA 4 52 PUERTO RICO 5 5 NY 6 10 MA 7 5 NY 8 52 PUERTO RICO 9 10 MA 10 11 RI 11 12 PA 12 13 CT 13 14 GA (1) detect if there are duplicates and select those records create table twoCol ( id int identity(1,1), colOne int, colTwo varchar(30), modified_last datetime ) I would like to detect all duplicate rows based on colOne and Col2 e.g(all three of these rows have same colOne and Col2) 3 10 MA 6 10 MA 9 10 MA e.g(all four of these rows have same colOne and Col2) 1 52 PUERTO RICO 2 52 PU ...Show All

• SQL Server FTP Download Task (with Overwrite) doesn't overwrite!!!!!!!!!!

  Error with SSIS FTP download task: How to recreate the error: Download a file using the task. Go to the file in Windows Exploder and Open the file in notepad. Copy the last line of text and paste in a few extra rows at the bottom. So if you had 100 rows, you'll now have 103 rows. Save the file. Go back to the task and make sure you have "overwrite destination" set to True. Execute the task. Go back to the file and look at the bottom of the file. You'll see the same 3 extra rows you pasted in there. That is not how it should work if it was supposed to be released like that. Are there any patches that fix this error Ryan I just confirmed Ryan's observations. VS 2005 - 8.0.50727.42 SSIS - 9. ...Show All

• Smart Device Development Pipe html content to a variable using VB in VS 2005 (windows mobile)

  Hi I am trying to find an example (using VB in VS 2005) where you can pipe the html text of a browser to a variable, then do a search within this variable to pick out the relevant data needed. This is to run on a windows mobile 5 platform. I have a general form with the web browser control which loads an URL ok but I am not able to pipe the contents of the web page (just a plain text web page) to a variable. Would appreciate if someone can help. regards raja The WebBrowser on WM doesn't support that. If it's just one or two pages, you can retreive the html manually using WebRequest/WebResponse classes. ...Show All

• SQL Server Select data from huge fact tables

  Hi, I have a situation where I have 4 tables: 1. 2 Dimensional tables(Parent), DIM1 with 50000 rows, and DIM2 with 1000 rows 2. Fact 1 with 50 columns, 25 Million rows and with FK to DIM1 and DIM2 3. Fact 2 with 40 columns, and 25 Million rows and with FK to DIM1 & DIM2 tables. Actually the fact 1 and fact 2 have same related data but since our Analysis cube person wanted the fact table not to have more than 50 columns we divided the tables into 2, but they have the same compound key. Above said, I have a situation where I have to select all the columns, in both fact tables, and do a group by. I wrote the query and ran "Analyze Query in the Database Engine Tuning Advisor" for it. It gave bunch of recomendations about ...Show All

• .NET Development Please help....... Not sure w

  Hi, I have a webpage that displays a datagrid on it. The problem is im getting the following error: InvalidCastException: Conversion from string " " to type 'Integer' is not valid Does anybody have any idea of what might be the problem Thanks a lot for your help. I'm sorry. Here is the Sub that is generating the error: Protected Sub gridSearchResults_DataBound( ByVal sender As Object , ByVal e As System.EventArgs) Handles gridSearchResults.DataBound 'We are loading the following SQL Data in order to render the string-value of the Product Family as displayed in the grid 'rather than the Product Family ID. 'BEGIN LOADING OF SQL DATA ...Show All

• Visual Studio Team System Failed to create team project

  Hi Suddenly, when I try to create new team project , I got the following error: TF30162: Task "WITs" from Group "WorkItemTracking" failed. 2 days before I successfully created projects. Operations that I took when I tried to solve this problem: 1. grant administrator authorization to all tfs services . 2. re-loaded process templates . 3. restart the tfs machine . 4. make sure that all related services started . 5. browse tfs's web services (all of the *.asmx) to make sure they are available . Unfortunately, The error still occurs. Note: I didn't do any significant thing during the last couple of days beside of creating one team project and loading files into source control. What should I do Below logs that des ...Show All

• .NET Development Help request on how to optimally link VC++.NET applications?

  Hi! I posted this question to a wrong forum earlier, now I am reposting it to the right forum. My problem is that I write C++ aplications in tradional form, e.i., the programs include one header file (.h) and one implementation file (.cpp). Compiling is going very smoothly. However, I get problems with the linker and most of the time I get the notorious LNK 2020 error, "token could not be found etc". The reason that I am getting this error message is that the linker cannot locate the implementation files and therefore cannot see where the "tokens" are implemented. It entails that you are supposed to load these .cpp files into the associated projects. My solution to this problem have been like this, because unti ...Show All

• SQL Server Can't execute View script using SMO

  Hi ! I have another problem. Here is now what i'm doing: Dim unTransfert As New Transfer(BDConfig) unTransfert.CopyAllObjects = True unTransfert.DropDestinationObjectsFirst = True unTransfert.CopySchema = True unTransfert.CopyData = False unTransfert.Options.ContinueScriptingOnError = True unTransfert.DestinationServer = ServeurLocal.Name.ToString unTransfert.DestinationDatabase = NouvelleBD.Name.ToString unTransfert.Options.IncludeIfNotExists = True NouvelleBD.ExecuteNonQuery(unTransfert.ScriptTransfer()) This failed because of my views. If i tried to copy tables only it's working fine. I've tried to copy one by one the view and then i notice that most of then failed and i think i know the reason but i don't know what to do. I've notice ...Show All

• Visual Studio Team System NativeAnalysisAPI.dll Side By Side error (was: VSPerfCmd.exe /driver:Start fails on Vista x64 (July CTP))

  I felt brave and reattempted running the Performance tool.   I'm running VS2005 on Vista Ultimate x64 July CTP. In a console window, running as the local machine's default Administrator (the account that UAC doesn't effect) this is what is happening:   C:\Program Files (x86)\Microsoft Visual Studio 8\Team Tools\Performance Tools>VSPerfCmd.exe /driver:Start Microsoft (R) VSPerf Command Version 8.0.50727 x86 Copyright (C) Microsoft Corp. All rights reserved. Starting VSPerfDrv Error VSP1449 : Unable to start VSPerfDrv. This driver has been blocked from loading   So I thought I'd see if it was installed, which it was... C:\Program Files (x86)\Microsoft Visual Studio 8\Team Tools\Performance Tools& ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Pong

  Where would I find or How would i go about creating a simple 2D pong game.Are there any tutorials available For anyone still intersted I put a demo of pong on threesixbox.com if you want to see my code.  The pause menu dosen't work right now, but the game still pauses.  I added a ReadMe file that explains how to play the game and you need a xbox 360 controller I didn't add keyboard input yet. ...Show All

• SQL Server microsoft visual studio cannot shut down because a modal dialog is active

  if i get this message one more time I am going to put my fist through my monitor Hi. I'm also working on report with more then one dataset and a few parameters. What do you mean by " 3 button fix" I'm just saving my work, check it in in vss and close the ssrs with ctrl+alt+del... Ooo, did you mean ctrl+alt+del as the " 3 button fix" :) ...Show All

• Software Development for Windows Vista change integrity level

  Hi, All I want to start a process with medium integrity level from a low integrity level process. From http://msdn.microsoft.com/library/default.asp url=/library/en-us/ietechcol/dnwebgen/protectedmode.asp , I found an example which starts a lower integrity level process instead and use the following hard coded Low integrity SID of "S-1-16-4096". What's the value for other integrity levels' SID(medium|high|system) I searched June CTP's SDK and document, but didn't find anything. One more thing is that also following an example from above link, I try to lower the integrity level of a named pipe in the same process which created it, but I got error code 5(access denied). Anyone knows what goes wrong code fol ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Can I load *-x files with UV textures?

  First hello. I'm trying XNA and I'm so happy with its 2D features but, I have been looking for a method to load *.x files (with 3D graphics) and I have not found anything. If you can help me... Thanks a lot! As I suggested to shrrrt, It may be better to take the SimpleMesh and SimpleMeshRenderer and merge them into a single class. Heads up on using the .swm converted from .x Load the textures into a texture array. Texture2D [] Textures remove the 64.0f scaler when filling the buffers make Draw() render each batch (dont forget to set the textures (material name) ) ...Show All

• Visual C++ Intellisense becoming unable to resolve objects

  I'm posting this here and not in the general Visual Studio forum because my experience so far tells me the situation with C++ is different than with, say, C# (I have so far at least one example where VS's tools behave worse in the C++ environment than in that of C#). I have Intellisense getting confused and unable to resolve objects so often that I find myself closing the solution, deleting the *.ncb file, and reopening the solution. It almost makes me wish I had a "rebuild Intellisense" button... Kamen I totally agree with you. Meanwhile, it is important to note that we won't be able to help unless you provide us with a reproducible case so that we can investigate. I will invesitigate further from my side but can't ...Show All