Hi

I guess NO.

Hi Rusty,

You are right.

Hi

You can use following expression:

=Format(CDate(Fields!FieldName.Value),"MMM - yyyy")

or

=Format(CDate(Fields!FieldName.Value),"MMMM - yyyy")

You can use the wildcard pattern matching characters as literal characters. To use a wildcard character as a literal character, enclose the wildcard character in brackets. Seefollowing examples of...

Which components of SQL Server 2008 can the Resource Governor operate on? (select all that apply)

But there are radio button to select the answer. Then what does it mean by...

Ohh sorry! Mike already posted it.

Thats true.

Hi Shiwani,

Try this

SELECT * From

(

SELECT '123//4' [Value] UNION

SELECT '143' UNION

SELECT '2343' UNION

SELECT '12.34' UNION

SELECT '23*5' UNION

SELECT '23a34' UNION

SELECT '456=' UNION

SELECT '345//4' UNION

SELECT '3434//4/5'

) AS Temp

WHERE [Value] LIKE '%[^0-9/]%'

Hi Fayez,

Are you passing the parameter to drill report?

You need to pass the field value where you want to click.

e.g. in navigation window YourParameter = Fields!Region.Value

And one more thing, there...

Yeah James.

I just copied that line from earlier post and didnt changed it.

But you are right.

Hi friends,

I got solution myself by writing script.

The Best way to use COALESCE function because its very fast compare to other techniques.

select @Numbers = 0, @Strings = ''

SELECT @Numbers = COALESCE(@Numbers,'')+iNumber,

@Strings = COALESCE(@Strings+',','')+sNumber

FROM @demo

No need to write a counter.

Suppose Your tables look like this:

CREATE TABLE TableA (ID int, Name VARCHAR(30)) --Source

INSERT INTO TableA SELECT 1,'james' union Select 15,'vinay' union select 5,'john'

CREATE TABLE TableB...

Hi Venkatesan,

Just check the Keep Identity check box of Destination and try again.

I think NO.

But you can create a parameter which has two values {True, False}