L' Eomot Inversé (5/1/2013)

---

ChrisM@Work suggested that I should revisit the complex many-to-many relationship thread, so I've done so. I found it quite difficult to avoid calling the OP an idiot,...

How about a sample table script?

Sean Lange (5/1/2013)

---

ChrisM@Work (5/1/2013)

---

Sean Lange (5/1/2013)

---

So what exactly is the issue here?

I would suggest you use the newer join constructs. With this query you don't even need a where clause.

Here...

Sean Lange (5/1/2013)

---

So what exactly is the issue here?

I would suggest you use the newer join constructs. With this query you don't even need a where clause.

Here is the syntax:

from...

kabaari (5/1/2013)

---

select s.partNo, p.descript,

sum(case when battState = '99' then qty else '0'end) as CLNT,

sum(case when battState = '1' then qty-newQty else '0'...

Where's [NewQty]?

Heck no!

Have you tested the code yet?

KoldCoffee (5/1/2013)

---

Oh yeah! Nice. Thanks Chris.

In the real world case I have several CTEs in each statement. ie. ct1, followed by ct2, followed by final select. Which CTE...

You should consider replacing the slow slow cursor with a fast set-based equivalent:

UPDATE a SET

Transferred = 'Y'

OUTPUT

a.LoanTypeId,

a.LoanAmount,

a.LoanRate,

a.LoanYears,

MonthlyPayment = a.LoanAmount/(y.Result-1) * (a.LoanRate*y.Result),

a.[Status]

INTO Loans

FROM Applications a

CROSS APPLY (SELECT NumberOfPeriods...

...

/**Check if Loan exists**/

SELECT @RowCount = Count(*)

FROM Applications

WHERE ApplicationID = @ApplicationID

IF @RowCount = 0

BEGIN

PRINT 'Applicación' + @ApplicationID + ' no está aprobada o activa';

ROLLBACK TRANSACTION -- complete the transaction...

KoldCoffee (5/1/2013)

---

Chris,

thanks for reply. I should have posted what the result set was that I'm after. There should be two rows for each person, one recording total count of...

Left join the scores table to the weeks table. If you mock up sample data scripts, folks will show you exactly how.

Is there any reason not to use this? CURRENT_POINT > ' '

LEN ignores leading spaces, you don't need to trim. However,...

Beatrix Kiddo (5/1/2013)

---

I know this is a popular one and I've Googled it but I haven't found anything that has worked yet, so apologies if this is incredibly obvious.

I'm trying...