Ramesh Kasavaraju's Q&A profile

• SQL Server Cursor approach versus T-SQL Set based solution--Avoid/Eliminate Cursor if possible

  Two Scenarios: Scenario 1: T1 (Ticker varchar(10), Broker varchar(10), Qty decimal(18,6)) T2 (Ticker varchar(10), Trader varchar(10), Qty decimal(18,6)) T1 contains the Ticker of a stock, Broker offering the stock and quantity he/she offers T2 contains the Trader interested in Buying/Selling the stock and the quantity to be bought or sold. Sample data: T1 MSFT, Fidelity, 125 MSFT, Capital One, 200 ORCL, Nomura, 145 ORCL, Bear, 100 SUNW, Fidelity, -200 T2 MSFT, Joe, 60 MSFT, Bill, 70 MSFT, Greg, 195 SUNW, Charlie, -80 SUNW, Mike, -120 ORCL, Joe, 66 ORCL, Henley, 34 ORCL, Peter, 145 As you can see from the above example T1 and T2 are complete ...Show All

• Visual C# DateTime

  Hi. What I want to do is display the current time, or the current day in a MessageBox.Show method. Can someone tell me how to do this. I know it has something to do with the DateTime method. Thank you for any help provided. // displays the current date number MessageBox.Show(DateTime.Now.ToString( "dd" )); // displays the full name of the day ( ie Monday ); MessageBox.Show(DateTime.Now.ToString( "dddd" )); ...Show All

• SQL Server 3rd-party report editors

  Does anyone know of any products out there that allow end users to control the layout and fields of a report without having to install any special software on their machine Hi Josh, I looked into ActiveReports and while it did look promising it seems the end-user designer only applies to WinForms. Thanks for the suggestion, though. ...Show All

• Visual Basic Solutions config. in Whidbey

  In vb.net 05, the Solution Configurations and Solution Platforms dropdowns seem to have disabled themselves. They are grayed out, and I cannot use them to choose between debug and/or release modes. They used to work, and I didn't change anything. They just stopped working one day and that is where I am now. Any suggestions Matt Could you please check if you have enabled the "Show advanced build configurations" (Tools->Options->Projects and Solutions->Show advanced build configurations) If not, that is the reason why they are grayed out, and you will do a debug build/run if start debugging with F5, and doing a "real" build ...Show All

• Visual Basic StartUp Form in VB2005

  Hey NG I set a Form as Splash-Screen in the Project-Properites. It works fine. But now I have some files to write to the disk during start-up. So I decided to write this code into the Splash-Screen. - This works fine too. - But the problem is, that I don't get the Splash-Screen visible before writing the files. Maybe, somebody can help me. THX! Hey! Sorry, that I reply so late. I had no time before. Thank you for your help! - You are right, it is a very nice way to code such things! Yours faithfully ...Show All

• Visual C++ How to add print support in CformView

    Hi, I just create a MDI MFC application using CFormView as the base class for the application view.  It becomes a disaster when I want to print this form to printer.  According to the MSDN document: http://msdn.microsoft.com/library/default.asp url=/library/en-us/vccore/html/vcconcreatingforms-basedapplication.asp No printing support for a form-based application! I tried to add ON_COMMAND(ID_FILE_PRINT, OnFilePrint) to enable print function in File/Print , and override OnPrint() ; however, it gave me the error message like this: Debug Assertion Failed! Program:!K\test.exe File: viewprint.cpp Line: 157 Fo ...Show All

• Visual Studio How do I debug Web Apps on a remote machine ?

  Hi, I am trying to develop a web app that uses COM objects that only reside on a server where I cannot install VStudio. I have, however, installed .netFW 2.0 Beta and the remote debugging tools. Now I cannot find a way to tell VStudio to run the app on the remote machine when pressing F5. Is this by design The samples for remote debugging don't touch web apps, and the settings for web apps don't let me specify remote debugging. A little hint would be appreciated. Guenter When I try to attach to the ASP.Net worker Process I can't find w3wp.exe neither aspnet_wp.exe. Do I have to install the .net framework on the remote machine ...Show All

• Visual Studio 2008 (Pre-release) FooLinq

  So we've had long discussions about Linq, XLinq, and particularly DLinq. It's probably a good exercise to forget about databases, ORMs, and XML files, and spur the masses into thinking where else they think Linq would be useful. Maybe someone here will take up one of the suggestions as a project... I think Linq can help to map business objects to UI controls in the presentation layer. I'm still thinking about it, but Linq could be used to convert to objects from the business model to the presentation model , back and forth. What do you think ...Show All

• Software Development for Windows Vista Workflow Monitor

  Is there any way to present user friendly captions on activities, Like "Waitng for approval" Activity names must adhere to .NET type name conventions. You could use Waiting_For_Approval in this case. The standard activities only show the activity name in the designer. You could also create a custom activity very easily which shows the description property in the workflow design surface. The the WF Beta 2 Hands on Labs have an example of this. Regards, Paul ...Show All

• Smart Device Development Access LAC/MCC/MNC & CellId

  Hi guys, Is there a way to access LAC/MCC/MNC and cell_id If yes where can I find it and what are the functions to access them Regards, Parag Please post the question after referring to the following link: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=286724&SiteID=1 The link will tell you the most appropriate place/newsgroup. I hope it helps. ...Show All

• Windows Forms Exiting application with Me.Close and Application.Exit not working.

  Hi, I'm trying to exit from an application if an exception occurs, but for some reason neither Me.Close not Application.Exit appear to be doing anything. I even tried ExitThread, which I am a bit wary of without doing a bit more reading up on. Code below: Private Sub ManagerForm_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim bolReadConfigFile As Boolean = True Do While bolReadConfigFile Try ConfigurationHandler.ReadConfigData() bolReadConfigFile = False Catch exCH As ConfigurationHandlerException Dim objResult As DialogResult objResult = Messag ...Show All

• Visual Studio Express Editions Running side by side VS .net 2003, 2005 Express Beta 2 and 2005 Beta 2 Team System for Developers

  Hi, I currently run VS .net 2003 and Express Beta 2 for J# and C# on my test machine. I want to know can I also install VS .net 2005 Team System for Developers Beta 2  on same machine. Thanks I'm running into issues configurationg security with sql developers edition. Can ASP 2.0 work security issues with SQL developers edition without having to install the express edition I would appreciate your input. Wayne ...Show All

• SQL Server Measures to columns in Excel

  Dear anyone I am transfering the information from the cube to Excel. My wizard places all measures in the pivot table to one column. I am using Excel 2003. I would like to place the measures to different columns to get a result which is easy to read and copy. Could anyone advice me how this can be done Thanks ! Matti   Thanks for kind help Remi ! This is a question of the layout of the report and the form of the paper. What I get is:                  DimA1      ...Show All

• Software Development for Windows Vista Asynchronous Activity sample

  Is there any sample to run an Activity Aynchronously in beta2 Hi Ravi, By asynchronously do you mean in another thread If so, then this is not supported - the model is one thread per workflow instance. If you mean something else, please give me some more detail. Thanks, Angel ...Show All

• SQL Server Invalid length parameter passed to the SUBSTRING function

  Hi all, I am having a weird issue after we upgraded our DB server to SQL 2005. I have a SP used to extract exchange rate, and a job calls this SP daily. This job worked fine on SQL 2000, and works very well in Management studio if I call this SP seperately, but failed in sql job in 2005. The error statement pointed to: select left(@row, charindex(',', @row)-1), REVERSE(left(@reversedrow, charindex(',', @reversedrow)-1)) The error message is: Invalid length parameter passed to the SUBSTRING function. Anyone knows what's the difference for LEFT function between sql 2000 and 2005 Thanks Bill I would imagine C ...Show All