Forum Replies Created

Viewing 15 posts - 1,036 through 1,050 (of 8,731 total)

  • RE: Can I make this query to perform better?

    I didn't check in detail, but something like this might improve the query.

    SELECT CASE
       WHEN STATE = 'W. Iowa'
        THEN 'Iowa'
       ...

    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

    August 10, 2017 at 11:40 am

    #1954856

  • RE: Are the posted questions getting worse?

    Can I stop changing my passwords every 90 days, please?
    http://gizmodo.com/the-guy-who-invented-those-annoying-password-rules-now-1797643987

    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

    August 10, 2017 at 11:05 am

    #1954848

  • RE: Are the posted questions getting worse?

    Brandie Tarvin - Wednesday, August 9, 2017 12:35 PM

    Thom A - Wednesday, August 9, 2017 8: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

    August 10, 2017 at 11:03 am

    #1954847

  • RE: Union is not working

    hayekmichel - Thursday, August 10, 2017 8:20 AM

    SELECT T.Template_Name,
     ISNULL( A.NumberOfAnswers, 0) AS NumberOfAnswers,
     ISNULL( Q.NumberOfQuestions, 0) AS NumberOfQuestions
    FROM APVS_Templates T
    LEFT...

    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

    August 10, 2017 at 8:23 am

    #1954819

  • RE: Union is not working

    Thom A - Thursday, August 10, 2017 7:15 AM

    UNION is working exactly as intended. UNION doesn't add columns to 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

    August 10, 2017 at 7:52 am

    #1954806

  • RE: Converting Hour and Minute to Decimal

    drew.allen - Wednesday, August 9, 2017 7:54 AM

    ravikaliappan - Wednesday, August 9, 2017 3: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

    August 9, 2017 at 8:04 am

    #1954629

  • RE: How to convert varbinary to date

    ravikaliappan - Wednesday, August 9, 2017 6:47 AM

    We get this from log. The date is 2017-08-09 16:19:53.830

    Considering this
    SELECT CONVERT(...

    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

    August 9, 2017 at 6:54 am

    #1954616

  • RE: How to convert varbinary to date

    ravikaliappan - Wednesday, August 9, 2017 5:31 AM

    How to convert varbinary to date with time?
    I tried like this
    SELECT CONVERT(datetime2, 0xB490E37742DFD408);

    It doesn’t...

    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

    August 9, 2017 at 6:42 am

    #1954606

  • RE: Require complex data format

    This is easy using cross tabs. Here's a snippet on how to do it, you'll need to complete it.

    SELECT LeadId,
      MAX(CASE WHEN PgNm = 'Start'...

    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

    August 9, 2017 at 6:22 am

    #1954599

  • RE: Are the posted questions getting worse?

    Tom_Hogan - Tuesday, August 8, 2017 1:42 PM

    I thought my dev and test instances on the same machine sharing 4 GB RAM...

    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

    August 8, 2017 at 2:13 pm

    #1954538

  • RE: INFORMATION_SCHEMA views

    Lynn Pettis - Tuesday, August 8, 2017 11:02 AM

    Just curious, how many of you use the INFORMATION_SCHEMA views?  Personally I prefer to...

    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

    August 8, 2017 at 11:18 am

    #1954507

  • RE: Union or CTE to turn cols into rows?

    rjjh78 - Tuesday, August 8, 2017 7:47 AM

    I am looking for the most efficient way to turn columns into rows where I...

    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

    August 8, 2017 at 8:39 am

    #1954479

  • RE: Bit vs. Int in return code

    You can return a bit value, but it will be implicitly converted into an int.
    If you capture the result value with a bit, you only have 3 available 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

    August 8, 2017 at 8:33 am

    #1954477

  • RE: Using PATINDEX To Determine If A String Is Alpha

    DesNorton - Friday, August 4, 2017 12:09 AM

    You can also make the function much more efficient and also enable it to go...

    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

    August 4, 2017 at 7:26 am

    #1954134

  • RE: Are the posted questions getting worse?

    Ed Wagner - Thursday, August 3, 2017 11:40 AM

    Phil Parkin - Thursday, August 3, 2017 9:34 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

    August 3, 2017 at 11:44 am

    #1954022

Viewing 15 posts - 1,036 through 1,050 (of 8,731 total)