Forum Replies Created

Viewing 15 posts - 1,636 through 1,650 (of 8,731 total)

  • RE: right aligning

    djj - Monday, January 23, 2017 5:35 AM

    Manie Verster - Sunday, January 22, 2017 11:24 PM

    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

    January 23, 2017 at 6:34 am

    #1924385

  • RE: TSQL - Aggregate Bitwise

    I got this working with the Quirky update. To learn more about how to make this work read the following article: http://www.sqlservercentral.com/articles/T-SQL/68467/
    Be sure to understand how it works before...

    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

    January 20, 2017 at 2:10 pm

    #1924153

  • RE: Find First, Middle and Last Name of the Second Consumer

    Maybe something like this:

    SELECT LEFT( SecondName, CHARINDEX( ' ', SecondName) - 1) AS FirstName,
       SUBSTRING( SecondName, CHARINDEX( ' ', SecondName) + 1, 800) AS MiddleName,

    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

    January 20, 2017 at 1:47 pm

    #1924150

  • RE: merging multiple Exists

    sql_2005_fan - Friday, January 20, 2017 9:50 AM

    Hi I have the following query  with multiple exists run against the same table.

    Can 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

    January 20, 2017 at 11:40 am

    #1924124

  • RE: Are the posted questions getting worse?

    Chris Harshman - Friday, January 20, 2017 11:14 AM

    jasona.work - Friday, January 20, 2017 10:11 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

    January 20, 2017 at 11:37 am

    #1924122

  • RE: Are the posted questions getting worse?

    Ed Wagner - Friday, January 20, 2017 5:45 AM

    Koen Verbeeck - Friday, January 20, 2017 2:02 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

    January 20, 2017 at 6:21 am

    #1923991

  • RE: FAQ: Using the new forum Software (Jan 2017)

    xsevensinzx - Friday, January 13, 2017 10:59 PM

    All I want to know is how in the world did Jeff get his gif...

    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

    January 19, 2017 at 1:13 pm

    #1923849

  • RE: While invoking the command to import the master..sp_help_revlogin output to the server erroring out

    SQL-DBA-01 - Thursday, January 19, 2017 11:34 AM

    Hello

    I executed the below command to extract the login to a .sql file.
    sqlcmd -E...

    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

    January 19, 2017 at 11:49 am

    #1923811

  • RE: Find 'MAX' of an bit type - Further adventures in report writing

    Stueyd - Thursday, January 19, 2017 9:33 AM

    I hate the person who 'designed' a database I've inherited..... 🙂

    I'm producing a server...

    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

    January 19, 2017 at 9:52 am

    #1923770

  • RE: Today's Random Word!

    Revenant - Wednesday, January 18, 2017 9:12 AM

    djj - Wednesday, January 18, 2017 9:02 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

    January 18, 2017 at 1:12 pm

    #1923538

  • RE: Question about CASE WHEN on a column

    SvetNas - Wednesday, January 18, 2017 11:15 AM

    Zososql - Wednesday, January 18, 2017 10:50 AM

    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

    January 18, 2017 at 11:23 am

    #1923504

  • RE: Error converting varchar to date

    You're assigning string values to dates. You need to define the variables to assign values and then use the variables to send their values as parameters to the procedure.

    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

    January 18, 2017 at 8:23 am

    #1923444

  • RE: Wildcard Searches

    knotmyline - Tuesday, January 17, 2017 11:18 PM

    I'm using SSMS 2014 and get a slightly different execution plan than you. I copied...

    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

    January 18, 2017 at 7:46 am

    #1923430

  • RE: Help converting a CURSOR in a function to FOR XML PATH

    I could post an untested solution, but why give you the fish when I can share a fishing course with you. Take a look at this article:

    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

    January 17, 2017 at 12:23 pm

    #1923255

  • RE: Are the posted questions getting worse?

    Grant Fritchey - Monday, January 16, 2017 8:04 AM

    Steve Jones - SSC Editor - Monday, January 16, 2017...

    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

    January 17, 2017 at 7:07 am

    #1923161

Viewing 15 posts - 1,636 through 1,650 (of 8,731 total)