Forum Replies Created

Viewing 15 posts - 391 through 405 (of 2,452 total)

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson

    -------------------------------------------------------------------------------

    -- FIRST READ

    -------------------------------------------------------------------------------

    Table 'TBL_NUMBERS'. Scan count 1, logical reads 123814, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

    ...

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

    September 10, 2016 at 1:51 am

    #1900205

  • RE: Are the posted questions getting worse?

    WayneS (9/9/2016)

    J Livingston SQL (9/9/2016)

    feeling pleased (for the minute!)

    off the shelf tower.....

    6th Generation Intel(R) Core(TM) i7-6700 Processor (8M Cache, up to 4.0 GHz)

    16GB (2x8GB) 2133MHz DDR4 Non-ECC 1 SR

    2TB...

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

    September 10, 2016 at 1:34 am

    #1900204

  • RE: Need Beta Testers for New Database Monitoring Platform

    Phil Parkin (9/9/2016)

    J Livingston SQL (9/9/2016)

    please dont cross post on multiple forums...highly unlikely to gain you any more respondents.

    Quite the opposite.

    hehe...you are probably right Phil 😀

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

    September 9, 2016 at 2:42 pm

    #1900169

  • RE: Need Beta Testers for New Database Monitoring Platform

    please dont cross post on multiple forums...highly unlikely to gain you any more respondents.

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

    September 9, 2016 at 12:52 pm

    #1900144

  • RE: "Cannot Delete from Specified Table" error - help please

    maybe this post will help....seem to remember similar problems, but cant remember the solutions!

    https://social.msdn.microsoft.com/Forums/office/en-US/9540ba5f-bccc-446a-9179-5bb50e191bac/cant-delete-record-from-sql-server-table-from-within-ms-access?forum=accessdev

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

    September 9, 2016 at 12:48 pm

    #1900143

  • RE: Are the posted questions getting worse?

    Gazareth (9/9/2016)

    drew.allen (9/9/2016)

    Jacob Wilkins (9/9/2016)

    The Dixie Flatline (9/9/2016)

    Okay.... although I'm not going back into the divide by zero thread.

    Both SET ANSI_WARNINGS OFF and SET ARITHABORT OFF...

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

    September 9, 2016 at 11:40 am

    #1900123

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (9/9/2016)

    I'm not listening anymore.... lalalalalalaaaaaaaaaaaa

    ....and he isnt going to listen to anyone either

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

    September 9, 2016 at 8:22 am

    #1900057

  • RE: Are the posted questions getting worse?

    Lynn Pettis (9/9/2016)

    ThomasRushton (9/9/2016)

    Grant Fritchey (9/9/2016)

    GilaMonster (9/9/2016)

    Grant Fritchey (9/9/2016)

    BrainDonor (9/9/2016)

    I've been following that thread since it started - fascinating. I'll give him full marks for determination ("Tis but a scratch"...

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

    September 9, 2016 at 8:15 am

    #1900053

  • RE: SQL query permutations using 3 tables without repetition

    itortu (9/7/2016)

    Hello, I think you are correct. I just do not know how to include all the tables and data involved in the creation of these "smaller" sets and ask...

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

    September 7, 2016 at 10:49 am

    #1899629

  • RE: Convert int date(YYMMDD) to datetime

    rerlston (9/7/2016)

    moymike (2/4/2016)

    I'm assuming a better option has come available since this was posted, but here is another.

    The pivot year is 1950 though, which would be a problem...

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

    September 7, 2016 at 10:36 am

    #1899621

  • RE: Fuzzy Matching

    Jason A. Long (9/6/2016)

    Eric M Russell (9/6/2016)

    J Livingston SQL (9/6/2016)

    -- just for fun

    SELECT[dbo].[DoubleMetaPhone]('Pheasant');

    SELECT[dbo].[DoubleMetaPhone]('Phesant');

    SELECT[dbo].[DoubleMetaPhone]('Fessant');

    SELECT[dbo].[DoubleMetaPhone]('Fezant');

    SELECT[dbo].[DoubleMetaPhone]('Phes ant');

    SELECT[dbo].[DoubleMetaPhone]('Fez aunt');

    quite impressive

    Still there is the issue that two words sounding alike are completely different.

    SELECT[dbo].[DoubleMetaPhone]('Pheasant');

    FSNT FSNT

    SELECT[dbo].[DoubleMetaPhone]('Fussy Aunt');

    FSNT...

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

    September 6, 2016 at 2:46 pm

    #1899468

  • RE: TRY_CAST AND TRY_CONVERT not recognized

    should work in 2012 and above....care to share a simple version of your code that throws the error...

    EDIT sorry spelling is hopeless this evening

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

    September 6, 2016 at 1:18 pm

    #1899453

  • RE: Fuzzy Matching

    -- just for fun

    SELECT[dbo].[DoubleMetaPhone]('Pheasant');

    SELECT[dbo].[DoubleMetaPhone]('Phesant');

    SELECT[dbo].[DoubleMetaPhone]('Fessant');

    SELECT[dbo].[DoubleMetaPhone]('Fezant');

    SELECT[dbo].[DoubleMetaPhone]('Phes ant');

    SELECT[dbo].[DoubleMetaPhone]('Fez aunt');

    quite impressive

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

    September 6, 2016 at 11:23 am

    #1899415

  • RE: Year to date with Year and Week

    spin (9/6/2016)

    i think so? 😐

    I really want to be able to pivot the data in excel so i can see ytd by

    week

    week - product

    week - customer

    week - customer -...

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

    September 6, 2016 at 9:56 am

    #1899383

  • RE: Unappreciative OP's maybe.....

    GilaMonster (9/6/2016)

    J Livingston SQL (9/3/2016)

    One word response "thanks" from the OP

    Wow, you got a 'thanks'. Impressive.

    I didnt make any response to the OP, but having read the responses and the...

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

    September 6, 2016 at 4:24 am

    #1899286

Viewing 15 posts - 391 through 405 (of 2,452 total)