Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bjb123

    Export SQL data to PDF

    Perhaps you could look at generating a new PDF out of reporting services rather than trying to update an existing one. Reporting services has PDF as one of the export formats. You just need to create the RDL whose output looks like the existing PDF then tie it to a query or stored proc with...
  2. bjb123

    TSQL Select Stmt

    ...ALL SELECT 'Db1','4/1/2009 00:00:00',3722 UNION ALL SELECT 'Db2','3/1/2009 00:00:00',1488 UNION ALL SELECT 'Db2','4/1/2009 00:00:00',1754 Select * FROM (SELECT DatabaseName, Date, QTY From #TEST) a PIVOT (Sum(Qty) For Date in ([03/01/2009], [04/01/2009])) b DatabaseName 03/01/2009...
  3. bjb123

    TSQL Select Stmt

    I do something like that for some management reports. We are on sql 2000, which doesn't have native pivot table capabilities like sql 2005, so I just select the data as is and put it in excel and then use Excel's Pivot Table function.
  4. bjb123

    Large Database Updates

    Batching it into chunks has some advantages. Less impact on temp DB, less rollback is something fails, and much less blocking. The last massive table update (hundreds of millions of rows on SQL Server 2000) we had to perform, our senior DBA wanted us to do it in batches of only 200 with a...
  5. bjb123

    64 bit version to host a .net application

    Thanks Denny. We've had the 64bit up and running in a test environment for a few weeks now and everything is working great.
  6. bjb123

    Exam difficulty: Your opinions

    70-431 ** After 2.5 months of studying 3 different reference manuals, doing sims, trancenders and CBTs I finally passed. I thought a couple of the sims were tough. But then I don't work on SQL server 2005 every day at my job. You guys/gals who work on it all the time probably had an easier...
  7. bjb123

    Help refining my TSQL

    specifically, i do not understand what the "X" does E2s code does an inner join with a derived table, the X is the alias for that derived table. Same with nice95gle code above, but he's using p.
  8. bjb123

    64 bit version to host a .net application

    We should be fine without SQL Mail, no legacy settings to worry about. Same with SSIS, at present. It is Standard Edition of SQL Server 2005. Here is a link to why I am under the impression that the Standard SQL Server 2005 would go to whatever the OS Maximum: sqlblogcast Microsoft...
  9. bjb123

    64 bit version to host a .net application

    I forgot to mention that the application is a windows forms .exe written in VB 2005 which will operate on the local workstations, not the server.
  10. bjb123

    64 bit version to host a .net application

    Yesterday I ordered a new Dell Power Edge 2900 that comes with a Standard Windows 2003 R2 64x OS and SQL 2005 64 bit. They shipped it today. The application provider is giving me a hard time because they don't list the 64 bit SQL Server as supported, they do list a 64 bit OS as OK...
  11. bjb123

    SQL 2005 authentication

    I don't think there is much of a downside but I think it's better practice to leave it in Windows mode and then switch it to mixed mode if the need ever arises. It's not a one of those decisions that you can't switch back and forth down the road.
  12. bjb123

    mistake on resume

    Thanks, some good advice in this thread. A quick update is that I sent an email explaining the phone number error along with a new copy of the resume a few weeks ago. Since then, I had a phone interview with 1 of the 4 places I sent a resume. The other 3 no longer have the job listed. I am...
  13. bjb123

    SQL 2005: Database recovery from suspect db

    Those words are painful to read even when it isn't my problem.
  14. bjb123

    Learning SQL

    Some fantastic reference material in this thread. I really like the Murach series of books for beginners. SQL 2005- http://www.murach.com/books/sql5/index.htm SQL 2000- http://www.murach.com/books/sqls/index.htm (probably only need one version) Yeah, big thumbs up on the Henderson books...
  15. bjb123

    Need help with SQL Query

    And if you need the amount to be > 0 then just add that criteria to the where condition Select Distinct p1.Owner FROM #PETS p1, #PETS p2 WHERE p1.Owner = p2.Owner AND p1.Pet = 'Lizard' and p1.Amount > 0 AND p2.Pet = 'Dog' and p2.Amount > 0
  16. bjb123

    Need help with SQL Query

    I think you can also do this with a self join, using the table created above Select Distinct p1.Owner FROM #PETS p1, #PETS p2 WHERE p1.Owner = p2.Owner AND p1.Pet = 'Lizard' AND p2.Pet = 'Dog'
  17. bjb123

    Novice wants a more descriptive error message

    I use the select case error handling, like lameid posted, when I want to give more descriptive error messages. The duplicate record error number is 3022, so just plug that into the error handling code posted above.
  18. bjb123

    Developing In Access

    One of the benefits of an Access front end is that if you allow users the ability to write their own select queries with the QBE they can develop a greater understanding of the data and the relationships between tables. At my company some of the users have become so proficient with the QBE...
  19. bjb123

    can't keep form from opening on new record

    Check the DoCmd.OpenForm line that opens that form. perhaps that line includes acFromAdd, forcing it to open in DataEntry mode
  20. bjb123

    On Open Event of Query

    Why not change it to a make table query?

Part and Inventory Search

Back
Top