Hey all !!!

we have Grant Fritchey here !!!!

Thanks much for your help !!!!

M

IT works fine, I think we need to run with command line only the whole thing.

Tx all. moving it to SSRS Section

Hi, Star

No I never tried to use IS, on the end I need to store thetm as file with bcp

Tx

M

Thanks Alvyn.

And just tried and got

TITLE: Microsoft SQL Server 2012 Setup

------------------------------

The following error has occurred:

Unable to open Windows Installer file 'C:\X\SQL Server 2012 Install\x64\setup\sql_rsshp.msi'.

Windows Installer error message: The...

you actually got Q#4.:-)

Thansk, Chris

I also bought a base.

Best

Mario

Bingo !!

Yes it works, I didn't put one extra ON in my very first post, now it edited. and below is handy sample I made for all to try.

It...

Thanks all, it's fact that this code works.

I'll try to do homework on demo db to break it completely down.

Mario

<<What it's saying is that IF the Left join row exists , INNER join to that other table.

Otherwise, treat it like a regular LEFT join and put NULL in the...

Microsoft SQL Server 2012 - 11.0.5058.0 (X64)

Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

I heard something about default predicates by same column name, but...

And surely enough my indexed M View was defined with all rules, after getting it indexed it performed hell faster:

all needed option are in placed

SET ARITHABORT ON

SET CONCAT_NULL_YIELDS_NULL ON

SET QUOTED_IDENTIFIER...

In our env we have all by Period= calendar month, so there is still good biz reason to have single column as PeriodID. Surer y enough in it's ref table...

Thanks, Luis

There is table that has corresponding date as date for each periodID, but I think your solution is more lighter and faster.

Taken.

M

Thanks, SS

Is this option can be configured upon setting SSRS Server, so all newly added reports will get parent security ?

Best

Mario