Forum Replies Created

Viewing 15 posts - 601 through 615 (of 8,731 total)

  • RE: Cursor Set Condition Variable

    What this code is trying to attempt could be easily rewritten by something like this:

    WITH cteCustomer AS(
      SELECT CustomerNumber
       , Group
       ...

    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

    April 13, 2018 at 11:30 am

    #1986799

  • RE: Are the posted questions getting worse?

    jasona.work - Friday, April 13, 2018 8:59 AM

    And it might be time to lock down a topic...
    https://www.sqlservercentral.com/Forums/1930195/Removing-stored-procedures-to-move-to-cloud
    It was going so well,...

    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

    April 13, 2018 at 9:14 am

    #1986766

  • RE: datetime conversion oddity

    I would seriously recommend that you always use ISO formats when handling dates. That means YYYYMMDD or YYYY-MM-DDThh:mi:ss.msss

    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

    April 13, 2018 at 8:56 am

    #1986761

  • RE: Learning about clustered index

    Phil Parkin - Thursday, April 12, 2018 12:04 PM

    NewBornDBA2017 - Thursday, April 12, 2018 11: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

    April 12, 2018 at 12:21 pm

    #1986656

  • RE: Are the posted questions getting worse?

    jonathan.crawford - Thursday, April 12, 2018 10:13 AM

    Grant Fritchey - Thursday, April 12, 2018 6:46 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

    April 12, 2018 at 10:15 am

    #1986629

  • RE: Help: SQL one row to many rows

    aobf - Thursday, April 12, 2018 9:58 AM

    Folks,
    I could use some help,  I have a script that returns x number 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

    April 12, 2018 at 10:05 am

    #1986622

  • RE: Using CASE in Where Condition

    luissantos - Thursday, April 12, 2018 9:05 AM

    Hello,
    Many thanks  for all your replies.
    Luis Cazares i read your example that is in fact...

    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

    April 12, 2018 at 9:13 am

    #1986607

  • RE: Removing stored procedures to move to cloud

    sgmunson - Thursday, April 12, 2018 8:26 AM

    xsevensinzx - Thursday, April 12, 2018 6:57 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

    April 12, 2018 at 8:46 am

    #1986602

  • RE: Using CASE in Where Condition

    Why are we making it so complex?

    Select name, married
    from mytable A
    where A.married = 1 OR @YesNo = 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

    April 12, 2018 at 8:33 am

    #1986598

  • RE: Detaching CDC

    roger.plowman - Thursday, April 12, 2018 6:50 AM

    So, by the question's own wording, the "correct" answer is actually wrong. The question says...

    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

    April 12, 2018 at 6:58 am

    #1986575

  • RE: Complex Windowed Sum

    It's fairly simple.
    To get just a Customer's data, you can use a CASE statement.
    To get the fiscal year ending on April 30th, you just substract 4 months.

    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

    April 11, 2018 at 2:19 pm

    #1986481

  • RE: Sql Server Development

    Ronnie65 - Wednesday, April 11, 2018 12:22 PM

    Hi, I was wondering are there any free pdf Books that cover SQL Transact. Thank...

    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

    April 11, 2018 at 1:02 pm

    #1986453

  • RE: Are the posted questions getting worse?

    Grant Fritchey - Wednesday, April 11, 2018 12:40 PM

    Luis Cazares - Wednesday, April 11, 2018 10:36 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

    April 11, 2018 at 1:00 pm

    #1986452

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor - Wednesday, April 11, 2018 10:36 AM

    Toyota has a new small SUV. My wife was considering it,...

    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

    April 11, 2018 at 10:46 am

    #1986410

  • RE: Are the posted questions getting worse?

    jasona.work - Wednesday, April 11, 2018 10:22 AM

    Luis Cazares - Wednesday, April 11, 2018 6:52 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

    April 11, 2018 at 10:36 am

    #1986409

Viewing 15 posts - 601 through 615 (of 8,731 total)