Forum Replies Created

Viewing 15 posts - 1,516 through 1,530 (of 8,731 total)

  • RE: Need Help Refuting a Statement about Normalization

    amy26 - Friday, March 3, 2017 7:34 AM

    This is all I put in my "draft" so far, trying to be generic yet...

    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 3, 2017 at 10:13 am

    #1931573

  • RE: CTE not working properly

    skb 44459 - Friday, March 3, 2017 9:43 AM

    Hierarchy is not getting build properly. 

    ;WITH myCTE2 ([MaterialRowID], [MaterialID], [ParentRowID] )

    AS
    (

    SELECT p1.[MaterialRowID], p1.[MaterialID],...

    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 3, 2017 at 10:03 am

    #1931570

  • RE: Are the posted questions getting worse?

    Neil Burton - Friday, March 3, 2017 5:23 AM

    A mean little trick, that may not work Stateside, is to ask for 21...

    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 3, 2017 at 9:30 am

    #1931557

  • RE: Drop Database bug?

    AzureFan - Thursday, March 2, 2017 10:55 AM

    Has anyone seen this?  Is it a know bug or intended behavior?

    In a 2016 Developer...

    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 2, 2017 at 11:21 am

    #1931290

  • RE: Are the posted questions getting worse?

    Sean Lange - Thursday, March 2, 2017 10:46 AM

    Brandie Tarvin - Thursday, March 2, 2017 9:51 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

    March 2, 2017 at 11:15 am

    #1931284

  • RE: Are the posted questions getting worse?

    Brandie Tarvin - Thursday, March 2, 2017 9:51 AM

    ZZartin - Thursday, March 2, 2017 9:41 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

    March 2, 2017 at 10:09 am

    #1931255

  • RE: Number of integers where digits are not repeating.

    ben.brugman - Thursday, March 2, 2017 9:04 AM

    Thanks for the quick replies.

    But there is no limitation for the length.

    So:
    3 is correct and...

    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 2, 2017 at 9:16 am

    #1931237

  • RE: Number of integers where digits are not repeating.

    Just another option.

    WITH
    E(n) AS(
      SELECT n FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))E(n)
    ),
    E2(n) AS(
      SELECT a.n FROM E a, E b
    ),
    E4(n) AS(
     ...

    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 2, 2017 at 8:33 am

    #1931210

  • RE: Are the posted questions getting worse?

    Sean Lange - Thursday, March 2, 2017 8:05 AM

    Jeff Moden - Thursday, March 2, 2017 7:47 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

    March 2, 2017 at 8:20 am

    #1931199

  • RE: Please explain difference between these terms

    This link might be helpful to understand more about permissions in SQL Server.
    Server Roles and Database Roles are not exchangeable. They manage different permissions and should...

    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 2, 2017 at 8:07 am

    #1931195

  • RE: Finding Triggers

    The only problem is if you have triggers that affect multiple types. Here's an example for a trigger that would be count 3 times.

    CREATE TABLE TriggerTest(

    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 2, 2017 at 6:41 am

    #1931156

  • RE: get date / only sql

    Out of curiosity. Is this a homework question?
    I remember seeing something really similar months ago.

    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 1, 2017 at 9:40 am

    #1931015

  • RE: SQL loop never stops even if I define loop number

    Here's how to do it without loops. Comment and uncomment as needed.
    I didn't know what to do with the update or it was actually needed.

    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 1, 2017 at 9:31 am

    #1931012

  • RE: Function works when passing in parameters, does not work with CROSS APPLY

    ChrisM@Work - Wednesday, March 1, 2017 7:48 AM

    Luis, how are you getting your code to format nicely? Until a couple of days...

    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 1, 2017 at 8:12 am

    #1930975

  • RE: Function works when passing in parameters, does not work with CROSS APPLY

    kyagi.jo - Wednesday, March 1, 2017 7:23 AM

    I think that's how tally tables work though? I haven't been able to track any...

    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 1, 2017 at 7:36 am

    #1930964

Viewing 15 posts - 1,516 through 1,530 (of 8,731 total)