Forum Replies Created

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

  • 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

  • RE: Update data with same values

    I would just tell the person who is delivering this data file that it's in an unacceptable format and have them fix it.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 5, 2017 at 11:11 am

    #1958145

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