Search results for query: *

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

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"...

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

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

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

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?

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"...

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

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

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.

record_number is int

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 =...

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

Please let me know if further explanation is needed. Thanks

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

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

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

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

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

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