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!

Recent content by dabdo555

  1. dabdo555

    Getting rid of spaces

    So....you think its that EASY ehhhh????....well....ehhhh....youre right....thank you! :)
  2. 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???
  3. 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...
  4. dabdo555

    Stored Procedure from Trigger

    The print statement was only for testing purposes. Here's some sample data and what will happen to it.... -user updates a record -view's update trigger fires and basically states... ALTER TRIGGER InsUpTrg_vwPIWDB on dbo.[PIW DB] INSTEAD OF Update AS BEGIN UPDATE dbo.[tblPIW_DB1] SET...
  5. dabdo555

    Stored Procedure from Trigger

    My stored procedure looks like this... ALTER procedure pCalcFinancial(@prop_num int) as declare @x int, @y money select @y= isnull([Acq Price],0) from tblPIW_DB1 where tblPIW_DB1.prop_num = @prop_num update tblPIW_DB1 SET [Acq Price]=1235 where tblPIW_DB1.prop_num = @prop_num select @y=...
  6. 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...
  7. dabdo555

    Trigger variables

    The reason i am storing the fields in variables is b/c i am going to include a formula that uses multiple values from fields. That result will be stored in a variable and then set to a field in the update. Is there a way to do this?
  8. 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...
  9. dabdo555

    Declare variables in trigger

    im sorry, but one more question, can you have if statements in there as well???
  10. dabdo555

    Declare variables in trigger

    sorry, there is only one set but use your imagination. :)
  11. 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...
  12. dabdo555

    Trigger that calculates

    will that update statement only update the entry thats being changed or will it go through the whole table and apply it to all the entries? Im guessing it will just manipulate the one entry
  13. dabdo555

    Trigger that calculates

    those represent fields in the tables. Im sorry i wasnt very thorough
  14. 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...
  15. 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...
See more

Part and Inventory Search

Back
Top