WayneHess (12/30/2013)

---

Thanks. I've tried that to make sure my numbers are correct and I can get the numbers to pull correctly even filtering down to one section and get my...

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...