Viewing 15 posts - 16 through 30 (of 42 total)
Looks like we can go on forever
Your first query is correct, but the second one will...
July 28, 2004 at 2:56 am
This is irritating!
Why is no testing done by SqlServerCentral of the Question of the Day?
One day you are supposed to see the query typo, and...
July 28, 2004 at 2:27 am
Hi alzdba!
I do agree that the first querys where-statement is unnecessry and correct statement should be:
SELECT DISTINCT
[Account#]
FROM [System_Account_Association]
WHERE [Account#] NOT IN (
SELECT [Account#]
FROM [System_Account_Association]
WHERE [Associated?] LIKE 'YES' )
July 28, 2004 at 2:11 am
Hi Jerry!
Without solving your first question the correct syntax for the second query should be:
SELECT c.InnerID
FROM (SELECT Customer.InnerID FROM Customer) c
July 28, 2004 at 1:35 am
Hi again!
I was a pain From the last information I do realize (read understand) your question. You only need to use the last...
July 28, 2004 at 12:37 am
Hi!
One "easy" way to have a redundancy without having the cost of enterprise edition and clustering is to on a scheduled basis move db-backups and logs from one server to...
July 27, 2004 at 11:50 pm
Hi Bufsabres!
Good linkes to Microsoft about the two versions:
http://www.microsoft.com/sql/evaluation/overview/default.asp
http://www.microsoft.com/sql/evaluation/features/choosing.asp
And yes, you can use OLAP with both version.
July 27, 2004 at 3:42 pm
Hi Juan!
There are loads of new features in SQL 2005. Not to sure if I like an upgrade this big as moving to the next version of SQL. Half of...
July 27, 2004 at 3:17 pm
A good basic book for both learing a bit about SQL administration as well as the basics in T-sql is for example "Tech yourself SQL Server 2000 in 21 days"...
July 27, 2004 at 3:10 pm
Sorry for beeing a pain here, but where is the information stored about system that you mention?
Write down either the structure of the two tables, or those tables that are...
July 27, 2004 at 3:02 pm
Hi Ramona!
Could you please write down the table structure of those tables that will be involved in the query? If I don't missunderstand your question, there should be at least...
July 27, 2004 at 8:45 am
Hi Kris!
There are some differences between the two, but not that much. You have i.e. log-shipping in enterprise edition and:
Enterprise: 32 processors, 64 gb memory
Standard: 4 processors, 2 gb memory
Both...
July 27, 2004 at 8:26 am
You can't.
If a user has ddl_admin-rights, they are able to alter existing tables as well as other objects.
July 26, 2004 at 6:26 am
It's correct that the SQL Server service that holds the database you need to back up should run under an NT-account with local administrator group on server A. The same NT-account should...
July 26, 2004 at 5:34 am
If you will use both:
Main site push data to sites
Main site get data from sites
You have two choises (as I see it). Either you use a two way transactional...
July 26, 2004 at 3:56 am
Viewing 15 posts - 16 through 30 (of 42 total)