I don't know your schema so consider this as psudocode, but this will be faster due to the fact that it isn't using a cursor (as suggested previously). Then, if possible, I would add datetime columns which you can use to compare the date your _CustomerUpdate table was changed with the date your CustTreeNodeAccountAssoc table was updated. This will prevent the need to retrieve all 600K+ records, that will also considerably speed things up and it will scale better as the number of records increases. Declare @ARbal money, @CustTreeNodeID uniqueidentifier, @CustomerNumber varchar(50), @CustomerUpdateID int, @LYSales money, @LYTDSales money, @YTDgm money, @YTDSales money, @MTDSales money, @LMTDSales money Declare @t table ( CustomerUpdateID int, CustomerNumber varchar(50), YTDSales money, LYSales money, ARBal money, LYTDSales money, MTDSales money, LMTDSales money ) insert into @t(CustomerUpdateID, CustomerNumber,YTDSales, LYSales,ARBal, LYTDsales,MTDSales,LMTDSales) select CustomerUpdateID, CustomerNumber, YTDSales, LYSales, ARBal, LYTDSales, MTDSales, LMTDSales from _CustomerUpdate u where exists (select 1 from CustTreeNode c join CustTreeNodeaccountAssoc ca on ca.CustTreeNodeID = c.CustTreeNodeID and (u.LYTDSales != ca.LYTD or u.YTDSales != ca.YTD or u.MTDSales!= ca.MTD or u.LMTDSales !=ca.LMTD )) -- REPLACE YOUR CURSOR WITH THIS CODE BELOW (or something similar that better fits your logic) UPDATE A YTD = T.YTDSales, LYTD = T.LYSales, Balance = T.ARBal FROM @t T INNER JOIN CustTreeNode N ON N.CustomerNumber = T.CustomerNumber INNER JOIN CustTreeNodeAccountAssoc A ON A.CustTreeNodeID = N.CustTreeNodeID Mark's blog: developMENTALmadness.blogspot.com

Hi, Use Max function to get the largest number from the table. The syntax is: SELECT MAX(net_amount) FROM Sales; SELECT MAX(company) FROM Sales WHERE net_amount > 100; I hope this would be helpful. Vinay ComponentOne LLC. www.componentone.com

Although the data type is char, but the data in the column is numeric then you can convert the field and then compare. select * from table_name where cast(field_name as int) = 100; Om Prakash Pant

select UserID, BeginningDate, EndingDate, From tableName where UserID = @UserID and ((BeginningDate >= @BeginDate and EndingDate <= @EndDate) OR (BeginningDate >= @BeginDate) OR (EndingDate <= @EndDate)) Hope thats what you want ? "A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder coolestCoder

That worked wonders, I can even use the same logic to grab the beginning of the week. Thanks

@"(^\$([1-9]\d{0,3}|0)\.\d\d$)|(^$)" This SHOULD allow "$1.45" "$0.00" "$50.10" This should NOT allow "$00.00" " $0.00" "0.00" "$0.0" I make no warranties. Jeff

Your question is not very clear to me. If you want to do something when you double click on a cell (and avoid doing anything if the user double clik on the header) you can do something like this, private void gvList_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { int miHitRow = Convert.ToInt32(e.RowIndex); if (miHitRow < 0) return; //your code }

you can select a cell with set the Selected property of that cell to true like this.dataGridView1[0, 0].Selected=true; hope the post would be useful good luck :)

You want to check before or after inserting? below logic will help you. Before Inserting ------------------ check whether there is any ZIPCode exist within the range sql --- Select @begin = count(ZIPBegin) from tblZIPCodes where ZIPBegin between 12345 and 12346 Select @end = count(ZIPEnd) from tblZIPCodes where ZIPEnd between 12345 and 12346 If @begin > 0 or @end > 0 -- then there is an entry within that range already exist else --perform the insertion After Inserting ---------------- BEGIN TRANSACTION --Insert the records -- then use the same sql stmt written above to get the value of @begin and --@end If @begin > 1 or @end > 1 -- multiple entries has been made ROLLBACK TRANSACTION RAISERROR RETURN else --perform the insertion COMMIT TRANSACTION Regards John

Something like: create procedure dbo.usp_InsertZipCodeRange @StartZip int, @EndZip int as begin declare @CurrentZip int if (@StartZip > @EndZip or @StartZip < 0) begin raiserror 'Invalid arguments specified' return @@ERROR end if exists (select 1 from dbo.ZipCodes where ZipCode between @StartZip and @EndZip) begin raiserror 'Specified range overlaps existing Zip codes' return @@ERROR end set @CurrentZip = @StartZip while (@CurrentZip <= @EndZip) begin insert into dbo.ZipCodes (ZipCode) values (@CurrentZip) set @CurrentZip = @CurrentZip + 1 end return 0 end If Zip codes are strings then Right('00000' + Convert(varchar, @CurrentZip), 5) should allow you to convert an integer value into the appropriate string. Regards Andy If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message".

Its both actually. I want to be able to select True or False two buttons, then pass that true or false value back to my datagrid. Do you have an example of how I can do that or does it all really depend on how data is passed back to the form?

Add a Column/Link button to the row, handle the cell content click event and pass a reference to the row data to the new form: private void dgv_CellContentClick(object sender, DataGridViewCellEventArgs e) { DataGridView dgv = sender as DataGridView; if (dgv.Columns[e.ColumnIndex] is DataGridViewButtonColumn) { DataForm df = new DataForm(dgv.Rows[e.RowIndex]); df.ShowDialog(); } } I think that should do it! -- modified at 17:33 Wednesday 18th July, 2007

Perhaps I should have mentioned I wrote this in C#.net. Thanks for the help though I can kindve determine how this is supposed to work.

Alright I get that but say i wanted to populate one user's information from my table on to my web pageafter the selectedIndexChanged event, and I also want to be able to update, edit and delete that info, but I don't want to use a datagridview. How can I do this?