Viewing 15 posts - 91 through 105 (of 122 total)
Use Google or Books Online (BOL) to search for the DateADD function.
February 2, 2009 at 6:57 am
You are correct. It's a worst case scenario. 🙂
February 2, 2009 at 5:25 am
For what it's worth:
-- Table A rows - 2412928
-- Table B rows - 2286023
-- The query was to search for records in table where a key value did not
-- exist...
January 30, 2009 at 7:07 am
Aren't left joins and NOT EXIST statements more efficient than NOT IN statements? I don't know if I made that up or read it somewhere. I usually use...
January 29, 2009 at 10:07 am
No takers? Am I asking the wrong question?
Thanks
November 7, 2008 at 6:42 am
You explicitly said, "without a loop". Given this constraint I don't think that it's possible. Why can't you use a loop?
If a loop was possible I would do...
November 6, 2008 at 10:02 am
SQL 2000 for both the calling and called DB
Thanks
ST
August 26, 2008 at 5:35 am
Possibly I'm not being clear. I have a system which needs to get information from another SQL database. It's an admin tool. I want to be able...
August 22, 2008 at 11:52 am
Is there a way to get info from the remote server's sysobjects table using "opendatasource" ?
Thanks
ST
August 18, 2008 at 7:07 am
Thanks, just what the doc ordered.
ST
August 13, 2008 at 12:51 pm
OK, here's the latest information. The issue seems to be different than I thought. The connection via DSN (ODBC) does not work at all regardless of which language....
June 3, 2008 at 9:43 am
Sorry, I forgot to mention that in the client environment I can connect to a SQL server NOT using an instance name. The server that I am having trouble...
May 29, 2008 at 10:01 am
I understand your reason for wanting to reuse the view. I think that if the underlying table is indexed you wouldn't need to also index the view. I'm...
May 6, 2008 at 8:24 am
Is an indexed view really the best choice here? Since you only want data for the latest date that could be accomplished through a function and indexing the table.
May 6, 2008 at 7:45 am
Per Microsoft you can not have a subquery in the from clause.
http://www.microsoft.com/technet/prodtechnol/sql/2005/impprfiv.mspx
May 6, 2008 at 6:37 am
Viewing 15 posts - 91 through 105 (of 122 total)