Hi, i also facing this problem, is there any solution for this ?

Hi, i also facing this problem, is there any solution for this ?

how do i setup the second network to fulfill those expected result ?

is it to set...

Hi,

i just set up a 2 node failover clustering for SQL SERVER 2008 on Windows Server 2008 R2 Enterprise Edition,

previously i set up using 1 NIC on each...

finally after trying..

i answer my own question

here is the solution

DECLARE @StartNewDate DATE

DECLARE @EndDate DATE

DECLARE @StartHistoryDate DATE

DECLARE @EndHistoryDate DATE

SELECT @StartNewDate = '01-SEP-2011'

SELECT @EndDate = '05-OCT-2011'

SELECT @StartHistoryDate = '01-AUG-2011'

SELECT @EndHistoryDate = '05-SEP-2011'

SELECT

...

Mark-101232 (6/14/2011)

---

Seems to work with your data, also '30-SEP-2012' '31-DEC-2012' is contract 1 and 2, not 2 and 3.

oh yeah , you are right mark, it should be for contract...

what i have done is this :

SELECT distinct

MC.MeterID,

MC.ContractID,

Common.ufnToDateDisplay(cast(Common.ufnGetMaxOfTwoValues( MC.Startdate, MC2.Startdate)as DATE)),

Common.ufnToDateDisplay(cast(Common.ufnGetMinOfTwoValues(MC.Enddate,MC2.Enddate)as DATE))

FROM

@MeterContract MC

join @MeterContract MC2

on MC.MeterID = MC2.MeterID

and MC.ContractID <> MC2.ContractID

and ( MC.Startdate between MC2.Startdate and MC2.Enddate

or MC.Enddate between...