Forum Replies Created

Viewing 15 posts - 661 through 675 (of 8,731 total)

  • RE: Query to increment an alpha character suffix

    lbrigham - Monday, February 26, 2018 1:30 PM

    Yeah, I think that's it. Well, using DENSE_RANK() to handle date ties along with CHAR()...

    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 26, 2018 at 2:11 pm

    #1981193

  • RE: Query to increment an alpha character suffix

    lbrigham - Monday, February 26, 2018 12:56 PM

    Need some help from the TSQL gurus. The situation is that given data in 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

    February 26, 2018 at 1:14 pm

    #1981182

  • RE: Possibly a dumb question about precedence in a where clause using 'OR'

    The reason is that you need a different approach. Each row is evaluated individually, so you need to assign something to identify them as the best option. Something like this:

    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 23, 2018 at 11:31 am

    #1980982

  • RE: Is there a row locking similar to Oracle's row locking in SQL SERVER 2016

    Chris Harshman - Friday, February 23, 2018 11:01 AM

    nickosl50 - Friday, February 23, 2018 10:30 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

    February 23, 2018 at 11:24 am

    #1980978

  • RE: Stripping out double quotes (") in bulk insert

    vadrasrinivas44 - Monday, February 19, 2018 12:30 AM

    HI Jonathan,

    Could you please tell me how did you import the same data to SQL...

    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 19, 2018 at 12:02 pm

    #1980316

  • RE: Are the posted questions getting worse?

    Thom A - Monday, February 19, 2018 7:08 AM

    Do you have a link to the source? I could really do 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 19, 2018 at 8:45 am

    #1980284

  • RE: Are the posted questions getting worse?

    jasona.work - Monday, February 19, 2018 6:16 AM

    Well, get ready for a bunch of new vulns in computers this year...
    Someone leaked a...

    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 19, 2018 at 8:44 am

    #1980283

  • RE: Are the posted questions getting worse?

    Phil Parkin - Friday, February 16, 2018 10:33 AM

    If anyone has completed their daily cryptic crossword, only to find themselves pining for...

    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 16, 2018 at 11:55 am

    #1980113

  • RE: running total max value by group

    Why is this different from your previous post?
    https://www.sqlservercentral.com/Forums/1922239/Increament-id-if-running-total-for-group-exceeds-value

    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 15, 2018 at 1:52 pm

    #1979998

  • RE: Decimal place in SQL

    IQ1 - Thursday, February 15, 2018 1:41 PM

    Hi there,
      This works perfectly except for cases where there are leading zeros as 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 15, 2018 at 1:47 pm

    #1979997

  • RE: How to distinct values and adding row numbers while keeping original order?

    I completely missed the part where you wanted to reassign row numbers.
    I'm glad you got it working.

    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 15, 2018 at 10:44 am

    #1979961

  • RE: Decimal place in SQL

    I hope you don't complicate everything like that. Also, be aware of integer division as you were a victim of it.

    select original_value,
      CONVERT(decimal(10,3),...

    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 15, 2018 at 10:43 am

    #1979960

  • RE: Creation of a temporal table

    Sean Lange - Thursday, February 15, 2018 9:43 AM

    Luis Cazares - Thursday, February 15, 2018 9:26 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

    February 15, 2018 at 10:37 am

    #1979958

  • RE: T-SQL for counting rows

    mike.kamish - Thursday, February 15, 2018 10:00 AM

    I have a data table "T" with data that looks like this:
    Class       ...

    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 15, 2018 at 10:15 am

    #1979953

  • RE: Decimal place in SQL

    faizsaadq - Thursday, February 15, 2018 10:00 AM

    I have a dumb question,
    I have values like 0054880, 0054885 0054890 and I need values...

    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 15, 2018 at 10:13 am

    #1979951

Viewing 15 posts - 661 through 675 (of 8,731 total)