Art, all you needed to do was add parantheses around the bolded section to 'pair' those two criteria. That should fix the issue you have with that dynamic query.

BTW...

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...