Hugo Kornelis (10/28/2010)

---

deepak.a (10/27/2010)

---

To get the records with NULL value the WHERE condition needs to rewrite as WHERE NullableColumn <> '1' OR NullableColumn IS NULL.

For the above you can write...

thanks for the Nice Question 🙂

To get the records with NULL value the WHERE condition needs to rewrite as WHERE NullableColumn <> '1' OR NullableColumn IS NULL.

For the above you...

Nice question 🙂

Jay_Noob (10/19/2010)

---

I would make the parameters dependent as others have suggested.

If you absolutely had to produce an error message, you could set a hidden boolean parameter (e.g. HIDE)...

Daniel Bowlin (10/19/2010)

---

You do it by making your available parameter values come from dependant queries. For example the available values for your enddate would come from a query something...

Hi Daniel thanks for your reply can you please tel me how to set the cascade option im using SSRS 2008

Try the Below Code

SELECT

CASE WHEN EXISTS(SELECT 1 FROM secondtable S WHERE S.col1 = S1.col2 ) THEN '*' ELSE '' END + CONVERT(VARCHAR,Col1) AS Col1,Col2

FROM firsttable S1

thanks for the nice question

thanks for the good question

Hugo Kornelis (10/15/2010)

---

deepak.a (10/15/2010)

---

Hugo Kornelis (10/15/2010)

---

deepak.a (10/15/2010)

---

one more doubt on creating the index on computed columns

(...)

in the above Quesries second one (Query 2) thrown on error while creating the index...

Hugo Kornelis (10/15/2010)

---

deepak.a (10/15/2010)

---

one more doubt on creating the index on computed columns

(...)

in the above Quesries second one (Query 2) thrown on error while creating the index on computed column...

Hugo Kornelis (10/15/2010)

---

henrik staun poulsen (10/15/2010)

---

Hugo,

<<If you want to index a computed column, you must persist it.

Are you sure?

I've just added a computed column to one of our big tables...

Hugo Kornelis (10/15/2010)

---

tilew-948340 (10/14/2010)

---

Hardy21 (10/13/2010)

---

Good question.

If computed columns are persisted in nature (e.g. QTot AS QF1 + QF2 PERSISTED,) then you receive the error after "Insert Zeroes" print statement and...

Thanks For the Good Question Tom Brown i learnt some thing new today and also i tried to create index on the computed columns it will not alllow to create...

Thanks for the nice Question 🙂