Hi, I would like to know if it is possible to do something like these: 1) select field1,field2 from table_name where line_number_in_table >50 and line_number_in_table < 100 in sql2000? So I would get only those records between the 50 and the 100.. 2) Is there any similar command in sql2000 for rownum in Oracle? Thanks a million!

Simon, thanks for the reply. The scenario is like this: I have (let's say) 3 records or more in my .net page. Example: "John", "123 Anywhere", "City1" "Rudy", "345 Anywhere", "City2" "Tom", "335 Anywhere", "City2" ... ... Is it possible to do a multiple inserts in a stored procedure to save those 3 records or more in a table? If so, how do I pass the parameters since I will not know what is the maximum records that will be sent at once? Thanks. :)

Is there any way to do a multiple inserts in a stored procedure in SQL2000? Please help. Thanks.

Thanks for reply. I have turn off the HTML option. Please check the question. Thanks.

I tried to view a pop-up window message when a user wants to delete a record from a data grid. This is my code for the aspx page: What I want to do is, if somebody hit "Delete", there should be a small pop up window giving a confirmation before does any record deletion. Here is my code from my class: protected void DoItemDelete(object sender, DataGridCommandEventArgs oArgs) { /// we should call a confirmation window here by using JavaScript? /// How do we call a Javascript Y2MTimeSheet.Setup.UserRegistrationClass objUser = new Y2MTimeSheet.Setup.UserRegistrationClass(); Int32 iUser_ID = Convert.ToInt32(((Label)oArgs.Item.FindControl