mokong

Using SQL I have to SUM the total of each game but I can only select the games that have more than 10 scores in total . So `select GameNo,sum(goals) from tblGame, tblAthlete.` But I'm stuck on the 'where' bit.....`select GameNO where (sum(goals)>=10);` So not only do I have to …

Hi All, I am trying to link two database in different servers. Are there any ways I can do this? If this possible, could anyone show me how to do it. I've been googling it a few weeks ago, there are sites that said to use the sp_addlinkedserver but I …

Hello, I am interested in getting sql language certification. I have some knowledge and would want to know how much I have to learn more to pass the exam. Also which site to use for passing, so it would be worth spent money, so my resume would look better? I …

hi... can someone help me with the codes..... when i search for the person only the data of that person appears on the form... i want also to show the picture of the person being search... how can i do that?.... can it be save within the adodc connection?... BTW.. …

Hi. Good day! Hope you could help me through this. I'm having trouble with my customize table sorting in BIDS. i used this formula in group sorting. [CODE] =Switch(Fields!AGE_CAT.Value = "0 - 1", 1, Fields!AGE_CAT.Value = "2 - 4", 2, Fields!AGE_CAT.Value = "5 - 9", 3, Fields!AGE_CAT.Value = "10 - …

how do i delete all the data which is stored in the sql table???? i want to delete only the data present in one table without dropping the table when i click on the command button in vb6 plz help :(:(:(:( its really urgent

hi guys, i have a problem regarding on how to view the image in the database when i select one information in my list view. and change it when i select another. Public Sub studentList() Me.ListView1.ListItems.clear Set rs = New ADODB.Recordset With rs .Open "select * from tblStudentProfile", db, 3, …

HElp

Hello can someone teach me how to delete the selected item in data grid? please i really need it. thanks.

can u help me put codes in the search button pls? here's my program tnx [url]http://www.mediafire.com/?21sprht484fb4qp[/url]

Hi, i have a problem regarding on my laptop. It is ECS elitegroup. The problem starts when my cousin borrows my laptop for her to make a reviewer. While she is typing on a Microsoft Word 2007, it suddenly hangs. Well, my cousin is not a techie person, so she …

Hi, I install windows 7 on my desktop and i forgot to turn off the automatic updates. Well, Microsoft detects that my windows 7 is not genuine. My problem is: 1. My desktop turns black screen, even I set a picture as my desktop background and when i restart it …