I normally use SP to restrict what user can and can't see, by passing the user ID as parameter from the SSRS report. The soluting in this article is...

Thanks for the good article, Amit. I was looking for a way this morning to find all the dates between start date and end date, and there you go,...

Nice one! thanks for sharing.

After browsing through the internet, it seems like that feature is not support in the current SSRS versions.

the following article would be a good example for you to understand the varaibles in SSIS package:

http://sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx

you can use a variable to hold the table name. The new file name can then pass to this variable while running the SSIS package.

Yeah, nice one, Chris.

yes, only on the assumption that no price changes will be made on the same day, otherwise both scripts will break...

_simon_, try the script in my last post, it should only return 6 rows, rather than 7 rows..

Dugi (6/18/2009)

---

I can not see where did you change your code in your last post but again no same results as simon wants !!!

As I can see and little bit...

_simon_ (6/18/2009)

---

Hey, of course this are sample data 🙂

Maybe this is better representation of actual data:

if object_id('tempdb..#temp') is not null drop table #temp

create table #temp (item varchar(10), price1 money, price2...

VM (6/18/2009)

---

What do...

try this one..

SELECTItem, price1, price2, date

FROM#temp

WHEREdate = (select max(date) from #temp)

UNION

SELECTdistinct T.Item, T.price1, T.price2, (case when (T.price1 = C.price1andT.price2 = C.price2) then C.Date else t.Date end)

FROM#temp T

INNER JOIN#temp...

SQL Server returns the resultset which it can return fastest. So it would be that 4 is fastest to return for this statment.

If ORDER BY clause is...

if you are expecting 1, try this

select @id = min(id) from @table where [name] = 'SQL Server 2005'

and why are you expecting 1?