Forum Replies Created

Viewing 15 posts - 91 through 105 (of 621 total)

  • RE: Using Access to put data into SQL Server

    Welsh Corgi (9/26/2012)

    You create an accde previously known as an mde to secure the Access Database so that no one can make changes.

    Then you create an other mdb for the...

    September 27, 2012 at 5:03 am

    #1542792

  • RE: NEED HELP IN PIVOT

    Swath, I don't have access to a server right now, but if you search for PIVOT there are countless examples here, and also on google.

    September 22, 2012 at 5:48 am

    #1541065

  • RE: T-SQL Help Needed

    Eugene Elutin (9/21/2012)

    BTW, COBOL is still in use across wide range of industries which offer sometimes very lucrative positions and contracts...

    Yes, the main application at my company is a series...

    September 21, 2012 at 6:23 am

    #1540631

  • RE: Using Access to put data into SQL Server

    aaron.reese (9/13/2012)

    yeah, don't use the wizards, learn to programme - it will be quicker in the long run and the next developer will thank you for it.

    ...and then you will...

    September 13, 2012 at 2:12 pm

    #1537471

  • RE: T-SQL Help Needed

    Well, I guess it's safe to say the OP is long gone. Given that he/she posted the problem twice, it must have been pressing. I wonder how it...

    September 13, 2012 at 2:04 pm

    #1537465

  • RE: Using Access to put data into SQL Server

    mrwillcostello (9/13/2012)

    I have put the project on hold for a bit. Need to work more with Access and understanding the form creation and how to create list boxes to select...

    September 13, 2012 at 2:00 pm

    #1537463

  • RE: Using Access to put data into SQL Server

    Welsh Corgi (9/13/2012)

    It has been a while since your last post.

    So how is your project going?

    It's probably overwhelming. I got introduced to SQL Server with an Access project a...

    September 13, 2012 at 11:32 am

    #1537366

  • RE: T-SQL Help Needed

    Jeff Moden (9/12/2012)

    Greg Snidow (9/11/2012)

    The 'id' column in every table was a bit annoying to work with.

    It's even more annoying when you need it and it's not there. 😉

    Don't overlook...

    September 12, 2012 at 9:28 am

    #1536782

  • RE: T-SQL Help Needed

    Ok, I had some free time so I messed with this some more. This one eliminates one of the joins to the pivot table to get the current status....

    September 11, 2012 at 3:21 pm

    #1536511

  • RE: T-SQL Help Needed

    Also...have...to...(fighting it)...agree...with...Celko. The 'id' column in every table was a bit annoying to work with. If you have any ability to provide some input with respect to...

    September 11, 2012 at 1:07 pm

    #1536442

  • RE: T-SQL Help Needed

    a4apple (9/11/2012)

    Hi, I need to get status names as columns and their respective dates as rows. I know its pivoting, but asking you guys for more insight.

    Thanks

    I think you need...

    September 11, 2012 at 1:02 pm

    #1536439

  • RE: Importing only rows with column data in specific columns.

    ScottPletcher (9/10/2012)

    So does one also need to run tests to prove that:

    SELECT a, b, c, d, e FROM dbo.table1

    is more efficient than:

    SELECT a, null, null, null, null FROM dbo.table1 UNION...

    September 10, 2012 at 8:21 pm

    #1535988

  • RE: T-SQL Help Needed

    Jeff Moden (9/10/2012)

    The test data setup you provided is great. Could you also describe what you want done with it? The result set doesn' give many hints as to...

    September 10, 2012 at 8:13 pm

    #1535986

  • RE: Importing only rows with column data in specific columns.

    ScottPletcher (9/10/2012)

    Greg Snidow (9/10/2012)

    ScottPletcher (9/10/2012)

    The UNPIVOT (one table scan) looks much better to me than fully scanning the table once for every grade column.

    Yep, as I said, I put that...

    September 10, 2012 at 4:50 pm

    #1535954

  • RE: Importing only rows with column data in specific columns.

    ScottPletcher (9/10/2012)

    The UNPIVOT (one table scan) looks much better to me than fully scanning the table once for every grade column.

    Yep, as I said, I put that out there for...

    September 10, 2012 at 4:14 pm

    #1535944

Viewing 15 posts - 91 through 105 (of 621 total)