How to retrieve maximum date from table?

Hi,

I just need to know if I can create a table which will automatically get dropped after N number of days. The reason is I create lots of physical tables in side sp's to store the logging and mail it, when there is any issue that table is retained in the database. I know that this can be replaced with global tables (##table_name). But just need know to if I can create table like this. Can any one know how to do this?

Thanks is Advance,

Chaks.

These fiscal calendars would be created for parent companies. We have added the parent company ids to the date dimension table. Please suggest the correct way of setting the attribute relationship in the above scenario. If this is not the right method to do this, please suggest the correct design approach for achieving this.

Thanks in advance,

Hamlin Stephen

Hello,

I have to tables with dates, table Employments with all employements of all employees, with start date and end date, and a table Mutations with mutations (e.g in salary) with start dates.

Now I try to write a query which returns a record for each day an employee is in employment, with the correct salary. SO at first, it should return all days between the employment start date and the first mutation date, then the number of days between the first mutation date and the second mutation date etcetc, and at last the number of days between the last mutation date and the employment end date. The number of mutations varies for each employment, and employees cna have multiple employments (history, so not at the same time) in the employments table.

How to do this?

Yes I'm a newbie learning but I' developing a web app using Visual Studio 2010 where it gives the user three items to pick from and base on what they pick it returns the sub-category information which is in a SQL table.  The three name below are ListItems 

O  Author-1

O  Author-2

O Author-3

 [SubmitButton]

  (below is the return information, the liskt of books that author wrote)

 Book1

 Book2

 Book3

Book4

Would the code behind my Submitbutton(Default.aspx) be as follow:

Protect sub button1_click () handles button1_click

  Dim connectionString as String = "server='localhost'; user id = ''; password = ''; database = ''"

 Dim sqlConnection As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection(connectionString)

Dim queryString As String = "Select  titlebooks * from bookTBL"

Dim sqlCommand As system.data.SqlClient.SqlCommand = New System.Data.SqlClient.SqlCommand(queryString, sqlConnection)

sqlConnection.Open

Dim dataReader As System.Data.SqlClient.SqlDataReader = sqlCommand.executeReader(System.data.CommandBehavior.CloseConnection)

REturn dataReader

End Function

hi all.. i want to retrieve latest 10 values from my table,i use sql server 2000.. how can i query my database? pls help 

Hi i am getting following error message while merging. Can any one please help?

We are using sql server 2005
I have this problem in publisher.Gone throught his article http://social.msdn.microsoft.com/Forums/en/sqlreplication/thread/b0bbc330-91df-45d5-8dbf-e2df461a8005 but no luck.

The merge process could not retrieve column information for table 'dbo.tablename'. Verify that you have sufficient privileges on the database and retry the operation. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201016)
Get help: http://help/MSSQL_REPL-2147201016

Could not find stored procedure 'dbo.MSmerge_sel_sp_6481B06512B54C91FCC171C542E7'. (Source: MSSQLServer, Error number: 2812)
Get help: http://help/2812

Thanks