Hi,

thank you!

I need to consult values ("CLIENT" AND "VRT") grouping by month/year. The only way I could be it was using convert. Even so, some problems occur when a view, with a filter (month/year),...

Hi,

thank you (two - Noel and Steve)

I just do this - limited on memory properties - and now I have memory for another processes. Thanks again.

Noel,

In columns "CLIENTE", on my...

Noel,

thank you. I have other examples to the same situation. when i execute views, sqlserver takes memory a lot and don't release it. do you now how do it?

thanks

Mairim

Hi,

I'm using a query on -table- open- query.

My tables have 2 indexes. The first, in "CLIENT" colummn is clustered. The second, in "DATE" is not clustered.

I have Administration Access.

I observed...

  AJ

Thank you, very much!!!

Mairim