249 reputation
111
bio website techboy.co.uk
location Milton Keynes, United Kingdom
age 35
visits member for 5 years
seen 10 hours ago

  • GetMeCooking - find recipes online, based on your personal food profile.
  • PlateJobs - find your next job in the UK food service industry.

  • An SAP BASIS consultant who likes all technology, gadgets, sports and too many other things.

    Has dabbled in:

    ABAP, BASIC, Pascal, C# .net, COBOL, Cold Fusion, CSS, Google App Inventor for Android, Javascript, Java, Java for Android, C++, HAML, HTML, XHTML, HTMLB (for SAP ITS), PHP, SASS, SQL, VB, XML as well as others - but I don't confess to being an expert in any of them ;-)


    Jul
    28
    accepted How to export data from Excel to SQL Azure?
    Jul
    28
    asked How to export data from Excel to SQL Azure?
    Mar
    19
    accepted Is there a registry key to disable sounds on the SAP GUI?
    Nov
    29
    accepted Why are the hard disks on a Windows Home Server always active?
    Nov
    15
    awarded  Tumbleweed
    Nov
    8
    asked Is there a registry key to disable sounds on the SAP GUI?
    Nov
    8
    awarded  Citizen Patrol
    Sep
    19
    comment How to hide rows in Excel if all of the columns are not blank?
    Great workaround - thanks! Please note it's a , instead of a ;. i.e. =COUNTIF(C2:K2,"")
    Sep
    19
    accepted How to hide rows in Excel if all of the columns are not blank?
    Sep
    19
    asked How to hide rows in Excel if all of the columns are not blank?
    May
    5
    awarded  Student
    Nov
    27
    comment What is the best way to manually edit and update data within a large table in MS SQL Server?
    Thanks, but as mentioned I actually need to update a lot of data at a time. I should have explained my question better though because I can use SSMS, but it's a bit clunky. I think I'm going to stick with exporting it to Excel (I can then manipulate the data in there - sort, highlight missing entries, etc.) and then re-import it back into MS SQL.
    Nov
    27
    awarded  Commentator
    Nov
    27
    accepted What is the best way to manually edit and update data within a large table in MS SQL Server?
    Nov
    27
    comment What is the best way to manually edit and update data within a large table in MS SQL Server?
    The table is referenced by a web service to get information about ingredients. Although I won't edit the table on the production server - I can edit it in the test server and then publish it to production later. Thanks.
    Nov
    27
    comment What is the best way to manually edit and update data within a large table in MS SQL Server?
    Yes I have MS Access and SSMS available.
    Nov
    27
    revised What is the best way to manually edit and update data within a large table in MS SQL Server?
    added 3 characters in body; edited title; added 3 characters in body
    Nov
    27
    asked What is the best way to manually edit and update data within a large table in MS SQL Server?
    Oct
    8
    awarded  Yearling
    Jun
    5
    awarded  Popular Question