D--'s Q&A profile

• SQL Server SQL Query

  Hello All, I am using SQL 2000. I have a table as following Table1 Entity name DayNo Percentage Weekday EntityRate 100 ABC 2 11.20 2 200 100 ABC 3 11.00 3 120 100 ABC 2 10.00 2 95 100 ABC 2 12.30 2 80 100 ABC 3 15.00 3 70 The Entity is looked up by DayNo(2 ,3 etc). 2 is for Monday….so on. The dayNo and Weekday will be identical data and may change for the same entity as shown in the tab ...Show All

• Visual Basic Holding execution of the code for a few second

  Trying to find a function that will allow in the middle of the code execution pause for couple of secs. Thank you Use with caution as this literally will stop everything for the duration of the sleep. That means you UI will be completely unresponsive during this time and any code executing on this thread will stop. So it may be better to use for small duration pauses or if you want to remain responsive and want longer peiods you may want to look at the use of timers. ...Show All

• SQL Server Stored Procedure Performance

  Dear Friends, I have this query that work 100% OK. But I want to have better performance. CREATE PROCEDURE [dbo] . [GD_SP_GET_AplicacaoByNome] @prmAplic_Nome as nvarchar ( 100 ) AS IF @prmAplic_Nome = '' OR @prmAplic_Nome = '*' BEGIN SELECT AplicID , Aplicacao , NrUsers , Descontinuada , PacoteXP , Certificada , InstManual , SoShortcut , Custo FROM dbo . Aplicacao WHERE ( Descontinuada = 0 ) END ELSE BEGIN SELECT AplicID , Aplicacao , NrUsers , Descontinuada , PacoteXP , Certificada , InstManual , SoShortcut , Custo FROM dbo . Aplicacao WHERE ( Descontinuada = 0 ) AND Aplicacao LIKE '%' + @prmAplic_Nome + '%' END I ...Show All

• Windows Forms Reporting tool

  Hi all, I'm using Visual Basic 2005 Express edition. I need to use a reporting tool in order to create rich documents that should show data coming from one or more database. What reporting tool could I use Have I to choose Crystal Reports XI or are available other commercial/free solutions Thanks in advance. Thank you very much. Is it also ok in order to make reports from an Access database throught Visual Basic 2005 Express Edition ...Show All

• Visual Studio Express Editions Small problem giving me difficulty...

  I'm new to C++ (very) and would appreciate your help with the following problem... #include <iostream>; using namespace std; int main() {float radi, circumference, radius, volume; int x; cout << "Please enter the desired radius: "; cin >> radi; circumference = 2*3.14*radi; volume = .75*3.14*(radi^3); cout << "The circumference of the sphere is: " << circumference << endl; cout << "The volume of the sphere is: " << volume << endl; cout << "Please enter 1 to terminate the program: "; cin >> x; return 0; } it's giving me an error Error 3 error C2296: '^' : illegal, left operand has type 'float' e:\sphereprogram\sphereprogram.cpp 10 ...Show All

• Visual Basic Data vanishing during run time

  When I enter data into a SQL database and save it, the data that I have just added vanishes, but when I close the applicaiton and re-open it, it's still there - is there any reason for this and any way to get it to stay Hi, Vanishes from where textboxes, labels More info needed please. Regards, S_DS ...Show All

• Visual Basic User Control problem

  I have a UserControl which basically shows in a textbox the content of a row in a table relationally linked to another table in a database and also a combobox containing the contents of that second table. This mean that as you travel through the main table you can see what the linked text entries are and have a combobox when entering a new record. I started the table in VB.NET 2002 and upgraded it to VB2005 Express and have been using it successfully for some months.So, it has saved considerable code and added to my VB skills. However, having recently discovered the MaxDropDown size property for the combobox I wanted to add a line to the UserControl to fix the MaxDropDown size to be the size of the records in the table it accesses. T ...Show All

• SQL Server Redirect Rows Move good and bad recs to bad table.

  I use a redirect row method for error of OLE DB Destination For sqlServer2005. For some resone even though only 1 record has error and should be redirect, all the record in the current batch (I think depending on the "maximum insert commit size") are redirect. the only way for me to get the exact bad record is to set the above parameter to 1, but then it takes hours to run the package. also I always get the same error in the errorCode column - " -1071607685" why Gal1 wrote: 1. I do use the identity column. And I can't do it otherwize (I use the identity columns heavily...) Yes, but you don't need the identity column in the data flow. If it's not in the data ...Show All

• SQL Server ParallelPeriod that never returns null

  I'm sure this is easy, but I haven't been able to cook up the secret sauce:  I need a function like ParallelPeriod that will always return a member (unless I'm asking for a member that predates the oldest member in the dimension, when null is perfectly fine). For example, ParallelPeriod([Month],1,[2006].[December].[31]) returns null.  Instead, I want to get back [2006].[November].[30] (the last day of the month). What's the secret   OK, I see the pattern. The solution you propose above won't quite work (think of March), but it's close enough to something that will work to see where to take it. If I decide that I really need this function, I'll probably go with the first suggestion you made, since I can stil ...Show All

• SQL Server Altering multiple objects schema

  Hi, I need to change the schema of the stored procedures of several databases. Is there a way to put the alter schema statement within a loop that automaticaly processes all the stored procedures in a given database thank you Probably your best option is to use a cursor. You can find more information about them in BOL ( http://msdn2.microsoft.com/en-us/library/ms180169.aspx ) -Raul Garcia SDE/T SQL Server Engine ...Show All

• Visual Studio 2008 (Pre-release) How to control layout of objects on the Status Bar?

  Hi, I have a StatusBar and would like to implement a layout with some items on the left, some on the right, etc... nothing terribly complicated or inventive. Unfortunately I can't figure out how to do it. It looked like Petzold had cracked the code on this one, but his technique doesn't work for me either: http://www.charlespetzold.com/blog/2006/05/030215.html Any help would be appreciated, Justin Voshell here is a sample string [] s = new string [11]; for ( int i = 0; i < 10; i++) { s = (i < 5) "L" : "R" ; } s[10] = "" ;//dummy so this will take the space in between st1.ItemsSource = s; < Style TargetType = " {x:Type Stat ...Show All

• Software Development for Windows Vista Integration with VS2005 IDE

  I'm missing some obvious... I've got VS2005 Team System for Developer, installed WinFx Components 3.0 Beta 2, VS code "Orcas" Tech Preview - Dev tools for WinFx, Windows SDK. However when I try to install Visual Studio 2005 Extensions for Windows Workflow Foundation it simply brings up the SDK repair options with no mention of WWF. When I open VS2005 I can see the System.Workflow... namespaces but I I don't seem to have any designers or new items etc. Where have I gone wrong The Visual Studio extensions for WF are not included in the Orcas tech preview and must be installed separately. Can you please describe your attempt to install the Visual Studio extensions for WF in more detail. Also let us know what version ...Show All

• Visual Studio Express Editions Planning a project

  I have an Excel system that does the in-store accounting for 15 gas stations\convience stores. I call it a system because I did not know very much at all about programming or visual basic to start with when I put it together back in '01. There are buttons on a screen that invoke code for forms that accept input which is placed in cells on the spreadsheet. Other cells have formulas. Basically, in a nut shell, I made the spread sheets do the work that the managers used to do by hand. Some things I just do not understand. I am a "picture" thinker, so often "word discriptions" just do not sink in. 1. Class If I want to have a class that has properties and methods for Fuel grades, do I write a stand alone class ...Show All

• Internet Explorer Development IE 7 opening to Run Once page with error on it.

  I downloaded updates last week. I have been using IE7 for a while with no problem. I dwnloaded the updates. Now when I open my browser the page tries to go to http://runonce.msn.com/runonce2.aspx . There is an error reported for this page and it will not open up I get a blue screen. How do I eliminate this I have my home page set in the tools section but when opening it won't go to my home page until I hit the home button on the tool bar. I tried the solution I typed in gpedit.msc and the run box and windows error appeared that said that windows could not fine the file. I searched for the file and it was not located either. ...Show All

• .NET Development How to perform inner join with ADO.NET?

  I have a datatable that contains 3 int columns which comprise the Primary Key. Here are is how it is designed. [MaterialID, WidthID, ThicknessID] == [4,12,28] I want to peform a inner join on the ADO.NET client side. [MaterialID, WidthID, ThicknessID] == [STEEL, 4.5, 9.8] Filtering, Finding, ChildRows ----------------------------- Is there a easy way to perform this operation I have checked into using the relations and doing it manually within code, using the GetChildRows. I want to know if there is a simpler way to do this Ado.Net Designer Way ------------------------ Or, Would I have to create a new datatable in my dataset to perform this operation Then set the stored procedure on datatable to perform this for me ...Show All