Forum Replies Created

Viewing 15 posts - 1,606 through 1,620 (of 4,086 total)

  • RE: Forum Etiquette: How to post data/code on a forum to get the best help

    stanteitelbaum - Thursday, September 14, 2017 6:05 AM

    Hi, I think now and then I'm guilty of these things.  What does "bump a...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 14, 2017 at 7:44 am

    #1959426

  • RE: deleting duplicate rows based on a condition

    Avi1 - Wednesday, September 13, 2017 4:15 PM

    Try this query, this should work. You can use select clause to check the data...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 14, 2017 at 7:30 am

    #1959421

  • RE: Conditional Search

    Phil Parkin - Wednesday, September 13, 2017 12:58 PM

    Try running this and see what you think. I'm not surprised that you had...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 13, 2017 at 1:10 pm

    #1959320

  • RE: remove spaces in strings

    anand08sharma - Wednesday, September 13, 2017 11:07 AM

    komal145 - Tuesday, September 5, 2017 12:29 PM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 13, 2017 at 11:29 am

    #1959301

  • RE: Datetime manipulation

    This also works.
    SELECT DATEADD(DAY, DATEDIFF(DAY, @datetime2, @datetime1), @datetime2)

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 13, 2017 at 11:17 am

    #1959298

  • RE: How to encrypt Credit Card numbers?

    My suggestion is that you start with Google.  Google is great for the basics, forums like this are great for the nitty-gritty details.  You're looking for basics, so use the...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 8, 2017 at 12:28 pm

    #1958780

  • RE: Determine Monday of next month and Monday of next week

    jcelko212 32090 - Thursday, September 7, 2017 2:11 PM

    I like the MySQL zero convention strings "yyyy-mm-00" for a month, and "yyyy-00-00"...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 8, 2017 at 9:12 am

    #1958743

  • RE: Update data with same values

    David Burrows - Wednesday, September 6, 2017 1:59 AM

    TheSQLGuru - Tuesday, September 5, 2017 11:21 AM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 6, 2017 at 8:24 am

    #1958372

  • RE: Appreciating New Perspectives

    DavidL - Friday, September 1, 2017 11:21 AM

    On this topic, I've been reading a book about a westerner who ends up spending...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 5, 2017 at 1:22 pm

    #1958172

  • RE: remove spaces in strings

    komal145 - Tuesday, September 5, 2017 12:59 PM

    "WebCrawler.Crawlable.EURRUSSIA.C_Darty "
    "WebCrawler.Crawlable.EURRUSSIA.C_Darty"

    This is how it shows in  the  table and length differes as 32 and...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 5, 2017 at 1:16 pm

    #1958171

  • RE: Determine Monday of next month and Monday of next week

    Jeff Moden - Monday, September 4, 2017 11:41 AM

    drew.allen - Wednesday, August 30, 2017 2:53 PM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 5, 2017 at 12:14 pm

    #1958162

  • RE: Update data with same values

    Chuck S - Tuesday, September 5, 2017 11:56 AM

    TheSQLGuru - Tuesday, September 5, 2017 11:50 AM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 5, 2017 at 12:02 pm

    #1958159

  • RE: Update data with same values

    TheSQLGuru - Tuesday, September 5, 2017 11:21 AM

    Depending on how much data you have this shouldn't be too bad, although as others...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 5, 2017 at 11:59 am

    #1958157

  • RE: Removing records from SELECT

    pietlinden - Tuesday, September 5, 2017 10:00 AM

    Looks like this works...
    You may want to include other rows from both tables, but this...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 5, 2017 at 11:25 am

    #1958150

  • RE: Database trigger to send email after column in table is updated.

    mattdarvellwow - Tuesday, September 5, 2017 9:29 AM

    Hello all,

    Thank you for any help given in advance, it is much appreciated.

    Scenario - What I...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 5, 2017 at 11:17 am

    #1958147

Viewing 15 posts - 1,606 through 1,620 (of 4,086 total)