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 derfloh 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: *

  • Users: LNBruno
  • Content: Threads
  • Order by date
  1. LNBruno

    Row Height and Column Width Different

    Why is a row with height = 5 so much thinner than a column width = 5? < M!ke > Don't believe everything you think.
  2. LNBruno

    #temp from prod - error on insert back into prod from #temp

    Anyone hit this one before? SELECT * INTO #tempTable FROM dbo.ProdTable WHERE 1 = 0 INSERT #tempTable SELECT --list of values from other tables; column count matches TRUNCATE TABLE dbo.ProdTable INSERT...
  3. LNBruno

    Recommended reading?

    Hi, all. I'm making the switch to 2005 (yea!) and am looking for one or two good reference books (budget). Any suggestions? Any I should rule out? < M!ke > I can say nothing, which is cowardly, I can lie, which is immoral, or I can tell the truth, which will upset people. - Tiki Barber
  4. LNBruno

    DTS Pkg Designer Locks on Edit

    I have several legacy DTS packages which I am managing through the Package Designer add-in with SQL Server Management Studio. I am able to edit Properties in these packages EXCEPT for the Properties of the main workflow step. Attempting to do so causes the Package Designer to lock up, with my...
  5. LNBruno

    Signs of the Times

    Search is broken, so I don't know if we've gone here before. Lately, I've taken notice of some unusual and, I'm sure often, unintended phrases in signage. Here are a few. What are some of your favorites? Sign... ...outside a chiropractor's office: "Trying to get pregnant? We can help!"...
  6. LNBruno

    WoW - it's a start

    >. Some Words of Wisdom my baby sister has finally recognized: 1. Do not walk behind me, for I may not lead. Do not walk ahead of me, for I may not follow. Do not walk beside me either. Just pretty much, leave me alone. 2. The journey of a thousand miles begins with a broken fan belt and...
  7. LNBruno

    Most annoying English phrase?

    I'd like to lead off with one (of thousands) of my favorite(s): To which I always want to add something like: Okay, Word Police! Let's hear 'em! < M!ke > I am not a hamster and life is not a wheel.
  8. LNBruno

    Save ALL SPs as files

    I know how to do this the hard way; looking for something a bit less labor-intensive (SQL Server 2000). I can get a list of all stored procedures on the current database like this: SELECT Routine_Name FROM Information_Schema.Routines WHERE (Routine_Type = 'Procedure'...
  9. LNBruno

    Time Travel!

    I'll be replacing the following with a DateAdd(DateDiff()) method... DECLARE @datetime DATETIME SET @datetime = '7/5/2007 11:59:59 PM' -- so what day is it? SELECT CAST(CAST(@DateTime AS INTEGER) AS DATETIME) -- and what time of day? on what day? SELECT CAST(@DateTime - CAST(@DateTime AS...
  10. LNBruno

    Why Do Software Development Projects Fail? Again?

    If the CFO rules, as appears to be the driving force in most organizations, then the cost of business software development (BSD) has to be offset by a Return On Investment (ROI) generated by the end product. I have seen BSD projects fail for the following reasons (not inclusive or in any...
  11. LNBruno

    It seemed simple at the time...

    I have a table that looks like this: ID ReferenceNo IDtype 123456789 555-1111 EIN 234567890 555-1111 ITN 345678901 555-1111 SSN 456789012 555-2222 EIN 567890123 555-3333 SSN The same reference number can have one or more IDtypes. What I want to do is to...
  12. LNBruno

    Can I avoid dynamic SQL?

    I've got a database (2000) with 12 tables - one for each month (rolling 12). I've got an ugly gob of dynamic SQL to get the job done of totalling for the last 12 (loop through temp table with tablenames + processed flag), but would LOVE to replace it with non-dynamic SQL. Any ideas? I mean...
  13. LNBruno

    Date-based tables + columns

    Sometimes, ya just gotta deal with bad design. Case in point: I needed to get data which is stored in "monthly" tables. To make it even worse, some of the "monthly" tables have "monthly" columns. Take a look at the result set at the bottom to see examples. Anyway, here's a block of code I...
  14. LNBruno

    Quick Quiz on Code Style

    Before I attempt an update or delete, I always check to see if the primary key exists and, if not, return a message to that effect. For example: IF EXISTS (SELECT PrimaryKey FROM dbo.TableName WHERE PrimaryKey = @InputParam) --transaction wrapper removed for brevity... BEGIN...
  15. LNBruno

    Low priority: Underscore not recognized in LIKE ?

    We have a bunch of tables with an 'S_' prefix and I wanted to get the identity columns for them so I ran this: SELECT o.name AS [Table Name] , c.name AS [Column Name] FROM sysobjects o JOIN syscolumns c ON o.id = c.id WHERE o.type = 'U' AND COLUMNPROPERTY(o.id, c.name...
  16. LNBruno

    SP log - code reuse + maintenance tips

    Hi, all. I'm setting up a table in our database to store pertinent data concerning stored procedures to aid with code reuse during development and to assist in future maintenance. Here's the table structure: CREATE TABLE dbo.SPlog ( pkID int IDENTITY ...
  17. LNBruno

    Nested procedures - if N fails, rollback A through M?

    Seems like these things always come up on Fridays! I've been tasked with implementing transactional processing for a particularly nasty set of nested stored procedures. There's one entry-point procedure that calls 12 others, each of which does a bunch of calculations and then inserts or...
  18. LNBruno

    Output value, Return Parameter, and/or Raiserror?

    Hi, all. Our dev team had a bit of a heated discussion about when to use output values, return parameters and rasierror messages in stored procs for a new project. Naturally, I figured I'd just ask the pros! So, at the risk of opening a huge can of worms, what do you all think? Is there...
  19. LNBruno

    SELECT DISTINCT...list?

    Why oh why do I try to write code after 4pm on Fridays? I've got a 3-column UserCustomerContact table: userID customerID contactID ------ ---------- --------- me 1 1 me 1 2 me 1 3 When I run this: DECLARE...
  20. LNBruno

    Version control for stored procs?

    One of the requirements for my current assignment is that all development be set up in a version control software package (ClearCase, not that it really matters). I've been told this is to include stored procedures (???). This is a first for me. I've always relied on nightly backups, but that...

Part and Inventory Search

Back
Top