-- if this outputs the results you want to delete,

SELECT b.*

FROM dbo.MediaDetails b

INNER Join dbo.MediaHeader a

ON a.MediaId = b.MediaId

WHERE NOT EXISTS (

SELECT 1

FROM dbo.BaseForecast c

WHERE c.Quantity > 0...

No, they're just pictures. It's like asking for a car and being given a picture. Execution Plans are active - hover over objects to view properties etc.

Right-click on the execution...

Can you attach the actual execution plan please, saved as a .sqlplan file? Thanks.

My mother cursed all the bl00dy time!

How are you fixed for this now...

So...you're ok with stepping through the stored procedure to pick up the error, or do you still need help with this?

Stuart Davies (1/10/2014)

---

ChrisM@Work (1/10/2014)

---

David Burrows (1/10/2014)

---

Grant Fritchey (1/10/2014)

---

ChrisM@Work (1/10/2014)

---

Grant Fritchey (1/10/2014)

---

Jeff Moden (1/8/2014)

---

rodjkidd (1/8/2014)

---

Weather update, as Grant has discovered it gets dark here very quickly, that and the rain and...

What error message are you getting?

Try putting this in your batch and comparing to the original stored procedure:

SELECT RIGHT(@MYQUERY,50)

Can you convert the process...

David Burrows (1/10/2014)

---

Grant Fritchey (1/10/2014)

---

ChrisM@Work (1/10/2014)

---

Grant Fritchey (1/10/2014)

---

Jeff Moden (1/8/2014)

---

rodjkidd (1/8/2014)

---

Weather update, as Grant has discovered it gets dark here very quickly, that and the rain and wind seems to...

Grant Fritchey (1/10/2014)

---

Jeff Moden (1/8/2014)

---

rodjkidd (1/8/2014)

---

Weather update, as Grant has discovered it gets dark here very quickly, that and the rain and wind seems to be the story of the...

pietlinden (1/9/2014)

---

Cruel Taskmaster <g>,

I have a dumb question - if I use a non-looping solution, how do I indicate that no more treatment cycles should be added for an enrollee...

David Burrows (1/9/2014)

---

;WITH a (bill_no,cust_det,product,Price,bill_date,rowid)

AS (SELECT bill_no,cust_det,product,Price,bill_date,ROW_NUMBER() OVER (PARTITION BY bill_no ORDER BY price DESC) FROM Bill_max)

SELECT bill_no,cust_det,product,Price,bill_date

FROM a

WHERE rowid = 1

ORDER BY bill_no ASC...

raghuldrag (1/9/2014)

---

Hey Sri ,

Lets Consider table like

create table Bill_max

(

bill_no int,

cust_det int,

product varchar(20),

Price int,

bill_date datetime

)

insert into bill_max(bill_no, cust_det,product,prize,Bill_date) values('25','ram','Milk','25','01-apr-2013')

insert into bill_max(bill_no, cust_det,product,prize,Bill_date) values('25','ram','Perfume','150','01-apr-2013')

insert into bill_max(bill_no,...

-- Always check first

SELECT pdate, odate FROM #Temp WHERE pdate < odate

-- Then run your update

UPDATE #Temp SET pdate = odate WHERE pdate < odate

Here's another method using just a view as Jeff suggested. Same table as previously, different view.

CREATE VIEW vwSymptoms AS

SELECT * FROM (SELECT TOP 449 * FROM Data WHERE [Version] =...