Forum Replies Created

Viewing 15 posts - 1,201 through 1,215 (of 8,731 total)

  • RE: date format needed: 06/15/2017 12:00:00 AM

    polkadot - Thursday, June 15, 2017 1:25 PM

    how to get it more directly than this?
    SELECT CONVERT(VARCHAR(25), getdate(), 101) + ' 12:00:00 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

    June 15, 2017 at 1:42 pm

    #1947019

  • RE: Help with query

    Here are a couple of options that are equivalent to each other, but different to the previous posted option.
    They read the table twice, but might be able to take...

    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

    June 15, 2017 at 9:29 am

    #1946968

  • RE: need counts of unique patients

    syam.tunuguntla - Thursday, June 15, 2017 9:02 AM

    Friends,
    i am counting unique patients that were referred by a doctor.i simply used distinct count...

    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

    June 15, 2017 at 9:13 am

    #1946962

  • RE: date match + / - day

    joanna.seldon - Thursday, June 15, 2017 8:01 AM

    Hi
    I have a project table that has a column called  TargetDate. This is 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

    June 15, 2017 at 8:15 am

    #1946941

  • RE: trying to convert date to format of MM/DD/YY

    rmcguire 28206 - Tuesday, June 13, 2017 2:14 PM

    so for.....

    drs.void_date >= DATEADD(day, DATEDIFF(day, 0, CURRENT_TIMESTAMP), -3)
        AND drs.void_date < DATEADD(day, DATEDIFF(day,...

    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

    June 13, 2017 at 7:41 pm

    #1946673

  • RE: Question regarding date logic

    Can you post dates that would actually work?
    Also, can you post the expected results based on the new sample data?

    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

    June 13, 2017 at 1:29 pm

    #1946644

  • RE: trying to convert date to format of MM/DD/YY

    rmcguire 28206 - Tuesday, June 13, 2017 11:55 AM

    can I have someone explain how on my original script this:

    WHEN CAST(drs.void_date...

    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

    June 13, 2017 at 12:10 pm

    #1946624

  • RE: trying to convert date to format of MM/DD/YY

    rmcguire 28206 - Tuesday, June 13, 2017 10:00 AM

    so I think its just the two parts which end AS real_date, so from...

    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

    June 13, 2017 at 10:41 am

    #1946607

  • RE: CASE statement in WHERE clause

    Are you comparing to one column or multiple columns? You use Table1.Fruit and Table2.Food even when those appear to represent the same attribute. Please post a most detailed example using...

    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

    June 13, 2017 at 10:03 am

    #1946598

  • RE: Query Performance

    krishna83 - Tuesday, June 13, 2017 4:45 AM

    How to improve performance of a query.

    Please find attached actual and estimated execution plans of...

    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

    June 13, 2017 at 7:16 am

    #1946542

  • RE: Pivot Query Help

    inayatkhan - Monday, June 12, 2017 7:48 AM

    I have data in this format and i need to pivot it. 


    create table...

    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

    June 12, 2017 at 7:58 am

    #1946397

  • RE: Bulk generation of statements

    Instead of making sub-reports, you could use groups and page breaks to separate each "statement". But I'm not sure if you'll get the expected output from it.

    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

    June 12, 2017 at 7:29 am

    #1946391

  • RE: Are the posted questions getting worse?

    Hugo Kornelis - Wednesday, June 7, 2017 1:17 PM

    Lynn Pettis - Wednesday, June 7, 2017 12:32 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

    June 7, 2017 at 1:45 pm

    #1945891

  • RE: Are the posted questions getting worse?

    Brandie Tarvin - Wednesday, June 7, 2017 12:05 PM

    You know what I just realized I want on this forum?

    A way to tag...

    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

    June 7, 2017 at 12:30 pm

    #1945877

  • RE: convert excel formula to sql - HELP needed

    Hi and welcome to the forums!
    Unfortunately, you didn't post enough information for us to help you. Please read the articles linked in my signature to learn how to post...

    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

    June 7, 2017 at 7:08 am

    #1945801

Viewing 15 posts - 1,201 through 1,215 (of 8,731 total)