DaveDB (10/18/2013)

---

Thank you all very much for your responses and encouragement. I know how to do this in SQL, I was just hoping that SSRS has a faster and easier...

with ten(N) as

(select ROW_NUMBER() over(order by @@spid) from (values(0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) a(a))

,hundred(N) as

(select ROW_NUMBER() over(order by @@spid) from ten t1,ten t2)

,thousand(N) as

(select ROW_NUMBER() over(order by @@spid) from ten t1,hundred h2)

,million(N) as

(select ROW_NUMBER()...

Did you check the database compatibility level?

Jeff Moden (10/17/2013)

---

Gosh... I have to disagree with that statement that you and Sean made. What if the task is...

DaveDB (10/17/2013)

---

Hello all,

I have to say that once again Microsoft has fallen short with their attempt at creating a reporting tool. I have spend the past 2 days trying to...

Yes, that's my point.

Although it's not clear from the help on Technet, I am pretty sure (without a setup to test it on at the moment) that the server name...

I'm really sorry, but I just don't understand what you want.

What parameters do you want default values in ?

What data type are those parameters?

Can they hold other values than the...

Ravikptel (10/15/2013)

---

Hello guys,

I need help with expression in SSRS which can give me last week of the previous month by default. and that only option...

It looks a lot like you are protecting some code from public view, but getting it wrong?

Originally, your parameter @ID was an int, now it seems to be a varchar...

How...

You could use a function to return the three values Hours, Minutes, Seconds for the time difference.

How you then display them is a simple matter of formatting in the front...

jdean-1028471 (10/15/2013)

---

It's nice to see RSScripter is still available, but is someone going to keep it up to date ? As the documentations states, it won't support anything new...

Isn't your linked server called Willis02, not R2D2?

EXEC sp_serveroption 'Willis02', 'rpc out', 'true';

EXEC sp_serveroption 'Willis02', 'rpc', 'true';

This reminds me of an old sql challenge or similar test...

You might want to put this on the end of that query:

where hostprocess<>''

In your version of SQL Server, you cannot use the form

DECLARE @myvar varchar(100) = 'Some Value';

You have to use two statements, one to DECLARE then a SET.

DECLARE @SQLQuery VARCHAR(100);

SET @SQLQuery...