Bank Table:

CREATE TABLE [dbo].[tblCompanyStoreBankDetail] (

 [TransactionID] [int] IDENTITY (1, 1) ,

 [TMID] [int]  ,

 [TransactionTypeID] [int] ,

 [TransactionAmount] [money] ,

 [AccountBalance] [money] ,

 [TransactionDate] [datetime] 

) ON [PRIMARY]

Employee Table:

CREATE TABLE [dbo].[Team_Members] (

 [TM_Identity] [int] IDENTITY (1, 1) NOT NULL ,

 [TM_Last_Name]...

I wasnt sure how to do this any other way.  Im relatively new to TSQL.  The problem i have is that i will need to perform 2 different functions based...

I thought of doing that.  What would be the performance hit in future?  Lets say the system grows to 4000 users with 5 years of transaction activity.  Would the performance degrade...

How do i make the "Balance" field a calculated field?

example data

Table - Bank_Detail

TransactionID     CustomerID     Amount     Balance     Date

1                              1              0              0            1/1/2005

2                              1              10            10           1/1/2005

3                              1              10            20           1/1/2055

4                              1              -10           10           1/1/2005

5                              2             ...

The reason i didnt create a table to hold customer information is because the customers are our employees and we already have employee tables to hold their info.  I will use...

I appreciate the feed back.  You are correct this will be a low volume application.  I anticipate a maximum number of simultaneous transactions at 450 - 500. 

Im in the same boat.  We need to store N. American numbers.  I was thinking of doing it in 2 columns.  Is this the best way to do it?

areacode int 3

phonenumber...

i keep getting a server doesnt exist or access denied error.  I triple checked the server name and verified my nt account has SA privs.  Maybe im doing something wrong.

Thanks for all your help.  Now i have another issue.  How do check determine if a parent record has 0 child records?

Im starting to understand the count(*) and count(column), but what i dont understand is the

"count(column) = 0" statement.  Does this translate to count(column)'s null values = 0?

Removing the odbc outer join escape sequence worked, but didnt improve query performance. I guess i need to find a way to optimize this query or reduce the number...

thanks for all the replies. I believe we isolated the issue. The developer linked to a view, but neglected to specifiy a unique key or keys.

I appreciate the feed back. I think im going to go with the mirrored approach and program the presentation layer to provide old data / new data information. ...

I am trying to create an audit table to capture insert, updates, and deletes. So far, i have it working with the exception of listing the names of the...

Thank you. Im always amazed at how fast the members post on this forum.