Actually, it is quite simple - all you need to do is look at what you have.

SELECT *

FROM #DLFiltered

WHERE Active = 1

...

alorenzini (8/1/2008)

---

I know the logic is sound but the issue is that in the case of the following result String:

SELECT * FROM #DLFiltered WHERE Active = 1 AND...

alorenzini (8/1/2008)

---

The problem now is the point of the 1=1 and 0=1 is that I do not want to display the level that have 0=1 but right now it is...

ansz5 (8/1/2008)

---

I am trying to restore a database on SQL Server 2005, using the backup placed on a different server ( in same domain). I have shared the folder and...

You have to include the REPLACE qualifier to replace the existing database. Additionally, you may need to set the database into single_user to get exclusive access.

And, what are the settings for this? It should be one of the following:

o Using TCP/IP only

o Using named pipes only

o Using both TCP/IP...

Great - glad we could help.

No, they need to be dependencies for SQL Server. You need to take SQL Server offline - add the drives as dependencies for SQL Server and bring SQL Server...

Because a GROUP BY totals the set of data and OVER summarizes the data over the set. It's just the way it works. 😉

Here are a couple of options...

Angelindiego (7/31/2008)

---

IF @LocationType = 'CURRENT' and @LocationSearchString = ''

BEGIN

(SELECT

pl.LocationID AS PLocID

----->, @PRegionAbbrev = pl.RegionAbbreviation

----->, @PLocName = pl.LocationName

FROM dbo.Location pl

INNER JOIN dbo.Unit u ON pl.LocationID = u.PresentLocationID

)

END

I got...

MarlonRibunal (7/31/2008)

---

Download SQL Server 2005 SP2 Version 9.00.3042. You don't need to reinstall everything. Just install the Client Components and Notification Services, and you will be fine.

Download here: http://www.microsoft.com/downloads/details.aspx?FamilyID=D07219B2-1E23-49C8-8F0C-63FA18F26D3A&displaylang=en

-Marlon...

Nathan Davis (7/31/2008)

---

I checked the configuration files, and they appear to properly be pointing to the virtual ip for the cluster.

I found out a little additional info - the two...

SQL Server has three recovery models. Each recovery model defines how transactions are dealt with in the transaction log.

Simple Recovery: transactions are cleared automatically so the space can be...

No and No 🙂

You disable the indexes by issuing the command: ALTER INDEX indexname ON table DISABLE;

You truncate a table using: TRUNCATE TABLE table;

Now, if you have foreign key relationships...

drodriguez (7/31/2008)

---

Each day we import data from our mainframe into a SQL Server database. The previous days data is cleared out prior to running the import; the database size is...