I get some error on the alias columns;

OUTER APPLY (

SELECT

MAX(CASE...

Ok. I will look..

But is there any option for a subqeury (COALESCE), CROSS APPLY...

Tnx for the quick responds.

Ye it still dont work.. I think Alvin's recommendation makes my qeury not quicker..

Is there a better way to make my query syntax, on which way.

It must be like this;

Level 1 Level 2

Level 3 Level 4

Level 5

1 10

100 1001

100100

I fix this problem with a update storeprocedure;

-- Set to date flags

MERGE DIM.DATE AS target

USING

(

SELECT

DATE.DAY_WID

-- Week

,CASE WHEN DATE.WEEK_CURR_F = 1 AND

DATE.WEEKDAY_NUMBER <= CWN.WEEKDAY_NUMBER THEN 1 ELSE 0 END AS

WTD_CURR_F

,CASE WHEN...

Give some more information about your tables..

Read this (http://www.infoworld.com/article/2613700/big-data/amazon-s-redshift-for-big-data-analytics----the-pros-and-cons.html )

https://technet.microsoft.com/en-us/library/aa337169(v=sql.100).aspx WORKING URL

karim.boulahfa (2/18/2014)

---

Hi BI Crew,

Im compare 2 column to find errors. Now I want only the red color columns.

Im using the following expression;

=iif(Fields!Serial__.Value = Fields!item_sc.Value, "LimeGreen", "Red")

Im using the following SQL...

yayomayn (2/18/2014)

---

Once you have deployed an SSRS report you can edit the subscriptions and get it to be emailed to whoever you like at whatever time you like.

See the...

Do you have any errors or printscreen??

The table incident get deleted en will be filled by this package.

MysteryJimbo (12/3/2013)

---

karim.boulahfa (12/3/2013)

---

MysteryJimbo (12/3/2013)

---

You're inserting a value into incident_ref.

You're primary key (incident_id) is not set as an identity so you need to insert a unique value since you cannot have...

MysteryJimbo (12/3/2013)

---

You're inserting a value into incident_ref.

You're primary key (incident_id) is not set as an identity so you need to insert a unique value since you cannot have a NULL...

Do you think if I change the Primary table to Null will it fix it ??

And can I make it agian NOT NULL