Sajitha Jose's Q&A profile

• SQL Server Convert Datetime but Order By is Wrong

  I am trying to convert my datetime to 107 ex: Dec 11 2006 ,but when sorting I get the months sorted correctly but not by year ex: Jan 2004 Feb 2001 Mar 2006 Can you post the code you are using to do this That is kind of a wierd way to sort data. I can't think of any way your daa would be sorted this way by using a typical order by clause. create table testDateSort ( date smalldatetime ) insert into testDateSort select '20040101' union all select '20010201' union all select '20060301' go select convert(varchar(20),date,107) from testDateSort order by date returns: -------------------- Feb 01, 2001 Jan 01, 2004 Mar 01, 2006 ...Show All

• Visual Studio Source Safe

  Hi, I am using Visual Studio 2005 Team Edition for Software Developers. Everytime I open my project, its getting update from Source Safe, which I don't want everytime.. How can I disable this Thanks Tools -> Options -> Source Control -> Environment -> uncheck "get everything when a solution or project is opened" ...Show All

• SQL Server Data Flow Task - Conditions to add value for a field.

  Hi: I have a data flow task in which i have multiple OLEDB sources going to a one OLEDB destination via UNION component. I also have a derived column component sitting behind the union, because there are some columns, which exist in the destination table, but are not coming from source, but I am responsible of providing values for those fields. The question is that some of those values are conditional, for eg. Lets say we have a column called RecStatusCode in the derived column component. The value for that column depends on a condition/criteria, so I need to query a db and based on the value of another field, I set the value of the recstatus code. How do i accomplish that I am thinking expressions, but I need clear direction in steps i ...Show All

• SQL Server Vertical Line

  Hi is it possible to set the vertical line to stretch from top of list box to the bottom even If the list box might grow at run time I want the line should stretch from top to bottom jhknys, I have not using a vertical line is this fashion before. Could you use the border style of the List to accomplish the same thing Ham ...Show All

• SQL Server sys.sp_testlinkedserver

  According to BOL extended stored procedure sys.sp_testlinkedserver returns 0 on successfully connecting to linked server and 1 when it fails. But I tried this Created a linked server to default instance of 2000 called TEST and used following script to test the extended stored procedure and instead of printing my PRINT statement it generated error -- CHECK LINKED SERVER CONNECTION DECLARE @ServerName sysname DECLARE @a int SET @ServerName = 'TEST' IF EXISTS( SELECT 1 FROM master . dbo . sysservers WHERE srvname LIKE @ServerName ) BEGIN EXEC @a = sys.sp_testlinkedserver @servername = @ServerName IF @a = 0 print 'LINKED SERVER ''' + ISNULL ( @ServerName , '' ) + ''' IS CONNECTED.' ...Show All

• Windows Search Technologies Add a new location to wds3

  Is there a simple way to add a new location to the wds3 scope In 2.5 (or 2.6 ) we could edit the locations in the registry under HKCU. Since wds3 is now running as SYSTEM and there is only one indexer per machine I guess HKCU a suitable place for this If we have to implement Craw-Scope related Interfaces could you point me in the right direction where to find then. Or better still point me in the direction of some sample code I can tear up. Again my preference is to do this in C#, so any interface for C# would be fantastic. (If it can be done) 58 reads and no responses. I guess I'm not the only one doesn't know how this works ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Multiple Models

  Does anyone know how to create multiple models on demand like by pressing a key or clicking the mouse.  I want to be able to create a model at the exact position of the mouse when I press the spacebar.  I thought that I would use an array of models to be able to create as many as I want.  Wherever you see the lightbulb, that is a [ i ] for the array of models.  Here is the code that I have but it does not work: #region Using Statements using System; using System.Collections.Generic; using Microsoft.Xna.Framework; using Microsoft.Xna.Framework.Audio; using Microsoft.Xna.Framework.Content; using Microsoft.Xna.Framework.Graphics; using Microsoft.Xna.Framework.Input; using Microsoft.Xna.Framework.Storage; ...Show All

• Smart Device Development visual c++ - smart device - win32 smart device project creation failed

  hello i'm trying to create a win32 smart device project but when i do this, i get the message 'project creation failed' in the status bar in another forum i found a workaround where i was told to open regedit and find the registry entry KEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Ext\PreApproved. there i had to add a new entry: {D245F352-3F45-4516-B1E6-04608DA126CC} but this doesn't work....any ideas tia pezi Use teh above suggested workaround, or move to VS 2005 SP1, that has the fix for IE7, or uninstall IE7. Thanks, Gangadhar ...Show All

• SQL Server Most effecient way to get "previous row" values?

  Wow, this board has gotten really busy lately - maybe 2007 is the year that a lot more people start using SSIS :) Anyway my question is this: If I have an ordered set of data in the data flow and I want to add a column, lets just say "previousID" that basically has the ID value of a column from the row immediately before it - what is the most effecient way of doing that I've done much more complicated things with running averages, mean, etc by creating an asynchronous script transformation, pushing the data into a datatable in memory and looping through row by row using variables etc to do the calcs... but I just have this feeling that there is a "lighter, faster, easier" way for just getting previous row's value (with ...Show All

• Audio and Video Development Side Scrolling Chapter Menu

  I'm trying to create a side scrolling chapter menu and was wondering if anyone has solved this riddle script side. Basically I want to scroll through chapter images using left and right arrow buttons, so the menu would start like this: < #1 #2 #3 > Then by clicking on the right arrow button it would then look like this: < #4 #5 #6 > And so on. The version I have built simply replaces the images (#1 replaced with #4, #2 replaced with #5 and so on). But I would love to make them scroll so the new images come in as if they are all on the track moving left and right. I did try to solve the problem be creating on long block of all the chapter images, masked behind a div that was only big enough to show th ...Show All

• Visual C# Multiple Edition management with VS 2005

  Hi All, Here is the big question : Suppose to need to compile the Basic, Standard and Pro editions of you app. What will you do inside VS2005 (each edition contains a different set of file/classes but, obviously, the most are shared between each app edition) 1) I create 3 project (Basic, Standard and Pro) and link the shared files/classes from the first. 2) I use conditional compiling, placing the classes inside an #if PROEDITION #endif statement. 3) I build 3 different asseblies and merge them using ILMerge. 4) Other. Thanks so much for your thoughts, I want to start with the right foot! Alberto Alberto, I think it's going to depend on how many differences there are between the different projects. I'd ...Show All

• Visual Studio Express Editions Dialog question

  Hi I'm new to windows programming. I need to know how to get a user input, using a dialog or something similar (like scanf() from stdio.h) And only C code if it's possible. :) Thanks in advance. If you want to stick to console style input, you can include <iostream> and use std::cin to get input. If you would like to use dialog boxes and a UI for gathering input, you may want to look into Windows Forms (.NET) to do this. If I'm not mistaken, I believe C++ Express comes with the CLR and Windows Forms project templates. If you don't want to use .NET, you could download the Platform SDK and set up your build environment so you can build MFC applications. This will make is much easier to develop g ...Show All

• Visual C# Moving from procedural to OO

  I have been coding in C for upwards of 4 years now and a friend of mine has brought to my attention that a lot of employers now want their programmers to use OO instead of procedural. I have gotten a book on Java and 2 on C# (one on the basics and one on network programming), but I must say this OO thing isn't really catching with me. I am still in high school, so I don't have much time on my hands, but do any of you have any good resources on how to relate OO to procedural, or to just make it a bit understandable Thanks hi, this is not constractor this is called property, the property is used as a special form (shortcut) for 2 methods , in other language if you want to change the value of a class mem ...Show All

• Visual Studio Team System Confused by subscription options

  I manage a small department of developers and testers.  I want to acquire an MSDN subscription for each of the developers so at the very least I need an MSDN Professional subscription but I would like to get the Team edition of Visual Studio.  What I am uncertain of is if I get the team suite, does it include the team foundation server or do we have to purchase the Team Foundation Server seperately Also, all three developers are on equal level with each other in performing all functions of an architect, developer and DBA.   What should I get then   The Architect, Developer or database version of Visual studio should I get for them Furthermore, even though the team suite has three VS editio ...Show All

• .NET Development Web.Config

  Hi there, I have used the sample website which is already made for you (With Web.Config) when you load it in visual web developer but after I upload the whole website to the web. The website cannot find the .aspx file. The webserver does allow ASP.Net but it still cannot find a aspx webpage.. Could anyone come up with a solution or what might be my problem Thanks, AliQ Hi Ali, it looks as if you are just starting with ASP.NET. This forum is for ASP.NET Web Services questions, not for general ASP.NET questions. I suggest you ask your question here: http://forums.asp.net/15/ShowForum.aspx Clemens ...Show All