Horus_Kol's Q&A profile
SQL Server CAST function problem
Hi, I am facing problem while using CAST function. Here i am using SUM function inside CAST function and assigning the returned value to a variable which is of varchar datatype of length 100. The variable which i am using inside SUM function is big int. I am doing like this: @hour = (select CAST(SUM(totaltime) as varchar(100) from 'Table name' It was getting error like: Unable to convert varchar datatype to bigint. How can i resolve this problem.. Regards, Sarat Just wondering - why not use: select @hour = CAST ( SUM ( x ) as varchar ( 100 )) from #X rather than: SET @hour = (SELECT .... ...Show All
SQL Server Column Grand Totals
Is there a slick way to add grand totals to my report so far, in my report table I have the following sections TableHeader1 TableHeader2 Group1 Footer1 I added one of the same fields from my Group1 to Footer1....but it's not summing correctly. I have this in my footer right below one of my Group Fields: =SUM(Round(((Fields!FeeGoal_AZ.Value) / Fields!FeeSchedule.Value) * 100)) From the expression it looks like you are summing up percentage values Is this really what you want Maybe you are actually looking for the average percentage value E.g. =Avg(Fields!FeeGoal_AZ.Value / Fields!FeeSchedule.Value * 100) ...Show All
Visual C++ invoking cl.exe using CreateProcess
I have a program which uses the cpp to parse input files. It invokes cl.exe using CreateProcess. However, I get the errormsg about mspdb80.dll. I have run vvcvarsall.bat, and from the command line it works normally. I can sove the problem by copying all the necessary files of the C compiler into a different folder and adding that to the path. Is there perhaps a more elegant solution I think that simple solution is to run this program with environment variables set to VS variables. For example, you can create batch file which calls vcvarsall.bat and then your program. ...Show All
Visual Studio Error: "Project Factory is unable to create an instance of ......" when using VS2005 release
Hi, I have opened a report project and developed reports (rdl) in VS2005 beta. Since VS2005 release is ready, I upgraded the beta version to the release version. However, when I open the report project in the release VS2005, it prompts the message: Project Factory is unable to create an instance of: Microsoft.ReportDesigner.Project.ReportProjectManager, Microsoft.ReportingServices.Designer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 and the project cannot be opened. Also, I try to create a new report project but also failed with the same message. Does anyone have similar experience Any solution o ...Show All
SQL Server Does SSIS have these features????
1> Support for rules based and change-data-capture extracts 2> Push and Pull methods supported 3> Convert between ASCII and EBCDIC 4> Ability to extract from packages like SAP and Peoplesoft natively 5> Extract from multiple sources simultaneously 6> Support for native database features like database bulk loaders 1. Can you elaborate on what you mean here 2. As above 3. Don't know to be honest. I would imagine so but don't take my word for it. 4. Microsoft recently released a feature pack for SSIS that contains a SA ...Show All
Windows Forms Unhooking Parent events
I have a control that needs to hook a couple of it's parents events so I'm planning on overriding the OnParentChanged event. Where is the proper place to unhook these events if the parent changes As far as I can tell, you don't have access to the previous parent in the OnParentChanged event. Thanks, Ray OnParentChanged would be the best place to handle this, you just need to store a reference to the previous parent, for example: private Control _PreviousParent; protected override void OnParentChanged(EventArgs e) { base .OnParentChanged(e); if (_PreviousParent! ...Show All
Visual Basic CANT DEPLOT APPLICATION
Ok this is my first time doing this click once deployment thingy But im trying to basiclly deploy my application so that others can download and use it the problem is i dont know where to deploy it to I need help i tried microsofts website but it wont let me get acess to it. I would have thought it was obvious that Microsoft is not providing web space for every person who downloads an Express version. You can deploy to your local machine. If you want people to be able to download it, then you need to provide server space. ...Show All
SQL Server SQL Sample?
Hi! This concerns SQL errors showing up unexpectedly and a "Sample" application. I am running Windows XP Pro SP2 on a Dell 8600 Laptop. It is the only computer I own (or want to own) therefore, home networking not an option. A simple, stand alone computer is all I need or want, yet sometime around September or October '05 whenever I booted up, I was getting SQL error messages (e.g., missing SQLsvc file). While trying to find the problem, I was seeing indications in various places that Windows NT was my OS (what happened to Windows XP as my OS ). I'm not sure how all that happened, I certainly did not intend to make any such ...Show All
Visual Studio VSS 6.0 - Error Reading from file.
Hello All, I had configured VSS6.0 on my PC to hold all .c programs and some important project documents. Recently, my PC had some problems and XP Prof version was reinstalled on the C drive. The VSS folder resides on the E drive. So, I reinstalled VSS 6.0 on the C drive and connected to the VSS folder. Now I face a problem. It so happens that the contents of some of the folders are not visible at all and when I do a right click on the folder, it gives a message abt me not having sufficient permissions to access the folder. So, I login as administrator and try to set the permissions for myself thru the admin login. But it gives a message, ...Show All
SQL Server Reporting Services Login Error
An error has occurred during report processing. (rsProcessingAborted) Get Online Help Logon failed. (rsLogonFailed) Get Online Help The parameter is incorrect. I can view my report inside of visual studio 2003 no problem, but when I navigate to the http://servername/Reports/Pages/Folder.aspx and click on my report to load inside of IE I get the error. I have serached all over but not able to get a correct answer. Any help woould be greatly appreciated. Thanks It is definitely a data souce error, although it is a strange message. What type of credentials are used to connect to the data source ...Show All
Visual C# Multiple Fonts in a single Label/TextBox Control
Is it possible to set 2 or more fonts for a single Label or TextBox control Suppose I have a string: " Times New roman , Verdana, Lucida Handwriting " like this. This string contains different types of fonts. It is saved in database. I want to show this string in a Label control. As far as I know a label control must set a specific font. If I show this in a label control or TextBox control, it converts in a single font(which is set by me). So how can i implement this. Please Help & Encourage Me. I don't think this is possible unless you ownerdraw the label or create your own custom ...Show All
Visual Studio Team System Default Team Foundation Security Groups appear to be Inadequate
I may be missing something but I only see 2 security groups. - Team Foundation Administrators - Team Foundation Valid Users Why is the Team Foundation Valid Users group not configurable Is there a document that discusses the recommended set of groups I expected to see 4 default security groups as follows: - Project Managers - Architects - Developers - Testers I created a "Team Foundation Developers Group" and mapped the users from an AD domain. I set the permissions of the Developers group as follows: - Access the source control system - Administer shelved changes &nb ...Show All
SQL Server import/export
Hey, I've recently installed sqlServer 2005 express on my laptop so i can take some work away during christams. What I want to do is copy a db from my work machine that is running sql2000, but i have discovered that import/export is not available in the express managment studio and that I can't connect to 2005 from enterprise manager on my work machine. How can I copy a db Managment Studio Express Any advice would be much appreciated. Tim You have two options that are easy: 1) Backup/Restore, the basic syntax looks like: BACKUP Database [foo] RESTORE Dat ...Show All
SQL Server Anaylsis Services over HTTP
Hi guys, I am hoping this will be a quick one. I am using Analysis Services 2000 with SP4 on Windows XP. It is the Developer Edition so I should have all the functionality of the Enterprise Edition without the scalability. Ok, so I have followed the “INF: How to Connect to Analysis Server 2000 By Using HTTP Connection” ( http://support.microsoft.com/ kbid=279489 ) article on MSDN. On completing the steps I did see a blank page, which suggests everything is working properly. However, when I try to connect to Analysis Services via HTTP it is unable to see the OLAP database. I have tried this with the MDX Sample Application, Ex ...Show All
Visual Basic SQL Exception Error
An Error occured whiled establishing a Connection to the server. When connecting to SQL Server 2005, this failure maybe caused by the fact SQL server does not allow remote connections. Ok i went to the manager and eneabled all the protocols wtf is going on. If the sql server is on the same machine you do not need to enable remote connections. With vb 2005 use . instead of (local). Also posting your code without any passwords and usernames will help ...Show All