LEAD()/LAG() give access to next/prior rows in an ordered set without needing a self join.

http://www.oracle-base.com/articles/misc/LagLeadAnalyticFunctions.php

rebecca.crowdey (4/14/2008)

---

I'm trying to fetch a dataset containing values from the Description field of my table.

...snip...

CREATE PROCEDURE [dbo].[usp_Fetch_DCF_Fields]

@TableName varchar(50),

@RecordID varchar(6),

@KeyColumnName varchar(50)

AS

--create a temporary table into which the mandatory columns are...

here are your first two LEAD() queries translated. i'll leave the third up to you.:)

within the CTE, LEAD() is replaced by ROW_NUMBER(). the LEAD() function's PARTITION BY and ORDER...

Dave Balsillie (4/11/2008)

---

Just add a field to your data source. Assuming SQL (there's a similiar approach for MDX):

newField as Case Type

when 'Owners' Then 'Housing'

when 'Renters' Then 'Housing'

when 'Mediam Price'...

you'll need to post the expected results so i can double check my work.

Tracy Avis (4/9/2008)

---

Hi

I have an expression that I put together:

=IIF

(

Fields!Item_id.Value

in (1,5,6,7,8,9,10,12,13,14,16,20,32,36,37,38,39,40), 1, 0

)

when I try to preview my report I get the following message:

The value expression for the textbox ‘textbox7’...

there is no data column that stores housing/income... those are just categories for the details fields of the matrix. thus "housing" and "income" are purely labels.

Thanks cuz. The empty corner was one my users' biggest gripes!

try simplifying the expression and let RS do the formatting for you.

=Fields!Clicks.Value/Sum(Fields!Clicks_Show.Value, "DataSet1_Get_All_1234567")

then set the format to 0.00%

meghna.bhargav (4/5/2008)

---

Hi Guys,

I have this table formatting problem; In this report each item has 2 rows. I want to split the send row as shown below. So the...

if you want 1 value from 3 columns:

(case when col1 < col2 and col1 < col3 then col1

when col2 < col1 and col2 < col3 then col2

...

When comparing composite keys for row exclusion, you can't simply apply <> to all key members. Consider this simple example of a table with fields f1 and f2, and...

Are (ParentNo, ParentRev) forming a composite key? If not, ignore this post.

But if they are a composite key, the CTE solution won't work since it ignores ParentRev/ChildRev. ...

the problem with synonyms is they're global. so if you're logged into 2 (or more sessions) and redefine a synonym on connection A, connection B's synonym is changed also....

the 'typo' stems from embedded XML tags in the post. when the browser encounters a tag it doesn't recognize (in this case <item> ) it just ignores it. ...