Hi,

I dont understand  you, I can create view, but when I use 'with schemabinding' then problem occurs.  I read conditions for creating indexed view and this schemabinding is obligatory. I...

I try create indexed view but it is not possible on linked server table. I must use with schemabinding, this is problem/error. Can I create indexed view on linked server tables? Is...

My problem:

I have very big table and I need to store (physically) from table only small sample (select from one table) of date. Originaly I would to create view but...

Yes,

thank you, that is what I need.

zdenek

And why

In the following table, the column on the left represents the style value for money or smallmoney conversion to character data.

Great,

and which day is last of mont (31.1., 28.2., .......), but no datename.

thanks