satya n's Q&A profile

• SQL Server Lookup Transform

  Hi! I am a newbie, grateful for some help. I have a Source Ole DB w sql-command selecting the customer.salary and customer.occupation, which I want to match with demo_id in Ole DB destination. salary, occupation also in dim_demographic. But in Lookup editor I find no column demo_id... how do I do this   curiousss wrote: OLE db Source column: SELECT   Sum,  k.sum-p.price AS Profit, convert (char(8),date,112) as Date_id, salary, occupation , k.shop_id, k.customer_no, salesperson_id, p.articlenr,campain_id   FROM Purchase k join product p on k.articlenr=p.articlenr join customer ku on k.customernr=ku.customernr Destination column: demo_id , Profit, customer_id, product_id, shop_id, date_id, sum, salesp ...Show All

• SQL Server Calculating Subtotal for Hidden Matrix Column

  Hi guys, I have this matrix as shown below Column 1 is visible, but Column 2 is hidden, with a width set to 0. The problem is, I want to have the subtotal of Column 2 shown instead of column 1,  next, I want the subtotal of Column 2 to be divided by a Field called (Fields!Divisor.Value) and this field to be shown. How do I go about doing that A small problem I've encountered also is that no matter how I set width of the column to 0, it always changes back to a minute value e.g 0.03125in, is this normal   Thanks for any help given. Anyone can help with this I have searched the forum fervently for answers and tried several methods and am still stuck with it. ...Show All

• SQL Server Need textboxs in a table to show zeros if no record found - not a NoRows message

  I need a way to have the text boxes in a table to show a 0 if there is no record found for the query (not looking for a NoRows message). I've tried setting a default value for the textbox, but it isn't displayed since the query is empty. Is there a way to setup the query to have an if statement that would return a value of zero for the fields as in: If recordcount =0 then set field to 0 stupid question, but is your textbox set to visible ! try the expression ="test" and test if you see it, if this works, the IIF should also work you could also try to change the format of the cell greets ...Show All

• Windows Forms Passing URL parameters to Bootstrapper

  Hi, I’m passing URL parameters to application manifest without problem, but when someone has to use the bootstrapper (setup.exe), it launch the application manifest without passing url parameters. I’ve tried with setup.exe param1=param1Value&param2=param2Value but It doesnt work. I wouldnt like to save setup.exe on hard drive and use -url command-line parameter. Is there another way to do that Thank you Jesus ...Show All

• Smart Device Development Localize Network Folder

  Hi, I need to localize the Network folder (name). How can I do this Thanks in advance, Stefano With WNetAddConnection3 I connect a PC folder to my device. I'll find this folder under the <Network> folder on my PDA. If the operating system is english, this folder is Network, if it's italian is Rete. I need a function to get the localized name. ...Show All

• Visual Studio Express Editions About Mutex veriable

  Hi, I have a problem in mutex veriables Actually I want to create a mutex variable and use it in another aplliaction which I have to run from current application. So How should I create the mutex variable and use that in other application and also how should I run another exe from a current application Pls help me out waiting for reply Thanks, Nilesh Nilesh Ingale wrote: Thanks for ur reply... I tried as above. But now it gives me "Access Voilation" error in 2nd application Pls suggest me something Waiting for ur reply Thanks, Nilesh At what point did you get an access violation Did you trace through the code in the debugger ...Show All

• Visual C# IE toolbar

  how can i add a wish (ideal)toolbar to IE (codes and states) hi, didn't you ask the same question b4 http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=635967&SiteID=1 if you can't see you previous thread click Mythreads link at the top of this forum hope this helps ...Show All

• Visual C++ Compiling VS 2005 to a mounted network share

  We tried to build a C++ project with Visual Studio 20005 om a shared network drive. The network is workgrop based. In that case we get the error message below: Buildprotokoll Erstellen wurde gestartet: Projekt: "test05", Konfiguration: "Debug|Win32" Befehlszeilen Die temporare Datei "h:\testvc\test05\Debug\RSP00000127282544.rsp" wird erstellt. Inhalt: [ /Od /D "WIN32" /D "_DEBUG" /D "_CONSOLE" /D "_UNICODE" /D "UNICODE" /Gm /EHsc /RTC1 /MDd /Yu"stdafx.h" /Fp"Debug\test05.pch" /Fo"Debug\\" /Fd"Debug\vc80.pdb" /W3 /c /Wp64 /ZI /TP .\test05.cpp ] ...Show All

• SQL Server Can I filter the data on mining structure, mining model?

  I perform data mining on all products and a specific product category. Do I need to create 2 data source views, one for all products and the other one for the specific product category Afterward, I run the Data Mining Wizard 2 times to create 2 mining structures. I also need to add the same mining model (e.g. Bayes, Cluster) to each of these mining structures. Is there any simple way to do it Thanks. Joe. Yes you'd need to use two data sources. However instead of going through the wizard twice and recreating all the contained models, you could use SQL Mgmt Studio to script the mining structure and its contained models, modify the name in the generated script and then run t. To do this, right-click on t ...Show All

• Visual Studio Express Editions How to delete selected row in datagridview?

  Hi, how do I permanently delete selected row in datagridview as well as permanently deleting it in my .mdb file . Thought of using oledbcommand or something but I am still a beginner in C# so not familiar with Oledb. Thanks. the OleDbType is not the field size but the field type (Numeric, varchar, binary etc....) which must be the same as the field in the database table column. In regards to the field size, the next parameter, it would be the size of the length of data you are going to be inserting, or perhaps the length of the field given in the database table schema (when you were designing the table in designer view for example, you were able to set a field length. This would be the value) Be sure that the field length is ...Show All

• .NET Development No connection could be made because the target machine actively refused it

  Hi I experience problem accessing a web service installed on my development machine. If I create an ASP.Net web site, I can access the web service with no problem. I need to access the web service from a C# windows application. In order to do that, I added the webservice as a web reference to the project, initialise the proxy class. when I try to access a webservice service, I get the following exception. I am not binding the webservice to any port. Here is a code snippet: public Form1() { tmp = new TmpConvertProxy.Service(); tmp.ConvertTemperature(100); InitializeComponent(); } My IIS is setup so that anonymous access is enable. Can anyone help Thanks Frustrated Chris System.Net.WebException was unhandled Me ...Show All

• SQL Server installing sqlExpress (Advanced Services) will this break existing sqlExpress?

  hiya, I have sqlExpress and sqlServerManagementStudio on my XP pro box. Will the installation of sqlExpress (Advanced Services) cause any problems IS thereanything that I shold be aware of in advance many thanks, yogi hi, it should not cause problems, as up to 16 different instances can be installed side by side, and at different service pack level as well.. so you can install a new instance of SQLX + Advanced Services as long as you provide a different instance name.. regards ...Show All

• SQL Server distributed install - connection error

  we have a sql server 2005 reporting services distributed installation db server has: sqldb01\dev, sqldb01\tst, sqldb01\beta web server is TestWeb01. This had dev, tst, beta installations of report server all reports are working ok except on beta. Beta was setup just a couple days ago so it has not worked thus far. all reports use a shared data source on beta(just like on dev and tst) here is the error on beta for all the reports: any idea (SQLDB01_DEV is not the shared data source name. SQLDB01_DEV was used by the developer when creating the report. But this should not matter right The report should ignore this and use the shared data source i assume ) An error has occurred during report processing. Cannot cre ...Show All

• Visual Studio Any way to build a debug engine with Managed code??

  All the examples and documentation I can find about building a debug engine is in Un-Managed code. Are the same interfaces available in Managed code, and if so, where would I find them Thanks in advance Hi guys, If you are interested in managed sample for Custom Debugger, please vote for it. That is my post with links from " Creating Custom Debugger " thread: Dmitry Pavlov wrote: Hi guys, I am also VERY interested in good MPF sample for Custom Debugger. I have created the request for adding the Custom Debugger sample to next VSSDK version . Note, that you will need to use your NET.Passport ...Show All

• Visual C# 同 How to use c # to write shrinking algorithm?

  Algorithm use c # language is described shrinking Can write the code example thanks ----------------------------------------------------------- --This is group of data ,Judge next number through these datas What method have ----------------------------------------- 1: 019 　 2: 484 　 3: 733 　 4: 313 　 5: 736 　 6: 255 　 7: 459 　 8: 558 　 9: 504 　 10: 735 　 11: 193 　 12: 035 13: 550 　 14: 814 15: 916 16: ...Show All