Forum Replies Created

Viewing 15 posts - 6,766 through 6,780 (of 8,731 total)

  • RE: Count Number of items by groupings

    It's great, but do you understand how does it work?

    You'll be the one in charge of this for any modification, correction or improvement, so you better understand it. Feel free...

    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

    March 13, 2014 at 2:46 pm

    #1696963

  • RE: Building a hierarchy tree

    I'm not sure on how to create the order you need, but here's an option.

    Be sure to understand it and test it because it might get slow when working with...

    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

    March 13, 2014 at 2:04 pm

    #1696951

  • RE: Count Number of items by groupings

    Do a favor to yourself and use date data types when needed. Using numeric values (or even string values) will only give you headaches.

    Here's a possible solution for you (I'm...

    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

    March 13, 2014 at 12:05 pm

    #1696917

  • RE: Are the posted questions getting worse?

    rodjkidd (3/13/2014)

    I find when answering interview questions, and in particular multiple choice that the following pattern will get you close to 100%

    A B A C A B

    Just repeat until you...

    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

    March 13, 2014 at 11:24 am

    #1696898

  • RE: Grouping of data based on moving time period

    This is certainly ugly, I might come back to improve this query.

    SELECT at.Style,

    STUFF((SELECT ',' + CAST( x.AmendmentID AS varchar(10))

    FROM #AmendTest x

    WHERE at.Style = x.Style

    AND x.DT BETWEEN at.DT AND DATEADD(MI, 30,...

    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

    March 13, 2014 at 11:22 am

    #1696894

  • RE: Count Number of items by groupings

    Could you explain the logic to obtain the expected results?

    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

    March 13, 2014 at 11:06 am

    #1696884

  • RE: Problems with User Defined Function running sql server script

    You need to ask for a complete script, not just the tables' scripts.

    Every object from the original DB should be scripted in the proper order to avoid the problems that...

    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

    March 12, 2014 at 6:36 pm

    #1696601

  • RE: Are the posted questions getting worse?

    dwain.c (3/12/2014)

    Luis Cazares (3/12/2014)

    The Dixie Flatline (3/12/2014)

    I have a database. It doesn't work. Please advise.

    Thanks in advance.

    P.S. Please don't ask for DDL and sample data as I've...

    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

    March 12, 2014 at 6:30 pm

    #1696599

  • RE: Problems with User Defined Function running sql server script

    I can give you the script to create a "boolean" data type. However, it might not be the expected definition and you must ask for it with the person that...

    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

    March 12, 2014 at 6:17 pm

    #1696597

  • RE: Problems with User Defined Function running sql server script

    You seem to have a problem with a user defined datatype (dbo.boolean). You need to create it before running the script or you need to change the script to use...

    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

    March 12, 2014 at 5:54 pm

    #1696589

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (3/12/2014)

    I have a database. It doesn't work. Please advise.

    Thanks in advance.

    P.S. Please don't ask for DDL and sample data as I've already said that...

    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

    March 12, 2014 at 4:18 pm

    #1696568

  • RE: need help on convert function dates

    A replace can work for you.

    SELECT REPLACE( CONVERT(VARCHAR(24),@deadline, 100), ' ', ' 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

    March 12, 2014 at 1:40 pm

    #1696541

  • RE: More than 1 alphanumeric chars in a string

    Sean Lange (3/12/2014)

    That is pretty slick Luis.

    Thanks Sean, it came after my third cup of coffee, I might need more now. 😀

    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

    March 12, 2014 at 12:43 pm

    #1696524

  • RE: More than 1 alphanumeric chars in a string

    I might be trying to kill a fly with a cannon but this could be an option. It could be turned into an inLine Table-valued Function if needed to avoid...

    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

    March 12, 2014 at 12:37 pm

    #1696520

  • RE: A True SQL OS

    jownby (3/12/2014)

    DavidL (3/12/2014)

    It would be an interesting scenario, sort like paying a premium to M$ to NOT have windows installed:-P

    Is that like when Porsche wants to sell you...

    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

    March 12, 2014 at 9:37 am

    #1696460

Viewing 15 posts - 6,766 through 6,780 (of 8,731 total)