nature0276's Q&A profile

• SQL Server count of null values in columns

  Hi, I would like to ask how can I get count of null values in each column together I know I can use COUNT(*) - COUNT(<col>), but I need to explicitly name every column in the query.... is it possible without it here is the sample code (please note that this can be writen in a better way.): declare @tableName sysname set @tableName = 'TableWithFewColumns' -- you can create a proc with following code with above one as param declare @strSQL varchar ( 8000 ) if object_id ( 'tempdb..#columns' ) is not null drop table #columns create table #columns ( colName varchar ( 255 )) insert into #columns exec ( 'select name from syscolumns (no ...Show All

• Visual Studio Nested SQL For Crystal Report

  Dear All, I am very new to crystal report. My problem is quite simple. First I have a table as branch and another one is employee. So I am doing first a select * from branch. Then based on each branchID I do another sql search called as select * from employee where employee.branchID=branchID.branchID. So how do I go about crystal to create this form of reports.Thus the second query is nested in the first query. I want my report to be formatted in this way Branch 1 Employee 1 Employee 2 Branch 2 Employee 3 Employee 4 Employee 5 Can some one pls help me I am very new to crystal reports. Thanks in advance. Hi, I have removed the "+" and put th ...Show All

• SQL Server Error Creating DSN using odbcconf.exe for SQL Server

  hi there i want to create a DSN using command line arguments,with Trusted connection=no, Login name= sa password=******* i try creating like this C:\>odbcconf.exe /a {CONFIGSYSDSN "SQL Server" "DSN=blabla|Description=blablubb|SERVER=vsnet1|Trusted_Connection=no |Database=dm"} this work fine, but when i specify the login id & password as C:\>odbcconf.exe /a {CONFIGSYSDSN "SQL Server" "DSN=blabla|Description=blablubb|SERVER=vsnet1|Trusted_Connection=no|loginid=sa|password=sysadm|Database=dm"} this throws an error as CONFIGSYSDSN: Unable to create a data source for the 'SQL Server' Driver: Invalid keyword-value pair with error code :2147467259 I too try the loginID, ...Show All

• Visual FoxPro Grid class

  I have made my own grid base class with 9 columns. When I create a grid based on this class, and I try to reduce the number of columns, I get an error message saying "Member COLUMN# is a class member" (# being the umber just above the one to which I want to change; if I want to go from 9 to 7, # = 8). What am I missing, believing this would work Hans L PS. I wanted to make every column heading centered vertically/horizontally and bold. With column # = -1, this cannot be done, as far as I understand (no columns in Propoerties). And when I set the When to .F. in my Grid class, and, for instance, Valid to .T., and I then look at an instance of the Grid class, Valid shows "Inherited ...", ...Show All

• SQL Server Degenerate Dimension with Partitions

  Backgroud: My cube has 12 Partitions, and I set 12 fact tables to point to them. There is a Degenerate Dimension, which I point to fact table 11. By the Way, the Degenerate Dimension's Key is The fact Table 11's Table_ID, and the Table_ID is possible to be the same between diffrent fact tables 1 to 12. Question 1: when I build the Degenerate Dimension, I can only choose one fact table to match, as you know. then if I ProcessFull the Degenerate Dimension, it will catch the data from other 11 fact tables If the answer is YES, how about the same Table_ID Question 2: If I processFull the Question Degenerate Dimension, need I Process the Partitions 1 to 12, or only to Process the Partition 11, or not need to Process Partitions Question ...Show All

• SQL Server OLEDB Command stage error in SLOWLY CHANGING DIMENSION

  I have created a sample dataflow to parse the employee details (empid,empname,empaddr) from a flat file to oracle 9i database table named employee(columns : empid,empname,empaddress - All are varchar2(15)) using SLOWLY CHANGING DIMENSION transformation for insert/update on the table. EMPID as Businees key EMPNAME and EMPADDR as changing attributes. Connection string is using Microsoft oledb provider for oracle. I am getting the following oledb command error. ----------------------------------------------------------------------------------- TITLE: Microsoft Visual Studio ------------------------------ Error at Data Flow Task [OLE DB Command 1 [2007]]: An OLE DB error has occurred. Error code: 0x80040E51. An OLE DB reco ...Show All

• .NET Development Problem about opening Office document in a new Window.

  Hi all (first post yipee), anyway.... currently my web application have an icon that allows the user to edit an office document (word./excel), it is begin brought up by window.open(). However, problem lays here, since this isn't a model/modeless dialog, the user is allowed to go back to the application and reclick the edit icon. This causes the first office document that popped up to become blank and a second office document window will come out. The function of the icon is simple, it just calls window.open(), i am just wondering if there is a way to not allow the user to go back to the parent window and click on the edit icon again. showmodelessdialog() does not work in this case, i have tired opening an excel document with it but it re ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. creating custom effects for .x models

  I want to use a .x file just for the vertex data so I can create my own shaders and try to implement different effects. Does anyone have any samples or tutorials on this Just do a ContentManager.Load<Effect>(@"your\\effect\\here") and add the effect to the content folder. Then assign your effect to the Effect property of one of your model mesh subsets. ...Show All

• Visual Studio Trap print click event

  Hello, Is there a way to trap when the Print button on the crystal report viewer is clicked. Basically i want to trap the print_click event when the print button is clicked and sent to the printer and then close the page that was displaying the crystal report automatically. Technical Info: --Crystal report 11 --Web based application --Asp pages being used to render the report. Hey Abs, wondering if you managed to figure out a solution to this problem I too am in a similar situation. How ever, as Voss Mentioned, it can be done in Winforms, which i am aware of, but the Tech that we are using is again ASP.NET If by any chance, you managed to figure out a solution, would appreciate your hel ...Show All

• .NET Development returning an array of classes from Web Service

  Hi there I am following a web services code example from the book ASP.NET Unleashed (chapter 22, page 972 "XML Web Services and Classes"). Basically a web page is supposed to call a web service that returns news items in the form of an array of classes. Firstly the web service references the following separate class which defines the NewsItem object : using System; namespace MyComponents { public class NewsItem { public string Headline; public DateTime Posted; public string URL; } } The web service code that returns an array of NewsItem classes: using System; using System.ComponentModel; using System.Web.Services; using MyComponents; namespace BetterNewsServ ...Show All

• SQL Server Date question

  I currently get a date in the default format in my stored procedure. Up until now converting the date to type 101 was acceptable. Now they want the date to read something like Wednesday, November 8, 2006 or November 8, 2006. How do I do this convert in a single select statement I found the types that add the time but I have to make sure that the time isn't included for merge reasons. Help Jeff I second what Jens states (unless you are doing a one time data conversion using SQL, then follow the other ideas :). Leave the formatting of dates (and any values) to the presentation layer. There should be some common object that they reuse for all date values that are returned in the ...Show All

• Visual Studio Express Editions Trouble with Button Column in DataGridView

  I actually have three problems related to a button column in my datagridview. 1. I created a column in a datagridview to contain a button in every cell. I cannot get the Text to show up on the button. Under Cell Style under the properties for that column, I've selected the color black for ForeColor and SelectionForeColor and as far as I know, everything else should be set for the text to appear in the button. What could I be missing to set 2. I also cannot get the button to work. I have the following code for the datagridview (it also includes code for my last question). The code in question is in red. Do I need to use different code to call the click method in order to open a form (Tracking_List_Entry_Form) and do other tasks ...Show All

• Visual Basic How do I send the Subform (Datagrid) to a Text File a Text file?

  How to I print a Form and its subform as a Text file or send it to a text files then print the text file using a button Maybe using something like this Please be specific if you can. Thank you Private Sub Button2_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click 'True escribe cada linea debajo en el file the texto "test.txt"./SIN borrar el anterior ' False, prepara un nuevo archivo en cada oportunidad Dim objfile As New System.IO.StreamWriter( "c:\test.txt" , False ) 'Estoy usando este formulario para escribir al formato de texto en el archivo test.txt objfile.WriteLine( "PENA'S ACCOUNTING" ) objfile.WriteLine( "17 Canal Street" ) o ...Show All

• SQL Server Installing SQL Server 2005 Express as Part of My Application

  I have found a lot of info on MS site regarding installing SQL Server 2005 Express as part of an application. I have found these articles to be extremely inaccurate or at best incomplete. 1. The documentation says all I need is the setup.exe from SQLEXP but this is not true. 2. When I do launch setup.exe during my app's install, it fails because setup.exe trys to run the support.msi. Of course this causes failure because my install is also an msi. So, does anyone know how to install SQLEXPRESS as part of my app's install Thanks. Hi Shawn, I think you might be misreading the documentation you've found, Setup.exe is simply a bootstrapper that launches other SQL component installations. You h ...Show All

• Visual Studio Team System Getting Latest Version Error (TF30063)

  I got an error when I try to get the latest version from TFS. TF30063: You are not authorized to access Microsoft-IIS/6.0. Please advice! Thanks Q: Are you using the shipping version (not beta 3 or RC) A: I am using the shipping version. Q: Are you using the version control proxy A: No, I am not using version control proxy. Q: Does this happen for all files or a particular file A: This happened with a particular project in the server Q: Did this just start happening or has it always been a problem A: Always been a problem (Only with a particular project) Q: what changes have been made lately to the server A: No changes have been made to the server ...Show All