Search results for query: *

Hi all I have written a report to identify referrals with more than 5 appointments, and have been asked to add in the first appointment date. My TSQL script uses ROW_NUMBER() over (partition by a.Uniqueref order by care_contact_dttm) row where Row>5 to select the patients, this works fine. I...

In TSQL 2008 R2 I can't copy results without headers. I have checked the settings in Options>Query Results; Results to Grid and Results to Text both have the 'Include column headers in the results set' unticked. Despite this when I right click on the results pane and just choose Copy I still...

Hi all I want to subtract one day from a dttm field and then return the month and year from the calculated date in short form. EG: If DTTM 01/2/2016 I want to end up with Jan 16. Any help welcome.

Hi all I am trying to use a Vlookup or similar to populate a table from a list containing multiple values in the index column as below: ID TEST RESULT 910 HEPA Not Ok 910 HEPB Ok 1234 HEPB Ok 1234 HEPA OK 5678 HEPA Ok 5678 HEPB OK For each ID I need to return the results of each type of test...

I have a Samsung Q320 which has recently started to switch itself off at random - no blue screen, just goes off. I have to use the power button to restart and it boots into Windows as normal. The event viewer systems log reports a Kernal Processor Power event ID 37, details: 'The speed of...

I have 2 tables called Contacts and Meeting Details, both with fields called Contact_Name and Service_Area. They are joined by Contact_Name. I have created a form based on the Meeting Details table. It uses a Combo box to look up the Customer name. I want it to then auto-populate the...

I needed to provide a dropdown list of many values which also had an autocomplete function, and the script at http://www.contextures.com/xlDataVal11.html works brilliantly, but just one problem. Users can overtype with any value including those not in the list. Is there any way this code can...

Hi For my sins I use Cognos 6. If a report contains date prompts, I usually insert these into the Header, but they appear in format yyyy-mm-dd and I haven't found a way to format them in a more user friendly way. Can anyone help?

I am trying to report on the number of actual workdays between dates, excluding weekends and Bank Holidays. I can use a modified Networkdays formula in Excel, but only if the Work pattern is for continuous days of the week ie: Sunday to Thursday. Problem is that we have staff on work patterns...

Hi I want to write a validation formula to show an error message for the following conditions: if the value in a certain cell <> "S" then the values all of the following 5 cells in the row must be Null, else if the value does equal 'S' then all of the values in the 5 cells must not be Null...

Hi Is it possible to hide the times outside of the work schedule in the one-day calendar view? At present they do appear but are greyed out.

I am working with an old version of Cognos(6) on a HR report to show the number of days absence in any given month. It lists all open ended absences, and also those that ended during a period defined by a date prompt. I've also got it to calculate the number of days absence within the period...

I have an ASROCK K7S41GX board, and want to enable front USB, but the connectors on my case aren't labelled the same as the pinout in the board manual, except for Ground, and there are only 8 connectors, not 9: I have: 1.D+,1.D-, 2.D+, 2.D-, 1.VCC, 2.VCC, 1.Ground , 2.Ground The board has...