Raghavendra Mudugal (8/19/2014)

---

hmm, say you have a form of 10 text boxes, you enter a sequence of numbers, one in each box, you knew the start, you knew the end,...

Steve

Yes, I was being facetious about F5! But if it's the number of rows you're worried about, it's very easy to modify my test harness. I'm sure the...

sgmunson (8/19/2014)

---

And I have to wonder if your sample size is large enough. While the CPU time values for the string manipulation are less than half those of...

Normally, I'd agree you. On this occasion, however, the string manipulation appears to beat the...

Cast as char(4), put a colon in the middle, then cast as time.

John

Chandan

It's not entirely clear what your requirement is, but if I understand correctly, I think the simplest solution is to use a CTE or add a computed column to your...

TomThomson (8/18/2014)

---

There are cases where READ UNCOMMITTED isolation level is acceptable: the obvious case is the case where you know for certain, perhaps because a ban on certain actions at...

I recommend you investigate the reasons behind your performance issue before implementing this workaround. If you must do it, you can control the cluster from a command line -...

The important message appears to be "The device is not connected". What is your T drive - a local drive, a SAN drive, a drive with mount points, removable...

Look at the properties of the connection manager DestinationSCODatabase. What is the name of the server? What authentication mode does it use? If it uses Windows authentication,...

Prabhu

You haven't really given us enough information to help you properly. But what I would try is to list the columns in your SELECT statement instead of doing SELECT *,...

Adam

A SQL Agent job is intended to run unattended, so you can't pass parameters to it. You could create a table with date column(s) that contain the dates to...

There's all sorts of things. You're trying to use a stored procedure (OH_Message) as a function. You're trying to assign a value to a variable (@status) without a...

Brandie

Is it a witness you're looking for?

John

WITH Starts AS (

SELECT

CUSTOMERID

,TIER

,STARTDATE

,RECORDSTATUS

FROM

TEMPHISTORY

WHERE

RECORDSTATUS = 1

)

, Ends AS (

SELECT

CUSTOMERID

,TIER

,STARTDATE ENDDATE

,RECORDSTATUS

FROM

TEMPHISTORY

WHERE

RECORDSTATUS = 0

)

SELECT

s.CUSTOMERID

,s.TIER

,s.STARTDATE

,DATEADD(dd,-1,e.ENDDATE) ENDDATE

FROM

Starts s

LEFT JOIN

Ends e

ON

s.CUSTOMERID = e.CUSTOMERID AND s.TIER = e.TIER

AND

e.ENDDATE > s.STARTDATE

John

Edit: - this may not be the...