Forum Replies Created

Viewing 15 posts - 241 through 255 (of 8,731 total)

  • RE: CASE with LEN Evaluation

    I'm not sure what the problem is, but you're certainly over complicating the conditions. This is a simplified version of your original code.

    CASE
      WHEN [Col1] = '0'...

    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

    February 1, 2019 at 7:29 am

    #2020847

  • RE: Are the posted questions getting worse?

    Today I learned that you can execute UDFs. When I saw the code, I was wondering how they were able to execute a stored procedure inside a function,...

    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

    January 31, 2019 at 2:51 pm

    #2020781

  • RE: Purpose of SELECT before a calcuating the value of a function's return variable

    michael.leach2015 - Thursday, January 31, 2019 10:25 AM

    The examples with assigning values to the variables with SELECT and SET were very...

    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

    January 31, 2019 at 11:09 am

    #2020745

  • RE: Cleaning up the Identity

    Sean Lange - Thursday, January 31, 2019 6:23 AM

    Good question Steve. Pretty shocked that at the time I posted this 12% of...

    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

    January 31, 2019 at 10:58 am

    #2020743

  • RE: Merge Multiple Rows into a logic

    sqlquery29 - Thursday, January 31, 2019 5:53 AM


    I did try...

    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

    January 31, 2019 at 9:19 am

    #2020722

  • RE: Cause of arithmetic overflow error?

    michael.leach2015 - Thursday, January 31, 2019 8:44 AM

    Sue_H - Thursday, January 31, 2019 7:45 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

    January 31, 2019 at 9:16 am

    #2020721

  • RE: How do I convert a uk date in string format to date?

    ChrisM@Work - Thursday, January 31, 2019 7:04 AM

    Lorna-331036 - Thursday, January 31, 2019 6:56 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

    January 31, 2019 at 8:04 am

    #2020704

  • RE: Sort already comma separated list

    ScottPletcher - Wednesday, January 30, 2019 11:38 AM

    This topic comes up so much, I think MS should "fudge" a little on the...

    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

    January 30, 2019 at 11:41 am

    #2020609

  • RE: Trying out a trick.

    HappyGeek - Wednesday, January 30, 2019 11:06 AM

    Did it work?

    It was a success, he found a way not to do what he...

    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

    January 30, 2019 at 11:23 am

    #2020601

  • RE: Sort already comma separated list

    This could be a faster alternative if we consider the measurements used on the performance testings for [DelimitedSplit8K] and [DelimitedSplit8K_Lead].

    CREATE FUNCTION [dbo].[SortDelimitedStringN4K]
    --===== Define I/O parameters
       ...

    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

    January 30, 2019 at 11:18 am

    #2020597

  • RE: Sort already comma separated list

    pietlinden - Wednesday, January 30, 2019 9:36 AM

    (Shows how much I understand about FOR XML... is there a good book on the...

    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

    January 30, 2019 at 9:56 am

    #2020580

  • RE: How to retrieve rows that as been deleted from the result of a DM view

    Stanley Pagenel - Wednesday, January 30, 2019 8:23 AM

    Hi can someone tell me how to retrieve the result of  
    select *
    FROM sys.dm_exec_sessions

    From...

    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

    January 30, 2019 at 9:24 am

    #2020573

  • RE: Sort already comma separated list

    PSB - Wednesday, January 30, 2019 8:45 AM

    ok. That's what I did. Changed them back to individual rows . Then back 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

    January 30, 2019 at 9:21 am

    #2020571

  • RE: Question on grouping

    ScottPletcher - Monday, January 28, 2019 5:06 PM

    drew.allen - Monday, January 28, 2019 4:14 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

    January 29, 2019 at 6:34 am

    #2020399

  • RE: Question on grouping

    thomas.miller1 - Monday, January 28, 2019 1:39 PM

    SELECT

    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

    January 28, 2019 at 2:35 pm

    #2020345

Viewing 15 posts - 241 through 255 (of 8,731 total)