karthikeyan-444867 (11/17/2011)

---

Code inside the function:

select @out_factor = factor from test_xrv

where id = @id and return_date = @out_date

return @out_return

Code inside the proc:

update dbo.test_xrv

set returns = dbo.FnMonthlyFactorsToReturns(id,return_date)

this will impact the performance....

Gangadhara MS (11/17/2011)

---

Hi Experts,

One of the stored procedure is failing with displaying below error.Till now it was runnign fine.

Pls suggest

The statement terminated. The maximum recursion 100 has been exhausted...

DROP TABLE #Doc_Version

CREATE TABLE #Doc_Version (ID INT,DocID INT, OldVersionID INT)

INSERT INTO #Doc_Version (ID, DocID, OldVersionID)

SELECT 1, 233, 230 UNION ALL

SELECT 2, 233, 232 UNION ALL

SELECT 3, 232, 241

DECLARE @OldVersionID...

SQL Kiwi (11/13/2011)

---

L' Eomot Inversé (11/13/2011)

---

OK, going to 1000 yours has 67% of the logical (row) reads that the naive one has and only half the CPU usage. Neither...

Lowell (11/15/2011)

---

I have a coworker who heats up things in the microwave.

(He or She) clicks the Instant 30 seconds button, waits 10 seconds, watching the count down, and then clicks...

There are seven functions in your output list. Guessing from the function names and the passed parameters, a couple of them perform quite complex calculations touching several tables. Your first...

Kiara (11/10/2011)

---

ChrisM@Work (11/10/2011)

---

Kiara (11/10/2011)

---

Stefan Krzywicki (11/10/2011)

---

I inherited a query like that back in 99. It was...

Ninja's_RGR'us (11/10/2011)

---

Kiara (11/10/2011)

---

Sorry...

Kiara (11/10/2011)

---

Stefan Krzywicki (11/10/2011)

---

I inherited a query like that back in 99. It was a 500...

This should do it:

SUM(CASE WHEN e.EQUIPMENT_TYPE_CD like '20%' THEN 1 ELSE 2 END

* CASE WHEN e.BOOKING_EQ_REQ_DETAIL_ID IS NULL THEN 0 ELSE 1 END) AS BookedTEU

This gives you a 1...

It's going to be something like this:

SELECT

tr_trrefn,

tr_abbrv,

Disbs = SUM(CASE

WHEN tr_abbrv = 'BIL' THEN tr_disamt

WHEN tr_abbrv = 'ABT' THEN - tr_disamt

WHEN tr_abbrv...

John Michael Robertson (11/8/2011)

---

Breakwaterpc (11/8/2011)

---

However, one more issue with these tables. I know need to update part of a string that i placed in several different columns in...

John Michael Robertson (11/8/2011)

---

Breakwaterpc (11/8/2011)

---

For some reason, i'm getting all twisted up and bumfuzzled here.

First off, where is this variable "NewValue" getting used once it's cast? Doesn't appear...

Breakwaterpc (11/8/2011)

---

Thanks. However, i'm getting the following with the Select statement:

Msg 402, Level 16, State 1, Line 1

The data types text and varchar are incompatible in the add...

-- run this first for an eyeball check

SELECT r.*, r.comments + ' ' + s.other

FROM civil.dbo.RECEIPTS r

INNER JOIN civil.dbo.subjects s

ON s.Receiptno = r.Receiptno

-- this is the update...from statement

UPDATE r

SET...