Viewing 15 posts - 47,491 through 47,505 (of 49,571 total)
Could you post that other query please Rob?
February 4, 2008 at 5:18 am
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?
February 4, 2008 at 1:18 am
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
February 4, 2008 at 1:14 am
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
February 4, 2008 at 1:11 am
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
February 4, 2008 at 1:11 am
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...
February 3, 2008 at 11:08 pm
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...
February 3, 2008 at 11:50 am
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...
February 3, 2008 at 7:06 am
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)...
February 3, 2008 at 6:58 am
Standard edition? Enterprise edition? x86, x64 or IA64?
February 2, 2008 at 8:42 am
What about the installation log file?
I can't remember offhand where it gets put, possibly in the dir with the SQL bin files
February 2, 2008 at 1:12 am
TheSQLGuru (2/1/2008)
February 2, 2008 at 1:09 am
What error did you get? Was there anything in the installation log file to suggest a cause?
February 1, 2008 at 1:55 pm
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...
February 1, 2008 at 1:53 pm
Viewing 15 posts - 47,491 through 47,505 (of 49,571 total)