jsdude99's Q&A profile

• SQL Server T-SQL to Find Differences Between Two Tables

  Hello, I have got two tables 05FS and 06FS. I came up with a pretty straightforward query that is going to look at two tables and figure out which students changed their academic programs in 06FS semester. A query looks like something like that: SELECT * FROM 06FS a INNER JOIN 05FS b ON a.Studentid = b.Studentid WHERE a.AcadProgram <> b.AcadProgram . The problem with this query is that I also get students who have more than one academic program such as studentid: 1, and 3 and didn't change their academic program(s). Is there a way to weed out those students whose academic program didn't change and they have more than one academic program Any ideas are greatly appreciated! Data: Table 06FS ...Show All

• SQL Server How do I update a field only if update value is not null?

  Hi. I'm not  such an expert in sql and I wanted to update a table's fields only if the value that im going to update it with is not null. How do I do that What I mean is something like: --------------------------------------------------- Update database.dbo.table set if(@newvalue !=null)      afield = @newvalue; -------------------------------------------------   Really need your help on this. Thanks. What about this by using ISNULL in the SET statement: UPDATE Crmworks . dbo . Lead SET Lead_PersonFirstName = ISNULL(@firstname, Lead_PersonFirstName), Lead_PersonLastName = ISNULL( @lastname, Lead_PersonLastName), Lead_CompanyA ...Show All

• SQL Server visual c++ / sql server application

  hi, i have a task to make application for table partitioning in SQL server 2005. the problem for me is that i have to do it using Visual C++. So i just wanted to see if anyone has useful ideas that can tell me. I read in some VC++ tutorial that VC++ can debugg T-SQL commands, so should i use that I'd just need some basic ideas, like how so start.... I think it would be the best if i saw some examples, but i don't know where to find them.... so if anyone can please help, i'd apprechiate it very much. thanx Check this out: http://www.functionx.com/cpp/index.htm Buck Woody ...Show All

• Visual Studio Express Editions How do i get my text application to be able 2 insert a picture into the rich text box

  I need to be able to use the rich textbox for text and pictures but i dont know how to get it to allow pictures You can insert a picture in an RTB by pasting it from the clipboard. Check this thread for code. ...Show All

• SQL Server What is schema ?

  Hi, I am new to SQL Server and started it with SQL Server Express. I tried unfruitful to know about 'Schema' in SQL Server. I have to mention it as prefix for table name in SQL query. But if it is in "dbo" schema, it is not required. Please tell me about it.. Thanks http://msdn2.microsoft.com/en-us/library/ms190387.aspx ...Show All

• Windows Live Developer Forums Problem with map.Find() method

  I am having trouble getting the callback method I specify to fire when I do not specify BOTH a "what" and a "where" value when calling myMap.Find(). e.g. Callback DOES NOT FIRE with the following code: map.FindLocation('', document.getElementById('uiTxtAddress').value , '1', , myCallbackFunction); but DOES FIRE with the following code (IF a Burger King is found within the map view): map.FindLocation('Burger King', document.getElementById('uiTxtAddress').value , '1', , myCallbackFunction); In addition, the following code yields an exception when the uiTxtLandmark text box contains no text: map.FindLocation ( document.getElementById('uiTxtLandmark').value , document.getElemen ...Show All

• Visual Basic [OTP]Visual Basic 6.0 and MS Access linking pictures!

  Hey all, im a student in a UK college, using VB for my coursework in computing. Basically, i can't get a hold of the code for something which i think is important in my project. First, let me put it into context, my project consists of a program for use in an opticians, so "stock control" is one of the forms. Thus, i have a database of the available spectacles, linked to the form via an ADO control. My intention was to place images in the database, then have a set space on the form in which the image will change according to the record. E.g. if i move "next, next, last" the image would correspond to the last set of spectacles. I tried a basic hyperlink from the directory in the database (which is MS access btw) but that didn't seem t ...Show All

• Software Development for Windows Vista Windows Desktop Fade-to-Gray

  In Windows XP when you click the "Turn off computer" button on the start menu, a dialog appears asking what you would like to do, but it also slowly grays out the Desktop. I'm interested in integrating that feature into a small application I'm writing. When the user clicks on the "Display" button in my program a window pops up with the information they requested. I would like to fade the desktop to gray when this happens. I'm writing this app for Vista, but I can't find the system calls or functions anywhere in the Vista MSDN library. Perhaps I'm looking in the wrong places so a little guidance would be helpful. Thanks, Christopher Take a look at this Code Project article where someone ...Show All

• Windows Forms Command Line in Windows Forms

  Anyone, I have been asked to create a windows form (or multiple) that will allow the end user to run several command lines in one application. Basically the network guys need to be able to have 1 window opened and have 4 command prompts available to use at once. I know they could open 4 dos windows, but it's a long story. I would be happy just to know how to build 1. How can I make a windows form in VB.NET 2005 and have basically a dos prompt sitting there waiting for the user to type Thanks. well you can do this BUT they can only type in when prompted to enter inputs via your application. So if you have a project right now, Winforms app, right click on the project then go to properti ...Show All

• SQL Server Migrating DTS packages Question: Dynamic Properties

  Hi guys, After DTS Migration is "successful", I opened up dynamic properties step but I saw codes were all commented out inside the public class ScriptMain. Since I am not familiar with Microsoft.SqlServer.Dts.Runtime , I'm not sure what methods I should use as there aren't much examples available online. How do I do the following in SISS way ' Add your code here ' Source Type = 2 ' Global variable = glvTrade ' Destination = 'Connections';'Trade';'OLEDBProperties';'Data Source';'Properties';'Value' Regards Hi, I have same problem too. ' Source(Type = 2) ' Global variable = SPLastDate ' Destination = 'Tasks';'DTSTask_DTSExecuteSQLTask_7';'Properties'; ...Show All

• Software Development for Windows Vista Cant execute applications compiled in VS2005

  If I try to Compile and run an application in Vista RC1/VS2005, the app compiles, but wont run. Its gives me an error like "No execute permission". It should be mentioned that my VS2005 was installed on XP, and that I upgraded this installation to Vista RC1. Im thinking its some sort of local policy / user rights problem (Im running with Adm rights on my account). Hi, Thanks for your advice. The manifest file was helpfull,- however i did not do the trick alone. The project directory was (from my old XP installation) encryptet, and VS2005 apperently cant cope with an "old upgraded encrypted dir" for its binaryes. Once I disabled the encryption on the di ...Show All

• Visual C++ CWinThread derived Object and Menu trouble

  Hello I can't find my previous question so i'll re-ask it; I created few WinThread derived objects With which i send and receive info by posting messages. When i click on the menu While my threads are runing they seems to crash or to terminate their message processing. The thread being terminated not in a clean manner it causes my program to randomly behave. I use these this thread with multiple Windows and in a various range of way but only the menu affects their stability. Does anybody can lead me on the right path to overcome this problem Thanks a lot. After a bit more of thinking and testing. I've found the answer to my problem. As I thought the menu was interacting with my threads but not directly. The P ...Show All

• SQL Server Mdx calculations in AM2005

  Hi. I have 2 fact tables FactCampaign and FactLead. Both link to DimCustomer via CustomerKey. And in each table, there is a datekey - CampaignDateKey in FactCampaign and LeadDateKey in FactLead. I would like to sum up the count where LeadDateKey > CampaignDateKey. Is it possible to achieve that via mdx calculation TIA! The only linkage between these 2 fact tables is the CustomerKey via DimCustomer. No other relationship. Essentially, FactCampaign stores the customers under a certain campaign and I'm trying to find the no. of leads that are generated under each campaign. And yes, I've built a cube using AS2005 based on this schema. I'm not sure whether I should change my schem ...Show All

• SQL Server Tape not available as Backup Device

  I've got a new HP ML370 G4 Server 2003 SP1 with a fresh install of SQL 2005 SP1. I'm trying to create a backup device for the internal HP DAT 40 and tape is greyed out as an option. I have the newest HP software drivers and firmware. The tape drive is seen by Server 2003 device manager and by NTBACKUP. I can backup using that program. Why doesn't SQL 2005 see it I tried a new HP Ultrium tape drive with the same results. Anyone else see this and can recommend a fix TIA Hi, I have the same problem with TimCox but using SQL 2005 not install SP1 yet and I am using a new HP Ultrium tape drive. Already backup using the NT backup and it works fine. What happen with SQL 2005 backup The error message is : ...Show All

• SharePoint Products and Technologies Site Actions missing in the main page

  I have a list of employees information in a HR Sharepoint site. Is there a way making the sharepoint automatically assign permissions to people in the list Help would be appreciated. If you lok at the Markup in the Master Page for the site, you will notice that there are some security assertions made in the MSterPage to limit what folks see what in regards to the SiteAction Menu. Not knowing exactly WHAT you did when you say "You deleted some groups" I would say that I don't have enough infomration to help you ... Can you create another site and if so, does it have the SiteActions Menu If Not, Can you create a new Site Collection, New Site and does IT have the menu.. My Thought is tha ...Show All