Search results for query: *

Thanks for your help. That's a very clear explanation Olaf. I have solved it by using Partition By: SELECT a.CompanyName, a.SearchClosed, a.JOB_CONS1, a.JOB_STATUS, a.JOB_NUMBER, a.JOB_NAME FROM ( SELECT lvl1.CompanyName...

Hi, I'm having trouble returning all the columns from a Grouped By Union query in SQL 2014. I'm trying to return the most recent search closed by company. I should only return 2 records. If I add the extra columns in the Group By clause I get extra unwanted rows. SELECT...

Many thanks to both of you for resolving this. I used George's answer as it is easier to insert into the code.

Can someone please help me out with this query. I get a error because one of the rows has an empty space in the YearEnd column. SELECT a.FirstName + ' ' + a.LastName AS FullName, a.Initial, a.Age, b.Level2Company, b.YearEnd, FROM tblContacts a INNER JOIN tblSalary AS b ON a.CREF =...

Nice solution except I have 160 radio buttons and would have to add 160 onclick events. And what if they decide to change the colour?

Ok, please ignore my last post. This is working: $(document).ready(function() { $("input:checked").closest("td").addClass('style1'); }); $(document).click(function() { $('input:radio').change(function() {...

Thanks for the pointer. I have managed to find some code that will highlight a group (or row in my case) of cells when one of the radio buttons is selected, but I only want the cell <td> highlighted which has the checked radio button. Can anyone tweak this code to highlight just the <td> with...

I have been asked to change our intranet to change the background color of cells when a radiobutton is clicked. There are 160 radio buttons and I'm looking of a way to do this with minimal code changes. Here is an example: <!-- Question 1 --> <tr valign="top"> <td class="style20">...

Hi, I'm having a problem with moving word documents from one file to another. If System.IO.File.Exists("Shared Files\CVs\Original CV\" & objContact.OrigCVFilename) And System.IO.File.Exists("Shared Files\CVs\" & objContact.CVFileName) Then System.IO.File.Move("Shared...

Thanks alot Borislav, that's great!

Can someone please help me with this? DECLARE @REF int DECLARE @PreferredEmail as varchar(50) SET @REF = 102108 SET @PreferredEmail = IF (SELECT WorkEmailPreferred FROM tblContactPersonal WHERE CREF = @REF) =1 BEGIN SELECT Email FROM tblContactPersonal WHERE CREF = @REF END ELSE IF (SELECT...

I have a website written with PHP and MySQL. The company that designed it also hosted it. Now that the hosting is up for renewal, I would like to host it myself on my companies web server. I have been sent the data as a MS SQL Server Query File and the website as PHP files. I don't have either...

For those of you interested, I cracked it. Not very elegant but it works. Public Class CustomSortCriteria Implements IComparer Public Overridable Overloads Function Compare(ByVal Obj1 As Object, _ ByVal Obj2 As Object) As Integer Implements IComparer.Compare...

Hi, I have a column in a Janus datagrid that shows dates as a string in the format 'mm/yyyy'. 04/2004 03/2006 01/2005 03/2005 01/2008 When I sort this column by clicking the column header I get this result 01/2005 01/2008 03/2005 03/2006 04/2004 which is obviously not want I want. I have...

Thanks guys, much appreciated. Pwise and Mutley, your answers both gave the right answer but all were educational. Thanks, again.

We have some corrupt data in our tblCompanyHistory table. I need to find the records Grouped by CREF that have a comp_order not starting with 1. Here is some data. CREF Comp_Order -------------------- 8 1 8 2 8 3 9 2 9 3 10 1 11...

Thanks Dan, I can live with OK and Cancel. With a button I would use this: <asp:Button runat="server" id="btnSubmit" Text="Submit" OnClientClick="return confirm('Proceed');" /> btnSubmit.Attributes.Add("onClick", "return confirm('Proceed');") do you know the code to trigger the...

Hi, I'm not sure if this can be done. I am using ASP.Net 2.0 / VS 2008 / VB I have a page with a dropdownlist of user names. When the list is clicked (or before a user name is changed) I want to display a messagebox reminding the user to Save the current Page. Like: "Have you saved this page?"...

Thanks Jason.

Hi, I'm not sure if this can be done. I am using ASP.Net 2.0 / VS 2008 I have a page with a dropdownlist of user names. When the list is clicked (or before a user name is changed) I want to display a messagebox reminding the user to Save the current Page. Like: "Have you saved this page?"...