SAT_SQL | SQLServerCentral

SAT_SQL

Forum Replies Created

Viewing 5 posts - 46 through 50 (of 50 total)

RE: see this is my view , i want to apply the non clustered index, why because i cant apply the clustered index because there is an aggrigate functions , so i want to minimize this by applying the non clustered index on tables columns , please check the below view and revert back

Hi Gail
Thanks a lot,
After ur idea i apply the 2-part name , since i am geting some errors, can u please...

June 3, 2009 at 5:16 am

#1003897
RE: see this is my view , i want to apply the non clustered index, why because i cant apply the clustered index because there is an aggrigate functions , so i want to minimize this by applying the non clustered index on tables columns , please check the below view and revert back

Msg 4512, Level 16, State 3, Procedure vwOppValue, Line 4
Cannot schema bind view 'vwOppValue' because name 'tblLeadDetails' is invalid for schema binding. Names must be in two-part format and an...

June 3, 2009 at 12:21 am

#1003783
RE: see this is my view , i want to apply the non clustered index, why because i cant apply the clustered index because there is an aggrigate functions , so i want to minimize this by applying the non clustered index on tables columns , please check the below view and revert back

Hi
It was great , i am really thank full to you , because i can know that easy steps to get the answers to sending the qustions...

June 2, 2009 at 7:24 am

#1003401
RE: see this is my view , i want to apply the non clustered index, why because i cant apply the clustered index because there is an aggrigate functions , so i want to minimize this by applying the non clustered index on tables columns , please check the below view and revert back

Hi
It was great , i am really thank full to you , because i can know that easy steps to get the answers to sending the qustions...

June 2, 2009 at 7:23 am

#1003400
RE: want to apply index on the view , when i apply it shows the error schema is not bound

HI
When i am applying the sbinding it is showing the error as like this .
If u can help it will be great . urgent
Msg...

May 29, 2009 at 12:05 am

#1001894

Viewing 5 posts - 46 through 50 (of 50 total)