Hello, I have a table where I want to insert values for each day and each ID: Table: Availabilities HotelID (bigint) Day (datetime) Availability (smallint) to ensure that a hotel can only have one Availability Value for each day (e.g. 2008-06-10 00:00:00) I see two solutions: HotelID and Day as combined...

I have written a query that when executed directly from the query analyser takes about 15 seconds to execute. When I make a stored procedure out of this query it takes several minutes to get the same results. When I look at the execution plans of both version the big difference is that the query uses...

This is not the answer you want to hear, but the best practice for primay keys is to use data column that does not include any unique information that can be used to identify the content of the row, which is what you are trying to do. Ideally, a primary key should be independent of the data in the row...