can I get any help on this from the experts in this room ?

Thanks.
I am using select columns (not *) and using sql command.
I tried to load data in raw file to see if its works fine. the load into raw...

The expression is mentioned the first post but I will update that to below:

I am using =Format(Fields!field1.Value,"#,#,,") as custom numeric formating where field1 comes from dataset.
Almost all...

the values are coming from a dataset(stored procedure).Not showing up means the cell is blank for some values(although the value is present in database table).
I read one link warning...

;with mycte as (

select * ,lag(sales,1)Over(Partition by countryid Order by stateid DESC) salesLag

, row_number() Over(Partition by countryid Order by stateid DESC) rn from countrydetails )

select * from mycte where rn=2

I...

I want

countryid country stateid state ...

can someone help me on this.

Correct XML:

DECLARE @myDoc xml

SET @myDoc = '<Root>

<ProductDescription Productname="A" Productd="Road Bike">

<Features Productname="B">

<Warranty Productname="C">1 year parts and labor</Warranty>

<Warranty Productname="D">1 year parts and...

I think I posted the question with less detail. Please find the full detail at below location:

Thanks Eirikur.

I am looking for an output with resultset for value column as :

B/C/

B/D/E

I found one way with below query but this is...

sorry the post is confusing and will be corrected.

yes for octopus

shark>octopus>whale

question is how to get the desired output.

cheers, this works.