Forum Replies Created

Viewing 15 posts - 931 through 945 (of 8,731 total)

  • RE: Getting the same value in last 3 or digits when using Datetime2 data type in SQL Server 2012

    jay-125866 - Wednesday, October 4, 2017 3:18 PM

    I tried your script earlier and was able to produce the records with same...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    October 5, 2017 at 7:15 am

    #1962463

  • RE: Data Type Precedence

    dale_berta - Thursday, October 5, 2017 5:33 AM

    I'm going to postulate that  the expression evaluator is converting one of the datetimes to...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    October 5, 2017 at 6:44 am

    #1962454

  • RE: Data Type Precedence

    For those who don't understand the addition of dates.
    Datetime is stored internally as 2 integers: one for the date and one for the time. Each date has an...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    October 5, 2017 at 6:41 am

    #1962452

  • RE: Update a #temptable IF @Table_Variable

    Maybe something like this:

    IF NOT EXISTS( SELECT * FROM @EntryPoint WHERE name IN( '<ALL>' , '<NONE>'))
       DELETE FROM #AllCases
       WHERE ISNULL(ColumnEntryPointName, '') NOT IN...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    October 4, 2017 at 1:24 pm

    #1962345

  • RE: Getting the same value in last 3 or digits when using Datetime2 data type in SQL Server 2012

    This is what I tried.

    CREATE TABLE #Dates( SomeDate datetime2)

    DECLARE @n int = 0;
    WHILE @n < 10000
    BEGIN
        INSERT INTO #Dates VALUES(SYSDATETIME())

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    October 4, 2017 at 12:15 pm

    #1962329

  • RE: Getting the same value in last 3 or digits when using Datetime2 data type in SQL Server 2012

    jay-125866 - Wednesday, October 4, 2017 11:43 AM

    I recently started to use datetime2 data type in SQL Server 2012, and found something...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    October 4, 2017 at 12:03 pm

    #1962324

  • RE: Why SQL Server is Better Than Oracle

    kannan_egd - Wednesday, October 4, 2017 4:08 AM

    Yes, I too agree, but when comes to large volume data handling still SQL...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    October 4, 2017 at 7:15 am

    #1962243

  • RE: Find out the number of records in all those tables where a given field appears

    Mark Dalley - Tuesday, October 3, 2017 11:24 AM

    Hello Experts

    I want to look at the various characteristics of the tables in which...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    October 3, 2017 at 12:18 pm

    #1962127

  • RE: Date fun

    sipas - Tuesday, October 3, 2017 6:13 AM

    Luis Cazares - Tuesday, October 3, 2017 5:58 AM

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    October 3, 2017 at 6:47 am

    #1962047

  • RE: Are the posted questions getting worse?

    xsevensinzx - Tuesday, October 3, 2017 6:31 AM

    Well technically, if you're worried about keeping everything on Linux and then you have...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    October 3, 2017 at 6:37 am

    #1962043

  • RE: Are the posted questions getting worse?

    Thom A - Tuesday, October 3, 2017 2:13 AM

    xsevensinzx - Monday, October 2, 2017 7:35 PM

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    October 3, 2017 at 6:31 am

    #1962040

  • RE: Strange COALESCE issue

    R.P.Rozema - Tuesday, October 3, 2017 5:42 AM

    Excellent. Then, while you're still in learning mode ;-), please go on and hone your...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    October 3, 2017 at 6:01 am

    #1962030

  • RE: Date fun

    sipas - Tuesday, October 3, 2017 5:51 AM

    American dates are weird.

    American dates?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    October 3, 2017 at 5:58 am

    #1962029

  • RE: Are the posted questions getting worse?

    jonathan.crawford - Monday, October 2, 2017 12:58 PM

    Luis Cazares - Monday, October 2, 2017 10:10 AM

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    October 2, 2017 at 1:29 pm

    #1961945

  • RE: Strange COALESCE issue

    as1981 - Monday, October 2, 2017 10:55 AM

    The XML path code your provided (thank you) seems to work. it puts a zero...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    October 2, 2017 at 11:07 am

    #1961926

Viewing 15 posts - 931 through 945 (of 8,731 total)