Curious, can you recreate the problem using a simple cte instead of a complex one? Perhaps selecting an ID from a base table?

This one won't be easily solved. I am going to need some additional information from you, and I'm going to ask you to read the first article I reference...

Why the requirement for it to be an indexed view? I'm asking as sometimes it just isn't possible based on the data that is being pulled together.

We use HyperBac where I work. The differences I see are the following:

1) All our backups are to individual files. Each full, differential, and transaction log is written...

Not quite what you may have been looking for, but it does separate the date and time.

declare @TestDate datetime;

set @TestDate = getdate();

select

@TestDate as TestDate, -- Original...

sudha.2k7 (6/25/2009)

---

Hi

Could you please tell me if it is possible to use a data conversion transformation from nvarchar to int??

My data needs such a transformation as my manager...

Glad it works for you, and thanks for the feedback.

Heh, I am Saint...

Flo,

I only beat you by a minute. 😉

I only hope he reads the blog, but I doubt it.

I find this down right appalling:

rodan (6/25/2009)

---

We receive replication data from an external source and I want (you) to write a query that will

1. check to see that the data...

Unless there is a requirement that the index names stay the same (Application Supported indexes like in PeopleSoft, used in index hints in queries) there is no real reason that...

GilaMonster (6/25/2009)

---

Gaby Abed (6/25/2009)

---

I can only imagine the discussions that Paul and his wife, Kimberly Tripp[/url], have when they catch each other's mistakes, rare as they may be. Eventually...

Well, i didn't really do that much, looks like you did all the work.

Glad you got it fixed.

You did just what I wanted. Like I said, my brain is already on vacation.

Not sure where to go from here. Have you tried copying the data to...

I have to agree, it does depend. For critical LOB databases, I prefer individual backup plans. For smaller database, I'd be more willing to use a single plan...