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

  1. JoeZim

    Generate a Group Table

    Sure. For instance, in the resulting Group Table, there is a GroupID = 1 with 5 members (5 AcctIDs are linked to GroupID 1). IF you look at the CollateralAccount Table (I've put them in red text below): CollateralAccount (Table) CollID AcctID 1 1 1 2...
  2. JoeZim

    Generate a Group Table

    Trying to build a dynamic "Group" table. Have the following Tables: Collateral (Table) CollID CollName Account (Table) AcctID AcctName CollateralAccount (Table) CollID AcctID Need to generate a 4th table: Group (Table) GroupID AcctID What I need to do is setup "Groups"...
  3. JoeZim

    Pull all records based on 2 criteria on separate field

    My apologies if the title does not make sense, but I'm having a difficult time even trying to summarize my question. Here it is in a nutshell: I have the following table: Item pos 8529 2 8529 2 161637 2 161637 3 357346 1 357346 2 357346 2 367390 1 367390 1 393538 3 393538 3 393538 3 393538 2...
  4. JoeZim

    Select detail records making up percentage of total balance per group

    Fantastic, this is exactly what I was looking for! Thanks RiverGuy.
  5. JoeZim

    Select detail records making up percentage of total balance per group

    I have the following data: Region Balance NewYork 300 NewYork 400 NewYork 500 NewYork 600 NewYork 700 NewYork 800 NewYork 900 Boston 100 Boston 200 Boston 300 Boston 400 Boston 500 Boston...
  6. JoeZim

    validate money data type

    No, but if someone happens to do so, I'd like to catch it. I am going to use your suggestion of max characters allowed, which should work. Is there a recommended type of validation control for the money data type that also prevents this from happening?
  7. JoeZim

    validate money data type

    I have many update fields in my application to update SQL Server data type money. I am currently using the following compare validation on each field: <asp:CompareValidator ID="vUWIncome" runat="server" ControlToValidate="txtUWIncome" ErrorMessage="CompareValidator" Operator="DataTypeCheck"...
  8. JoeZim

    Arithmetic overflow

    You nailed it SQLSister, the data types were wrong on the trigger. I just made the change and it worked! Thanks so much for that question, I was not considering the triggers. Joe
  9. JoeZim

    Arithmetic overflow

    Here is the table structure as well: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[balance]( [record_number] [int] NOT NULL, [parri_passu_debt] [money] NULL, [senior_mtb_debt] [money] NULL, [junior_debt] [money] NULL, [current_mtb_balance] [money] NULL...
  10. JoeZim

    Arithmetic overflow

    Thanks for your help. Here is the exact error: Msg 8115, Level 16, State 2, Procedure balance_update, Line 30 Arithmetic overflow error converting expression to data type datetime. The statement has been terminated. I noticed it says Line 30, but there are not 30 lines in the statement.
  11. JoeZim

    Arithmetic overflow

    record_number is int
  12. JoeZim

    Arithmetic overflow

    I'm getting the following error: Arithmetic overflow error converting expression to data type datetime. Here is the UPDATE Query: Declare @record_number int, @parri_passu_debt money Set @record_number = 4792 Set @parri_passu_debt = 10 UPDATE balance SET parri_passu_debt =...
  13. JoeZim

    Group By with a Rank

    Thanks for the replies. I decided to take a different approach. Since the result set will be on the small side (2 to 30 records), I used a cursor to accomplish my goal: Declare @unique table ( CustID int, StmtID int, StmtDate datetime, StmtYr numeric, RankID int ) Declare @cCustID...
  14. JoeZim

    Group By with a Rank

    Please let me know if further explanation is needed. Thanks
  15. JoeZim

    Group By with a Rank

    I have the following table: CustID StmtID StmtDate StmtYr Method (Rank) 29874 9 12/31/04 2004 Tax Return (6) 29874 7 12/31/03 2003 Co.Prep'd (5) 29874 8 12/31/03 2003 Tax Return (6) 29874 5 12/31/02 2002 Tax Return (6) 29874 4 12/31/01 2001 Tax Return (6) ** Note: the (Rank) is not in the...
  16. JoeZim

    Need help with select criteria

    Thanks for your help Alex. I actually had a bunch more columns in my sp, so I used your example and tailored it to my needs. Works well! Regards, Joe
  17. JoeZim

    Need help with select criteria

    I have query results from a table, based on ID = '27489': ID Stmt Date Stmt Yr Method 27489 2003-12-31 2003 Reviewed 27489 2004-12-31 2004 Reviewed 27489 2005-12-31 2005 Co.Prep'd 27489 2005-12-31 2005 Unqualified 27489 2005-12-31 2005 Reviewed My results need to be more narrow, selecting...
  18. JoeZim

    Selected node value from MasterPage Repeater Menu

    Thanks for the suggestion, I never knew about this option. It should accomplish what I'm trying to do. Your site looks good!
  19. JoeZim

    Selected node value from MasterPage Repeater Menu

    That's exactly what I'm trying to do. Users can get to a given search page: 1) Using the menu in the MasterPage 2) From a back button after they have done a search If they use the back button, I need to preserve their search criteria (text box values), but if they navigate to this page...
  20. JoeZim

    Selected node value from MasterPage Repeater Menu

    Thanks Mark, I was not sure about this option since the menu automatically sends you to the page via the SiteMap. Would I have to append the name of the page (or the node title) as a variable? Also, which Repeater event would be used to accomplish this? I've played around with...

Part and Inventory Search

Back
Top