mokong

Hi you must use HAVING to condition an aggregate. see this: HAVING SUM(GOAL) >= 10 thanks, Mokong

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 …

Hi All, I'm also going for a training for MS SQL Certification. Would you let us know what to expect in the certification exam? What should we prepare, tips you could share to us.. Actually, I am very nervous about it, coz it will cost too much. I'm thanking you …

yeah.. how the picture is being stored in the database. you can use commondialog for uploading and reloading your picture. hope this will solve your problems.

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 - …

[CODE] ADODC1.Recordset.Delete [/CODE]

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, …

i can provide you codes but i dont know what your searching..

you can use this code: hope it works. [CODE] set conn = new adodb.connection conn = "your connection string" set rs = new adodb.recordset rs.open "Delete * from tablename where columnname = '" & Listview1.listitems.text & "',conn,3,3 [/CODE]

Hi you can use my code: [CODE]dbase ListView1.ListItems.clear If Me.cboSearchBy.Text <> "" Then Set rs = New ADODB.Recordset rs.Open "SELECT * FROM tblStudentProfile WHERE " & Me.cboSearchBy.Text & " LIKE '%" & Me.txtSearchField.Text & "%'", db, 3, 3 If Not rs.EOF Then Do Until rs.EOF With rs ListView1.ListItems.Add , , …

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 …