N_Muller (12/14/2013)

---

Yes, my table is quite large and it does have primary keys, and I do generate the code automatically. In any case, here's a version that I...

Jeff Moden (12/13/2013)

---

You can also make the GROUP BY a whole lot easier and shorter if you understand that the IndexID for @Tbl is, in fact, unique and that allows...

Sure put this is an expression on the visibility property of an item you only want to export, not show on screen.

(Don't forget the "visibility" property relates to whether the...

In my registry for SQL2012 I have the setting here:

HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio\11.0\General

It is a REG_DWORD value called ReuseActiveDocumentwindow.

You may have similar for SSMS 2008 with 10.0 instead of 11.0

What you need to know is that SSRS formats multiple selections in a parameter as a comma separated list, like this:

"01,-99"

So, when your query runs you are effectively saying

WHERE...

You should read this : http://technet.microsoft.com/en-us/library/dd255216(v=sql.105).aspx

The part you are interested in is Globals!RenderFormat , which will allow you to base visibility of report items on the way the report is...

I don't know how efficient you can get with this, but here is my version

select

t.IndexID

, Status1

, max(case Status1 when StatusId then PriorityID end) as Priority1

, Status2

, max(case...

Instead of asking people to imagine data in a table, if you provide that data in a readily consumable way, you will get much more help.

Have a read of this...

And another slightly different way for the sake of it...

;with data as

(

SELECT p.IPCode,pr.ID,count(*) over(partition by p.IPCode) as UID

FROM [Person] AS p

JOIN [Profile] AS pr

ON [p].[IPCode] = [pr].[IPCode]

group by p.IPCode,pr.ID

)

select IPCode,ID

from...

Why can't you change the proc?

Getting the URL from the database would be the best option.

If you cannot achieve that and need something in the Report itself, you can use javascript instead of a URL...

Without any further info on how you are "getting the next @groupid"....

update pg

set pg.products_xml = x.xmldata

from product_group AS pg

cross apply (

SELECT id, name, price

FROM product

...

Some choices, which one is best for you will depend on your setup.

First though, Country in (@Country) is misleading as @Country is one value, not a list by the time...

Edit: cold light of day made me realize I had posted flawed code...

Try this

select isnull(ltt.Deadline,x.CalendarDate)

from #LocalTempTable AS ltt

cross apply (

select max(calc.CalendarDate) AS CalendarDate

from (

select top 20 cal.CalendarDate

from #Calendar AS cal

where CalendarDate>=DateEntered

and Weekend=0

order by CalendarDate

) calc

) x