I find separating the join criteria from the filter criteria makes working with multiple table queries easier. Also, I would rewrite your current query using a CTE to replace...

Mani (11/14/2008)

---

hi,

Iam using the below procedure to Backup system Databases. It is taking the backups of master,model msdb in all instances except one instance it is not taking msdb backup?...

I'd say by looking at what types of queries are being run against the database. You can als look at the missing index data management views and see what...

What is the error??

kent.kester (11/14/2008)

---

I need some advice. I'll lay out my current backup plan (that I inherited) then what I'm wanting to move to.

Currently:

*Full Backups Daily at 6AM: ...

This code handles the values provided by Seth.

DECLARE @test-2 TABLE

(ID INT, TXT VARCHAR (MAX))

INSERT INTO @test-2

SELECT 1,'A'

UNION ALL

SELECT 2,'A'

UNION ALL

SELECT 2,'B'

UNION ALL

SELECT 3,'A'

UNION ALL

SELECT 3,'B'

UNION ALL

SELECT 3,'C'

UNION ALL

SELECT 4,'This...

I wouldn't use a case statement either. Here is what i would do (and some of this you should have done, ie the create table and insert statements)

create table...

That may be a good primary key, but remember that doesn't mean it should necessarily be the clustered index.

timscronin (11/13/2008)

---

is it possible to do a case statement in a join. I have an order table which needs to join to a location table. It can join...

homebrew01 (11/14/2008)

---

I'm trying to restore a large DB temporarily to retrieve a table, in a less than ideal situation, but it's my only option right now. The database is 700...

Just one thing to think about. The Primary Key isn't always the one that should be the Clustered Index. As you look at the processing that occurs, you...

Problem: You won't give us what we ask for so we can't provide you with the answer you are looking for.

You only give us half answers to our questions, what...

May just be me, but I'd keep the filter in the stored procedure, unless the users also have access directly to view and not just using the stored procedure.

Even disabled jobs can be run. You can do so manually by right clicking on the job and selecting start job, or using msdb.dbo.sp_start_job stored procedure.

paul.starr (11/13/2008)

---

CREATE TABLE [dbo].[CustomerAddresses](

[CustomerID] [dbo].[C_ID] (nvarchar(30))NOT NULL,

[AddressTypeID] [dbo].[C_ID] (nvarchar(30))NOT NULL,

[CustomerAddressID] [dbo].[C_ID] (nvarchar(30))NOT NULL

insert into dbo.CustomerAddresses

(CustomerID, AddressTypeID, CustomerAddressID)

values('48313', '1', '48313-1')

('48313', '4', '48313-4')

...