Forum Replies Created

Viewing 15 posts - 1,636 through 1,650 (of 5,109 total)

  • RE: Timzone conversion to IST

    Perhaps this will be better explained with sample data and SQL:

    USE Sandbox;

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Timzone conversion to IST

    sram24_mca - Friday, October 5, 2018 2:48 AM

    Thom A - Friday, October 5, 2018 12:28 AM

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Timzone conversion to IST

    sram24_mca - Thursday, October 4, 2018 11:21 PM

    We tried with UTC datetime in sample table , but there is slight difference...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Timzone conversion to IST

    datetime doesn't store any details of what timezone the value is applicable to. In my opinion, If you're working with multiple timezones, idealing you want to either know the timezone...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Are the posted questions getting worse?

    jasona.work - Thursday, October 4, 2018 10:57 AM

    OK, unrelated to the discussion about who is or isn't "new to SQL," here's a...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Are the posted questions getting worse?

    Brandie Tarvin - Thursday, October 4, 2018 10:39 AM

    Thom A - Thursday, October 4, 2018 9:44 AM

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Are the posted questions getting worse?

    At what point would you suggest that someone is no longer "new to SQL"? Would you suggest that, for example, someone who has been working with SQL Server for at...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: SQL data types

    tmmutsetse - Thursday, October 4, 2018 9:05 AM

    Hi Experts,Please help what data type must i use for these numbers 
     Transaction code 2.011.126 ...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Are the posted questions getting worse?

    jasona.work - Thursday, October 4, 2018 8:16 AM

    OK, the weather is getting really weird around here...
    A couple days ago, needed at least...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Error = [unixODBC][Microsoft][ODBC Driver 17 for SQL Server]Cannot generate SSPI context

    SATYA R - Thursday, October 4, 2018 7:50 AM

    @thom-2 A: -

    You need to configure Kerberos, or use SQL Authentication.       ...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Error = [unixODBC][Microsoft][ODBC Driver 17 for SQL Server]Cannot generate SSPI context

    The error is telling you the problem here. You're trying to use Kerberos authentication on a Server that doesn't support it/doesn't have it configured. You need to configure Kerberos, or...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Adding two fields together

    michael.leach2015 - Wednesday, October 3, 2018 8:04 PM

    Awesome.  It worked.  I totally overlooked the missing comma.

    I thought 'AS' was used only...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: how to looping, check every cells per records and comparing them and count the results?

    gevali80 - Wednesday, October 3, 2018 4:40 AM

    Update :

    check from row 1 since nextid not 0, then go to...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Insert records in to table that has primary key identity seed

    Jeffrey Williams 3188 - Tuesday, October 2, 2018 1:40 PM

    Either way - if you are inserting data into a table that...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Adding two fields together

    You're missing a comma after Compulsory DECIMAL (5,3). Then, for your computed columns, the correct syntax is [Compul and Optionals] AS Compulsory + Optionals, ({Column...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 15 posts - 1,636 through 1,650 (of 5,109 total)