Forum Replies Created

Viewing 15 posts - 4,936 through 4,950 (of 15,381 total)

  • RE: Moving Queries for access to SQL

    rf44 (5/9/2014)

    Sean Lange (5/9/2014)

    Makes me very happy that I don't use Access for anything at all...and haven't in a LONG time. Even when I did a few things with Access...

    May 9, 2014 at 1:00 pm

    #1712314

  • RE: Computed Column Equal to Letter

    ScottPletcher (5/9/2014)

    Sean Lange (5/9/2014)

    scotsditch (5/8/2014)

    I'm trying to do something so simple, it's driving me nuts. Especially since I remember doing it before.

    I want to create a computed Column in...

    May 9, 2014 at 12:52 pm

    #1712308

  • RE: Insert information based on a range

    cdl_9009 (5/9/2014)

    I am trying to go line by line to see what is going on. Like what is the WITH statement doing? I believe that is part of...

    May 9, 2014 at 12:36 pm

    #1712302

  • RE: Syntax Error with Trigger

    jdbrown239 (5/9/2014)

    Hi

    I have a syntax error I can't figure out. It's probably simple but I don't see it. Any suggestions?

    CREATE TRIGGER Trigger_20321 ON FACT_CUST_GRP_ICM_MO

    AFTER...

    May 9, 2014 at 12:23 pm

    #1712296

  • RE: Version Breakdown

    JKSQL (5/9/2014)

    I gotta stop using loops! I know the tally works better. Thanks for the reminder. Worked great.

    If possible why not break this into separate columns? Saves...

    May 9, 2014 at 12:15 pm

    #1712293

  • RE: Moving Queries for access to SQL

    rf44 (5/9/2014)

    Sean Lange (5/9/2014)

    The idea is to stop using queries entirely in Access. If all the data lives in sql server there is no point in using Access for anything...

    May 9, 2014 at 12:04 pm

    #1712290

  • RE: Insert information based on a range

    cdl_9009 (5/9/2014)

    Thank you. I will have to research this so I understand what this does. Then I might come up with more intelligent questions.

    I can try to explain portions...

    May 9, 2014 at 10:30 am

    #1712269

  • RE: Moving Queries for access to SQL

    jdasilva (5/9/2014)

    Sean,

    I did look at this:

    Yes make the variable portions of your queries parameters.

    create procedure MyProcToGetSomeData

    (

    @LocID int

    ) as

    select YourColumns

    from YourTable

    where Location = @LocID

    but again, this is new...

    May 9, 2014 at 10:29 am

    #1712268

  • RE: Split column rows

    giszzmo (5/9/2014)

    Current Column

    Big

    Big

    Big

    Small

    Small

    Big

    Small

    Small

    Big

    Big

    Small

    Big

    Small

    I would like to have:

    Column 1

    Big

    Big

    Big

    Big

    Big

    Big

    Big

    Column 2

    Small

    Small

    Small

    Small

    Small

    Small

    That doesn't exactly provide much detail. It certainly doesn't give anybody enough...

    May 9, 2014 at 9:59 am

    #1712254

  • RE: Moving Queries for access to SQL

    jdasilva (5/9/2014)

    SQL is delicious (5/9/2014)

    Sean Lange (5/9/2014)

    jdasilva (5/9/2014)

    J Livingston SQL (5/9/2014)

    is/can your form be based on a single table/sql query?

    Yes, and it currently is, but that query refines data based...

    May 9, 2014 at 9:56 am

    #1712252

  • RE: Table scan paranoia

    sqldriver (5/9/2014)

    Sean Lange (5/9/2014)

    sqldriver (5/9/2014)

    I have a stored procedure hitting a 761969 row table and doing several table scans on it. It is indexed, as I'll show below. I can't...

    May 9, 2014 at 9:38 am

    #1712243

  • RE: Table scan paranoia

    sqldriver (5/9/2014)

    I have a stored procedure hitting a 761969 row table and doing several table scans on it. It is indexed, as I'll show below. I can't get an actual...

    May 9, 2014 at 9:24 am

    #1712233

  • RE: Insert information based on a range

    cdl_9009 (5/9/2014)

    I am trying to insert a bunch of data based on a ranger.

    Someone passes me starting range = OD1-2000, ending range = OD1-2050.

    So I am trying to figure out...

    May 9, 2014 at 9:14 am

    #1712228

  • RE: Could this be done using PIVOT ?

    Budd (5/9/2014)

    Simply looking for alternatives and better performance.

    I have gotten myself into a bad habit of only using UNION to avoid duplicates and had quickly brushed that thought away. ...

    May 9, 2014 at 9:01 am

    #1712220

  • RE: Computed Column Equal to Letter

    It still begs the question "Why?????".

    BWAHAA!!!! Was that pun intended??? 😀

    May 9, 2014 at 8:34 am

    #1712207

Viewing 15 posts - 4,936 through 4,950 (of 15,381 total)