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

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

    Getting rid of spaces

    I have a string that I want to get rid of any blank spaces at the end of it. Example.... "John Doe " to "John Doe" Is there a way to find the last character spot and then delete off the rest???
  2. dabdo555

    Calling Stored Procedure

    I have an 'instead of update trigger' for a view. I would like to call a stored procedure from this view. I put the code into the trigger, I know the procedure works, Ive tested/executed it. But the trigger doesn't execute it. Here is what the update kind of looks like... ALTER TRIGGER...
  3. dabdo555

    Stored Procedure from Trigger

    I have an update trigger for a view in my database. I would like to have the trigger execute a stored procedure when it runs. The trigger basically updates two tables with the inserted data. The stored procedure calculates a formula by receiving the primary key from the inserted table and...
  4. dabdo555

    Trigger variables

    I have a trigger that I want to do the following... create calc trigger on tblPIW_DB1 instead of update as begin declare @x money, @y money select @x= isnull(i.[Acq Price],0), @y= isnull(i.[Over Head],0),... from inserted i UPDATE dbo.[tblPIW_DB1] SET [Acq Price] = @x, [Over Head] = @y...
  5. dabdo555

    Declare variables in trigger

    Below is the trigger code im working on. I need to know a couple of things. One, is it okay to have declared variables in my trigger to store a calculated field's value? Two, is it okay to have multiple sets like i do in the code. any help would be great. SET QUOTED_IDENTIFIER ON GO SET...
  6. dabdo555

    Trigger that calculates

    I have a database that consists of two tables, table A and table B. These two tables are joined in a view. There are a couple fields in table A that I need to calculate values for everytime an entry is updated. The reason im using a trigger is b/c these calculated fields get there values...
  7. dabdo555

    Setting up Roaming Profiles

    I run win2000 adv server and have multiple users. I want to set up roaming profiles for the users so that anyone can logon to any machine and see their email within the network. How in the world do i create these profiles? Is there something in win2000 adv or do i have to go out and make...

Part and Inventory Search

Back
Top