Could you post that other query please Rob?

Could you give the expected output please?

I'm not sure I fully understand your question. What does the code you've written do that it's no supposed to do, or not do what it's supposed to do?

Please don't cross post. It's not necessary, the regular's read all the forums. It also fragments replies and wastes people's time.

Discussion to the following thread please - http://www.sqlservercentral.com/Forums/Topic451025-338-1.aspx

Please don't cross post. It's not necessary, the regular's read all the forums. It also fragments replies and wastes people's time.

Discussion to the following thread please - http://www.sqlservercentral.com/Forums/Topic451025-338-1.aspx

Please don't cross post. It's not necessary, the regular's read all the forums. It also fragments replies and wastes people's time.

Discussion to the following thread please - http://www.sqlservercentral.com/Forums/Topic451025-338-1.aspx

Sure it's possible. 2000 has to be installed first and can be the default or a named instance. SQL 2005 must be installed second and must be a named instance.

Make...

You should be able to create a calculated in the table, then put a unique index on that. It requires quite a few of the connection settings to have specific...

Look at the definition of the file group.

Filegroups are logical collections of one or more files. If you look at the definition of the file group, it will say...

CTEs are essentially temporary views, thus, no setting of vars or calling of procedures.

You can set and use variables in the statement that uses the CTE. -

;WITH Testing (ID)...

Standard edition? Enterprise edition? x86, x64 or IA64?

What about the installation log file?

I can't remember offhand where it gets put, possibly in the dir with the SQL bin files

TheSQLGuru (2/1/2008)

---

Thanks for the testing Gila! I wonder if there is an indication hidden somewhere in the full XML plan or exec query stats or some other DMV that...

What error did you get? Was there anything in the installation log file to suggest a cause?

Left join, to match all records and include the ones that don't have a match, then a filter to eliminate the rows that do have a match.

SELECT customerId

from customers...