Forum Replies Created

Viewing 15 posts - 226 through 240 (of 8,731 total)

  • RE: Convert string nvarchar(6) with format MMM-YY to date

    CGZ - Thursday, February 7, 2019 8:51 PM

    Hello everyone!
    The answers were really helpful, thank you! but i am facing a problem 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

    February 8, 2019 at 7:59 am

    #2021502

  • RE: The Funny Stored Procedure Name

    Toreador - Friday, February 8, 2019 1:52 AM

    Guessed right but for the wrong reason.
    Must admit, I don't quite see the point 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

    February 8, 2019 at 7:52 am

    #2021501

  • RE: dynamic sql query

    I don't see any need on doing a dynamic pivot in here. Your balanceflowtype column has limited values available, so it would be simpler to just code them. The pivot...

    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 8, 2019 at 7:42 am

    #2021499

  • RE: How to unpivot columns dynamically using SQL server 2014

    vikasjagadale8 - Thursday, February 7, 2019 2:43 PM

    Thanks a lot, it worked. But I am new to SQL. Can you please...

    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 7, 2019 at 2:53 pm

    #2021446

  • RE: How to unpivot columns dynamically using SQL server 2014

    This is a way of doing it. It would be great if you could avoid this problem and get the unpivoted data to begin with, but that's something that might...

    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 7, 2019 at 10:19 am

    #2021424

  • RE: How to compare SQL databases ?

    stevenmillward - Thursday, February 7, 2019 8:06 AM

    Hi
    Got an issue with a client where an import works for us using our DB...

    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 7, 2019 at 8:32 am

    #2021401

  • RE: Which years are similar.

    Here's a code that will list 200 years starting on 1900 and group them by calendar variation. You can have 14 possible calendars, 2 for each day of the week...

    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 6, 2019 at 8:16 am

    #2021273

  • RE: Query to search salaries using IN Clause

    p.hernandez75 - Monday, February 4, 2019 1:50 PM

    Greetings,
    I am new to SQL and not familiar with the EXISTS Clause. I will research...

    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 5, 2019 at 9:15 am

    #2021178

  • RE: Query to search salaries using IN Clause

    p.hernandez75 - Monday, February 4, 2019 12:55 PM

    Greetings,
    I am currently aiming to create a query for educational purposes in SQL 2017 Express...

    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 4, 2019 at 1:08 pm

    #2021083

  • RE: Case When Between issue

    jcobb 20350 - Monday, February 4, 2019 11:01 AM

    I have a list of suppliers and their next review date. The date is...

    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 4, 2019 at 11:19 am

    #2021065

  • RE: Creating Your First Stored Procedure

    Jeff Moden - Monday, February 4, 2019 6:00 AM

    Great article, Steve.

    My only quandary is where does the idea of it being preferable...

    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 4, 2019 at 7:44 am

    #2021031

  • RE: How to find the blocker?

    Sue_H - Friday, February 1, 2019 2:01 PM

    SQL Guy 1 - Friday, February 1, 2019 1:35...

    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 2:36 pm

    #2020909

  • RE: Question

    I would seriously question the need for this user to update data directly in production. If this user already caused an issue by deleting, I would expect the same thing...

    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 10:07 am

    #2020882

  • RE: How to find the blocker?

    I used to have Erland Sommarskog's beta_lockinfo utility. You could give it a try.
    http://www.sommarskog.se/sqlutil/beta_lockinfo.html

    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 8:48 am

    #2020863

  • RE: Date filter WHERE clause

    This is another way of doing it.

    WHERE [YourDateField] >= DATEADD( YY, DATEDIFF( YY, 0, DATEADD( mm, -1, GETDATE())), 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:39 am

    #2020848

Viewing 15 posts - 226 through 240 (of 8,731 total)