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 Chris 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. warelock

    Search all tables, stored procs for a misspelled word

    Again ... wow. Thanks, man. Where can I learn Stuff like this ? MS sites ?
  2. warelock

    Search all tables, stored procs for a misspelled word

    Wow. Thanks, Paul, that really helped !
  3. warelock

    Search all tables, stored procs for a misspelled word

    Morning ! This is perhaps a dumb question. We have mispelled a word - sometimes - in SOME table columns and in SOME stored procedures. (It is 'milage' rather than 'mileage'.) We become aware of this when we run a job and failure occurs because of a mismatch between the table and the stored...
  4. warelock

    Change Management software for SQL 2000 ?

    We need to implement change management in our shop, and I am wondering what experiences you have had with various CM products ? What we want to do is to put version control on stored procs, user-defined functions and DTS packages; be able to recover an earlier version of any of these if we put...
  5. warelock

    CHARINDEX, comma, and stored proc ... puzzling ?!?

    ooooooo ... that is GOOD. Thank you once again, gmmastros !!
  6. warelock

    CHARINDEX, comma, and stored proc ... puzzling ?!?

    This oen really has me puzzled. I have this code in a stored proc : BEGIN DECLARE @BadPattern2 CHAR(10) DECLARE @BadPattern3 VARCHAR(10) SELECT @BadPattern2 = '713,' SET @BadPattern3 = '713' SELECT ItemExplanationCodes, @BadPattern2 AS BadPattern FROM BillItemXML WHERE CHARINDEX(...
  7. warelock

    CHARINDEX(), comma, and stored proc ... puzzle

    This oen really has me puzzled. I have this code in a stored proc : BEGIN DECLARE @BadPattern2 CHAR(10) DECLARE @BadPattern3 VARCHAR(10) SELECT @BadPattern2 = '713,' SET @BadPattern3 = '713' SELECT ItemExplanationCodes, @BadPattern2 AS BadPattern FROM BillItemXML WHERE CHARINDEX(...
  8. warelock

    Need to select alternate column if first choice is NULL

    Many thanks. This helps.
  9. warelock

    Need to select alternate column if first choice is NULL

    Thank you, gmmmastros ! BTW, what are Books OnLine ? Yes, I may be an idiot.
  10. warelock

    Need to select alternate column if first choice is NULL

    I'm working with SQL Server 2000 on Windows XP. IN one query, I want to select a federal tax ID number for each record, but if that tax ID number is NULL, I need to select a different SS ID column. I don't know how to do this ! Can you help me please ? Appreciate any help you can give. Thanks !
  11. warelock

    Disabling html:select

    Thank Venu. I guess I should explian a little more ;-) I am using a collection, and want to set disabled = true if the user is of a certain type and not otherwise. Right now the code looks like : <html:select property="agencyNo"> <html:optionsCollection name="sessionData"...
  12. warelock

    Disabling html:select

    Hi all ! I want to disable an html:select at run time based on user actions. How can I do that - or CAN I do that ? ;-0) Thanks in advance -

Part and Inventory Search

Back
Top