Thanks, all guys for your input.

I dont' have an option to change anything in source table (TT), biz behind this snippet is to select all orders for given day...

Thanks much Koen,

So looks like it not deterministic, I think our biz should take care of it.

M

Thanks much !!!! Eirikur !!!

I got it generally:

Learning now how this works:

ROWS BETWEEN UNBOUNDED PRECEDING

...

Thansk much, Luis.

Best

Mario

Thanks,

I finished with char(160) aka hard space, which also can be produced by ALT+0160,

Tx

Mario

Jack, Thanks much.

Case solved !!!!!

Best

M

Thansk, David.

Yee, it was dummy question, closer look revealed that it's really easy if working with groups

Best

Mario

Yes, as I have only 2 active db, I finished with union for 2 of them.

Thanks

M

Thanks, Gregory !!

I heard that these days ( after 2008R2) we don't need to CREATE #Temp , you can just do SELECT * INTO #TEMP FROM dbo.Table,...

Thanks, all

Yes, I did reseed and it worked.

DBCC CHECKIDENT ('Person.AddressType', RESEED, 10);

Thanks much, Eirikur !

I also plan to put it all into SSRS 2012 with Columns Groups and I assume that's it's better do as much as possible in SQL.

Best

Mario

Thanks to all.

IT works now,

I made a lot of changes.

1. FW alllow for specific range

2. TCP port 80 FW allow

3. Added user to Report Manager

4. Added user to my SQL...

Yes, Ruser able to follow my link and has error like standard missing permission:

User 'RUser' does not have required permissions. Verify that sufficient permissions have been granted and Windows...

Thanks all,

that our setup, we all do local work, don't have any common SSRS server,

Biz users just want to get access to our SSRS server to validate reports.

I setup security...

Thansk, Jessie

Yes I got it, I finish with making sp1,2,3,4 for each of dataset even main portion for all of them is the same, hope it will run with...