Viewing 15 posts - 23,656 through 23,670 (of 26,486 total)
Let us drop back 10 yards and punt.
First, answer the following question, what are you attempting to do with this particular query? Are you trying to return all records...
November 19, 2008 at 3:26 pm
Different angle of attack. When making a reservation, do you keep trying until you find an available RunNo & RunType? You don't have a screen that returns open...
November 19, 2008 at 12:36 pm
Here is a question that should be asked of the system:
Given:
CheckInDate = 11/11/2008
CheckOutDate = 11/14/2008
RunType = Large
What RunNo is available?
Based...
November 19, 2008 at 12:21 pm
Nope, doesn't help. Based on your current sample data, we have 6 reservations for a Large runtype, and run number L100. Based on the information provided, 2 of...
November 19, 2008 at 12:16 pm
From Books Online (BOL) :
Members of the db_ddladmin fixed database role can run any Data Definition Language (DDL) command in a database.
So, answer, yes.
November 19, 2008 at 11:36 am
It does, but it points out an error in your sample data as well. If we make the assumption (as ReservationID is an identity column) that the reservations were...
November 19, 2008 at 10:51 am
Post the DDL for the tables and indexes. Can't really tell what the issue is based solely on your post. Also, post the DDL for the database as...
November 19, 2008 at 10:46 am
How about showing us what your are talking about? Could you post the DDL for the table and some sample data?
November 19, 2008 at 10:44 am
Not really. Based on that some of the sample data should have been rejected. Could you please explain the results expected based on the sample data. I'm...
November 19, 2008 at 9:37 am
Is there more to the error message than just this: Error: 913, Severity: 16, State: 8?
November 19, 2008 at 9:20 am
Could explain in a little more detail exactly what you are trying to accomplish? Also, could you explain in more detail what is supposed to happen with the following...
November 19, 2008 at 9:08 am
Just an observation, but you really should evaluate if the Primary Key (Reservation ID) is actually the best choice for your clustered index on the table. You should review...
November 19, 2008 at 8:36 am
shailesh (11/19/2008)
Where dbo.ufn_GetDateOnly(EndDt) <= '01/01/2009'
And doing this can result in your query not taking advantage of indexing on a table. If your tables are small, you may not...
November 19, 2008 at 7:09 am
The code samples I provided will actually go either way. They go backward with positive values, and forward with negative values. A little counter-intuitive, but that was because...
November 19, 2008 at 7:04 am
I don't think the comments here are meant to be elitist, just frustration. There have been threads on some forums where more information has been requested, the OP has...
November 19, 2008 at 7:00 am
Viewing 15 posts - 23,656 through 23,670 (of 26,486 total)