Forum Replies Created

Viewing 15 posts - 271 through 285 (of 2,452 total)

  • RE: t-sql 2012 rank or priortize values in one column

    wendy elizabeth - Monday, February 20, 2017 9:21 PM

    How about if the data is sorted by service type in descending order? This...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Find Matching People in table based on similar values

    seems similar to this  https://www.sqlservercentral.com/Forums/1859349/Linking-rows-based-on-matching-fields

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Active threads ....could be better

    Steve Jones - SSC Editor - Sunday, February 19, 2017 8:46 AM

    the load/reload more has to do with the processing of the page....

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: t-sql 2012 rank or priortize values in one column

    maybe  ??

    CREATE TABLE #Enroll(
     personID  INT
    ,serviceType VARCHAR(1) NOT NULL
    ,startDate DATE NOT NULL
    ,EndDate  DATE ...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Is that database is used by users or no?

    some ideas discussed here https://www.mssqltips.com/sqlservertip/3171/identify-sql-server-databases-that-are-no-longer-in-use/

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Newbie Help - SQL Query

    dump 10119 - Sunday, February 5, 2017 1:40 AM

    Can somebody point me in the right direction please ?

    suggest you read the following...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Should we keep Comic Sans in the formatting options?

    Eric M Russell - Thursday, January 12, 2017 11:55 AM

    Dave Convery - Thursday, January 12, 2017 4:07 AM

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: SSC Forum Updates

    where do I now find "My Posts" ??  personally I used to use this a lot to quickly get to some threads that I had replied in.....am sure it must...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: SSC Forum Updates

    robert.chipperfield - Thursday, January 12, 2017 7:40 AM

    J Livingston SQL - Thursday, January 12, 2017 7:38 AM

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: SSC Forum Updates

    J Livingston SQL - Thursday, January 12, 2017 7:28 AM

    J Livingston SQL - Thursday, January 12, 2017 7:27 AM

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: SSC Forum Updates

    J Livingston SQL - Thursday, January 12, 2017 7:28 AM

    J Livingston SQL - Thursday, January 12, 2017 7:27 AM

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: SSC Forum Updates

    J Livingston SQL - Thursday, January 12, 2017 7:27 AM

    my time zone is set to GMT (Western Europe) in the Forums Control Panel...however...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: SSC Forum Updates

    my time zone is set to GMT (Western Europe) in the Forums Control Panel...however all the times showing on posts are 7 hours behind....??

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: How to modify query to only use base tables

    allenjoey24 (12/18/2016)


    I think that might be what it meant. So is it asking me to modify my queries so that instead of referencing a column on a table like Table.Column...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: How to modify query to only use base tables

    what text book are you reading...?

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

Viewing 15 posts - 271 through 285 (of 2,452 total)