Try the following:

DECLARE @Table AS TABLE (Score Varchar(4), Percentile int);

INSERT INTO @Table (Score)

VALUES ('80'),('55'),('125'),('99'),('75'),('130'),('37'),('73'),('151');

WITH RANKS AS (

SELECT *, NTILE(4) OVER (ORDER BY CAST(Score AS int)) AS QUARTILE

FROM @Table

),

ASSIGNS AS (

SELECT...

Without any actual data to play with, I can't test this, but you should end up with something like this:

WITH MONTHS AS (

SELECT 1 AS MN, 'Jan' AS MTH_NAME UNION...

This should be fairly straightforward. The question, however, is which of the two tables should be considered the "authority" for the values that are NOT part of the...

I'm pretty sure no one here has any idea what you're question is. Please be specific as to what you want, with as many details as possible to...

How about the following:

DECLARE @Table AS TABLE (Score Varchar(4), Percentile int);

INSERT INTO @Table (Score)

VALUES ('80'),('55'),('125'),('99'),('75'),('130'),('37'),('73'),('151');

WITH RANKS AS (

SELECT *, NTILE(4) OVER (ORDER BY CAST(Score AS int)) AS QUARTILE

FROM @Table

),

ASSIGNS AS...

David,

How about the following?

WITH DIFFERENCES AS (

SELECT Tx.[Item Code]

, ISNULL(Ty.Qty, 0) AS 'A1 Qty'

, Tx.Qty AS 'B1 Qty'

, Ty.Qty - Tx.Qty AS 'A1 to...

Uma,

It was nice to have provided detail in the PDF, but the level of effort necessary to be effective in helping you rises above the amount of time available for...

Why, exactly, would you need this? SSRS provides some of that functionality out of the box. If you go to http://yourservername/reports or http://yourservername/reportmanager (I always forget...

ChrisM@Work (11/21/2014)

---

sgmunson (11/21/2014)

---

Can I ask what might seem like a dumb question? Why is anyone trying so hard to write this query in such a way as to...

Can I ask what might seem like a dumb question? Why is anyone trying so hard to write this query in such a way as to make it...

I happened to do a Google search yesterday, and it brought me to an MSDN page that describes the APPLY operator, and an OUTER APPLY is roughly equivalent to a...

I'm pretty sure Mr. Magoo has your answer, but the bigger and maybe more important question, is why leave code hanging around that is formatted that way, when there are...

Okay, but that hardly begins to answer the questions I posed. ...

That post doesn't really tell me anything you hadn't either stated or implied before, but you also introduced new questions without answering any of the ones I asked. ...

btio_3000 (11/19/2014)

---

sgmunson (11/19/2014)

---

I don't know the direct answer, but why place the ON clause for that LEFT JOIN in a position AFTER the CROSS APPLY unless you intended that CROSS...