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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by bitbrain

  1. bitbrain

    text searching --

    or that :)
  2. bitbrain

    Recursive SQL? Im stuck!

    The trick is to join the table to itself. Let's assume that your table is named Item and has the following column names: Desc, PK, FK Your SQL would look something like this: SELECT Item.Desc, Item_1.Desc, Item_2.Desc FROM (Item LEFT JOIN Item AS Item_1 ON Item.PK = Item_1.FK) LEFT JOIN...
  3. bitbrain

    text searching --

    The only way I know of - from a database perspective - is to use the like operator (select * from table where text_field like '%variable%') Don't expect performance to be great. I would start with like and go from there. There must be utilities to parse out & index key words. Anybody know of...
  4. bitbrain

    Paritioned views in SQL 7 Developer edition

    Unless I'm missing something check constraints are used for data storage (add/update), not retrieval. The bigger question is, why were the tables "partitioned" to begin with? Doing so defeats the purpose of a database system. My guess is that the performance hit for union'ing 100...
  5. bitbrain

    running a sql statement from a .sql or .txt file

    How about a .bat/.vbs script to execute each of the .sql files via isql?
  6. bitbrain

    XML with SQL Server 2000

    Do you have server-side scripts? One approach... When building the form, store the primary key for each row in a hidden input field. When the form is submitted issue separate deletes for each of the rows i.e. if the check box is on build the delete statement dynamically using the value of the...
  7. bitbrain

    T-SQL Looping?

    It's a good idea to keep administration stuff inside the database so TSQL is probably the way to go. Try using a cursor to spin through the result set & dump.
  8. bitbrain

    My First Trigger, how to?

    Great, glad things worked out.
  9. bitbrain

    Switchboard change depending of user log

    Hi yoshi88, The "controls" on your form (buttons, labels...) should have a visible property. Add code to the form's load event to check the admin id and set the appropriate visible properties to false. Hope this helps
  10. bitbrain

    My First Trigger, how to?

    Following is a complete trigger that I use. It probably has more than you are looking for but it does the type of thing that you are trying to do. if exists (select * from sysobjects where id = object_id('dbo.proc_stat_update') and sysstat & 0xf = 8) drop trigger dbo.proc_stat_update GO...
  11. bitbrain

    Selecting the first or last record

    Variation: select * from beverage_sales where time_of_sale = (select min(time_of_sale) from beverage_sales) or time_of_sale = (select max(time_of_sale) from beverage_sales)
  12. bitbrain

    Access Project Triggers

    In Access you can define a relationship between the two tables and enable cascading updates. The same functionality could then be coded in SQL Server as a trigger. However, this is a no-no from a design perspective. The customer table should have a primary key that NEVER changes. Use an...
  13. bitbrain

    My First Trigger, how to?

    Triggers have access to two virtual tables called “inserted” and “deleted”. Use select statements to get at the columns & build string for emailing. Keep in mind that an update is a delete and an add. So old values can be retrieved from deleted and new values from inserted. Following is a...
  14. bitbrain

    Shecduled Job Sequencing

    I have a similar situation. What I do is use a “status” table to keep track of what is running & Utilize two SP’s. For example: Sched SP_A to run every two minutes SP_A checks the status table to see if SP_B is running. If not, run SP_B SP_B starts by turning indicator on in the status...
  15. bitbrain

    I NEED JCL TO MERGE 2 FILES INTO 1

    You can use IDCAMS, SYNCOSRT would also work. SYNCSORT is good if you need to select records, summarise, sort, etc. Following is a IDCAMS example:<br> <br> //STEP1 EXEC PGM=IDCAMS <br> //SYSPRINT DD SYSOUT=*<br> //DD1 DD DSN=FILEIN1,DISP=SHR<br> // DD DSN=FILEIN2,DISP=SHR...
See more

Part and Inventory Search

Back
Top