What driver are you using to connect to the Oracle server?

Is the report dynamic (requires access to the SQL Server database when viewed) or static (the data for the report is contained in the report when it is sent to...

Yes, looking back at this:

The sharepoint documentation states that high availability mirroring MUST be...

Give this a shot:

select

HourOfTheDay,

sum(case when TimeReceived between GETDATE()-1 and GETDATE() then NumberOfOrdersInBatch else 0 end) as NumberOfOrders,

...

Once again, you really don't need to use CTEs in this example. I am posting my code again, but this time I have included a version using CTEs. ...

george sibbald (5/1/2013)

---

Lynn - I would not ask such a newbie question.

I know how the databases fail over, automatically or not, I was just looking for a second opinion...

Your original code:

create table #temp (ID int, Name varchar(20))

insert into #temp

values

(10, 'Helen'),

(20, 'Joe'),

(30, 'Blake');

;with cte as

(select * from #temp)

select * from cte

union all

;with cte as -- << error is...

Based on your original post, the correct code is this:

create table #temp(

ID int,

Name varchar(20)

)

insert into #temp

values (10, 'Helen'),

...

KoldCoffee (5/1/2013)

---

please don't take the sample scripts to literally. They are over simplified, so my question is still... how to combine the results of the CTEs? Actually, Malleswarareddy_m...

Something or someone has to tell the mirror database to take over as principal. The application does not do this. If you want SQL Server to automatically failover...

No CTEs are needed:

create table #temp (

TicketID int,

Name varchar(20),

Duration int

)

insert into #temp

values (10, 'Helen', 8),

...

george sibbald (5/1/2013)

---

Lynn,

agreed - for the databases, thats a no brainer.

but what about the client automatically repointing to the mirror when the principal goes down,...

Marcus Farrugia (5/1/2013)

---

Hi, I'm looking for the best way to update pkid 1 = pkid 2

update testTable

set

a.fname = b.fname

from

(select * from testTable where pkid = 1) as a

join

(select *...

george sibbald (5/1/2013)

---

We are investigating using database mirroring as a DR solution for sharepoint 2010. the sharepoint documentation states that high availability mirroring MUST be used to achieve automatic redirection...

You have followed the information in the following article: http://msdn.microsoft.com/en-us/library/ms188236(v=sql.100).aspx?