selva_kumar's Q&A profile

• SQL Server Complicated query with really big tables

  Dear Experts, I want to write a very complex query on very huge tables. The scenario is the following: I have one table called #Products, one table called #Shops , one table called #Customers and one table called #CollectedInformation. #Products (ProductID int, ProductName varchar(10)) Product Information. Around 70,000 unique products #Shops(ShopID smallint, ShopName varchar(10)) Shop Information. Around 100 unique shops #Customers(CustomerID smallint, CustomerName varchar(10) Customer Information. Around 100 unique customers #CollectedInformation(ProductID int, ShopID smallint, CustomerID int, SalesValue money) Sales Information collected and inserted in a huge table. We don’t sell all products in all ...Show All

• Visual Basic about copying info from a ".txt" file to a listbox

  This myt seem lyk a very stupid question for most of you people out there, so i apologise for my ignorance. I am learning computing at school this year, and i had to do a project at school. Anyways, i am really really stuck on this, i have been trying 2 do it for the past 3 hours and it seems like i really need some help. I have got this txt file with the info like this: "DEF $13.45" "ABC $12.95" "Cheese Lovers $11.90" "Vegie Supreme $11.90" "$50.20" I was wanting to copy the whole file into a listbox. So this is what i tried, but it never seemed to work. This is what i have thought of, i have tried alot of other methods but they dont work too. Fi ...Show All

• SQL Server How to include a single quote in a sql query

  Hi Declare @Customer varchar(255) Set @Customer = Single quotes + customer name + single quotes Select Customerid from Customer Where name = @Customer I have a query written above, but i was not able to add single quotes to the set statement above. Can i know as how to go about it Early reply is much appreciated. Thanks! Hello, If your issue is that you are having difficulties finding a way to deal with character string which may contain one or more single quotes, then the solution is NOT to surround the string with single quotes as a previous user suggested. This will only work if there is in fact onle one single quote in your string such as O'Brian. It will not work if there are multiple quotes such as Here's ...Show All

• Visual Studio Team System TF source control structure and bug fix processes for large web projects

  Reading the thread Team Project Version Control Organization got me thinking about the source control structure of my current project, an asp/asp.net based commercial web site. The source code, along with all static files are stored in Team Foundation source control. The site and the components are split up into several areas (folders), each containing a number of .NET solutions, using a structure like this: $/WebDev - CompA - CompB - CompC - WebUtil - MainPortal - SubSiteA - SubSiteB - SubSiteC $/WebRelease - Production - CompA - Ver 1.0 - ThreadingHelper\ThreadingHelper.sln - LoggingHelper\LoggingHelper.sln - ... - Ver 1.1 - CompB - Ver 1.0 - Ver 2.0 - WebUtil - Ver 2.0 - WebMonitor\WebMonitor.sln ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Any books coming out ?

  First off, I thin XNA is an amazing idea, I love the idea of bringing back the bedroom coder mentality! However, I've got a fair amount of experience of using Visual Web Developer Express with vb.net and I have to admit I have no idea where to start with XNA express. Just tried messing with the space war demo a bit but really can't work out how everything fits together. So, I was wondering if anyone like Wrox or 'for dummies' are going to be producing a book on the subject for beginners I know it's early days but authore often work closely with developers of a new language and have one out pretty early. bombfrog wrote: Just tried messing with the space war demo a bit but really can't work out how e ...Show All

• Visual Basic Move form with Custom Border

  How do I let the user move (drag) the form around on the screen when the mouse is clicked in a  certain location (the custom border)     Also, is there away to make the panel control semi transparent Thanks for the link.  I'll have to redo what I did and put it into a panel thou.  Makes more sense that way.  Thanks again.   Also, is there away to make the panel control semi transparent ...Show All

• Visual Studio 2008 (Pre-release) What is the status of Windows Presentation Foundation Everywhere (WPF/E)?

  Hi, I'm interested in Windows Presentation Foundation Everywhere (WPF/E) as a possible alternative to Adobe Flex development. All the information and blogs that I can find are from back in March to May, e.g. http://blogs.msdn.com/mharsh/ Has anything happened since then What tools do I need to develop in WPF/E Where do I get the browser plug-ins (miniturized CLR for IE, Firefox, and Mac) Thanks, Mark Please read this post http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=972035&SiteID=1 I havfe a question about WPFE on the post. Thanks ...Show All

• Visual Studio Team System Integration with Visual Studio 2005 Professional

  I'm in a partnership (ie just the 2 of us) currently using Visual Studio 2005 Professional & Visual SourceSafe. We'd like to add in the project/work management capabilities of Team Foundation Server but need to be very careful of the costs. We'd love to have the full Visual Studio 2005 Team Suite but at over ￡10k it doesn't look feasible and I can't find an upgrade path - It seems pretty crazy to throw away VS2005 & VS SS and pay the full price all over again just to get the additional functionality. So I'm trying to find a cheaper/more progressive upgrade route. Can anyone help - can I just buy the Team Foundation Server without the Team Suite or any of the Team Editions (Architects, developers etc) Will it work stand-alone ...Show All

• SQL Server MDX Problem

  Hi, I am a fresher for Analysis service. can i include measures in selection creteria  ( Where condition ). i am going to show some set of rows. [event count] is comes under measures. already i have taken [event count] is one column in my query. can i include [event count] in selection creteria. email id                     name                event count -------------------------------------------------------------------- xxx                    ...Show All

• Visual C++ How to truncate the file using C++ no MFC

  I want to truncate a file using c++. Tried moving the end of file but the data still present. Can someone please tell me how to truncate the file. See if you want to Change File content so you can use seekp and tellg to replace your File Content.if you are looking for something else .Please let us Know. Thanx . ...Show All

• Visual Basic Problems with Process class

  Hi, I am trying to use media player classic to open certain songs in my program and close it after some period of time. Here are the source codes: dim myProcess as Process = new Process() myProcess.start("mplayer2.exe", "C:\My Song.mp3") myProcess.WaitForExit(60000) myProcess.CloseMainWindow() As the program runs, it can open windows media player and play the song. However, it keeps on displaying exception like this "The process is not associated with certain object" (i don't quite remember the name) when it reaches waitforexit method. anyone can help me thanks a lot. I have managed to supress the error messgae. thanks. Now I have another question to ask. My program is supposed to open ...Show All

• Smart Device Development API Call to switch off the device

  Hello everybody! I'd like to programatically switch of my Mobile Device. I think about a call to a dll file, like you do when you perform a softreset. (coredll.dll) I know that switching off a device is only possible with a special series.... like the Qtek S100. Are there any hints thx in advance & kind regards Hi Calling this API should do the trick: [ DllImport ( "coredll.dll" )] private static extern void PowerOffSystem (); This works for fine for my i-Mate JASJAR device. ...Show All

• Visual Studio Express Editions VB 2005 express, please help me with my DB.

  All i want to do is have a 3 column db which I have connected to a simple form in VB to display the data. The Nav bar works and so great. I have one textbox called textbox1 and I have one button call button1 my database is call nametable which has three fields ID , firstname and lastname. When i browse the datatable using the nav, i want to be a to enter data into the text box on the form and then press the button ie button1 which will the replace the displayed name from the nametable with the name stored in the textbox1. This should then be saved to the datatable and then thats it, simple. I have tried and tried and read and read and I have heard about tableadapters and datasets and all sorts, please help and if you can ...Show All

• Visual Studio 2008 (Pre-release) Lambda expressions with statement block body will not compile

  According to the C# specs this should work: Func < int , int > f = x => { Console .WriteLine(x); return x;} ; However I get the compilation error "Invalid expression term '{'" What am I doing wrong here Funny - I was running into this same restriction today, in my efforts to write a program using the Expression API in my metalinq project. Too bad - having a "sequence" node would be really, really useful. ...Show All

• SQL Server Howto use DATEDIFF(); in SQL Express

  Im trying to lern MS SQL Express to my PHP5 websites so now get eyes open for View and i will try to make views in my MS SQL database. Bot this command here i get the rong result SELECT DATEDIFF(yy, '1985/10/21', '2006/10/18') AS Fdag FROM table the problem is im not 21 year old im only 20 bot about 6 days im 21 bot the SQL say im 21 year old so ist can't rember deferind whit the date. i hob i get get help here :) tanks enyway :) Tanks now i use this command select ( 20061018 - 19851021 )/ 10000 and ist working fine ;) bot right now i need get the date today in this format ect. 2006-10-18 = 20061018 so i can use it :) and thanks for help right now ;) ...Show All