Viewing 15 posts - 1,996 through 2,010 (of 3,232 total)
prattmounfield (11/19/2007)
November 19, 2007 at 11:35 pm
pdross2000,
You are correct that you cannot truncate a table with a foreign key and that it may make spot restoring tables a bit more difficult but you are placing...
November 18, 2007 at 8:38 pm
Well, I would wait longer than 15 minutes and see what happens. Don't trust the progress messages, just wait a bit and see what happens. It will take...
November 16, 2007 at 1:55 pm
The problem is that this attitude will force the existence of those spreadsheets/access databases/word files full of data that should be in the database but can't be entered because it...
November 16, 2007 at 1:30 pm
OK, I think what you want is to find the values that correspond to the smallest YearValue for each Value. If this is correct, something like the following code...
November 16, 2007 at 8:41 am
It is not quite clear what you are asking for. Can you give a written description of what you want to get back? Also include the result set...
November 16, 2007 at 8:12 am
Yes, just as Adam said, create a linked server and then run the query using the 4 part names. As for the query, you are looking for rows that...
November 15, 2007 at 2:10 pm
There shouldn't be data to fix if the application is truely handling referencial integrity. The mere fact that this is a concern tells me that you have the illusion...
November 15, 2007 at 8:34 am
Whoa, hold on here my friend. How are you comming to your first end date? There is no 14th month! I thought from your original post that...
November 14, 2007 at 10:22 pm
SQL Noob (11/14/2007)
we have very few FK's where i...
November 14, 2007 at 10:12 pm
Well first of all, any time you run a 'SELECT *' you get a full table scan. Your query plan shows a clustered index scan but in this case,...
November 14, 2007 at 9:54 pm
Please do not cross post. You only need to post your question in one forum!! Continue this thread here:
November 14, 2007 at 9:46 pm
What exactly are you looking for? Do you want to select rows that are different in the 2 tables? Are the databases on the same server or not?
November 14, 2007 at 9:44 pm
Please do not cross post. Continue this thread here:
November 14, 2007 at 9:43 pm
If start date < 1/1/2003, End date = '1/1/2003'-start date + Days
I am a bit confused here. What do you mean EndDate = '1/1/2003' - startdate + Days? ...
November 14, 2007 at 6:08 pm
Viewing 15 posts - 1,996 through 2,010 (of 3,232 total)