You didn't seam stupid and I hope that you...

You didn't specify what didn't work. I guess that the select statement was executed, but you didn't get any results. You...

NULL is an anknown value, so when ever you compare null to another value, the results will be falls. For example - if you'll run the script bellow,...

In log shipping the log is backed up. The log includes both open and close transactions. Each time that the log is being restored the server applies all...

You can limit the memory by running sp_configure with the 'max server memory (MB)' option. You can also do it from the GUI - right click on the...

ananda.murugesan (12/16/2008)

---

Hi ,

We are running SQL 2000 server database for our websites.

When we look sqlservr.exe inTask Manger lot of memory ( upto 1.7 GB ) and also cpu usage ...

Hi Christopher

Why do you think that it is because of date parameter? As far as I know parameter...

You are not missing...

I do remember that syslog existed as a table in SQL Server 6.5. If I remember correctly it was removed with SQL Server 7.

Adi

You can do it. You have to include the price in your query. I don't have your tables' structure so I can't show you how to do it,...

When you use path mode and you want to have hirarchies you need to use correlated queries. The script bellow creates 2 tables, insert some data into them and...

Barkingdog (12/15/2008)

---

Thaks for the interesting reply but when I ran your (CTE?) I got

1jack15.00

4Fred35.00

The first row is exactly what I want but the second row is not. I expected 17...

Here is one way of doing it:

with GetName as (

select myID, min(MyName) as MyName

from GroupingTest

group by myID)

select GetName.MyID, GetName.MyName, sum(MyMoney)

from GetName inner join GroupingTest on GetName.myID = GroupingTest.myID

group by GetName.MyID,...

I see that you already got...

Did you remember to run sp_addserver with the local parameter? If you didn't you should run the statement

exec sp_addserver 'NewName', 'local'

Adi