Wayne, it may look like your query is close, but I'd still recommend starting again. Here's a good point from which to start:

DECLARE @School int, @Term int, @Score varchar(2), @Task...

You're welcome. Any issues, questions?

Top job! Anytime 🙂

Sure, pretty straightforward - use ROW_NUMBER() as for Scenario 2. Can you give it a shot?

DROP TABLE #NewTempTable

CREATE TABLE #NewTempTable

(

StartTime DATETIME,

EndTime DATETIME,

ServerName VARCHAR(10),

Databasename VARCHAR(10),

STATUS VARCHAR(10)

)

INSERT INTO #NewTempTable (StartTime, EndTime, ServerName, Databasename, [STATUS]) VALUES

( '2013-12-23 15:00:48.847' , '2013-12-23 15:00:48.852' , 'Server A' , 'DB A'...

Then how are you - or we...

raghuldrag (12/30/2013)

---

here i can such example

create table estr

(

custo int,

product varchar(20),

val int,

billed_date datetime

)

insert into estr(custo,product,billed_date,value) values('10','Milk','2013-04-11','2000')

insert into estr(custo,product,billed_date,value) values('10','Milk','2013-04-21','500')

insert into estr(custo,product,billed_date,value) values('10','Milk','2013-05-05','100')

insert into estr(custo,product,billed_date,value) values('10','Milk','2013-05-11','2000')

insert into estr(custo,product,billed_date,value) values('10','fruits','2013-05-11','500')

insert into estr(custo,product,billed_date,value) values('30','fruits','2013-04-11','2000')

insert...

;WITH rCTE (TaskID, BasedOn, Interval, TaskLevel, TotalInterval) AS (

SELECT TaskID, BasedOn, Interval,

1 AS TaskLevel,

TotalInterval = Interval

FROM #tblTasks

WHERE TaskID = 1

UNION ALL

SELECT e.TaskID, e.BasedOn, e.Interval,

c.TaskLevel + 1,

TotalInterval...

Lowell (12/27/2013)

---

I've got teh same answer ad Ed Wagner does, i just processed your post through a macro so i had some consumable data.

if you want solid help like that...

Nottingham - being mistaken for one of the entertainment crew. Making holes in the lawn with Hugo K and hearing his MERGE talk. Hearing most of Grant Fritchey's talk and...

Here are a couple of potential solutions. They are only "potential" because there isn't any sample data to interrogate. I've knocked up a sample table to assist you and others....

DECLARE

@AcquisitionServerAlias sysname = 'AcquisitionServer3' ,

@AcquisitionDBName sysname = 'Mydb',

@begintime datetime = '2013-12-29 19:52:27.760',

@FromSQL nvarchar(300),

@FromParam nvarchar(50),

@ReturnFromLSNValue binary(10),

@fromLSN binary(10)

SET @FromSQL = 'SELECT @FromLSNOUT = fromLSN FROM OPENQUERY ('+@AcquisitionServerAlias+', ''SELECT '+@AcquisitionDBName+'.sys.fn_cdc_map_time_to_lsn('+@begintime+')as fromLSN'')'

PRINT @FromSQL

'Msg...

saum70 (12/30/2013)

---

Hi all,

Thanks for your replies. Yes Group by was missing but it was not the concern. Anyways, i figured out and got the performance. I used clustered index on...

GilaMonster (12/30/2013)

---

Ok, after another frustrating thread of 'why do you want to remove that operator from the query, is it causing problems', the next article on the to-do list (after...

dwain.c (12/26/2013)

---

I hate to be the bearer of bad tidings during this holiday season, but this just came to my attention this morning.

Steven Willis, whom some of you may know...