Godd sugestion

if have to use a view due to secuirty reasons , try to create another view which will allign with your job!

Good news. so you didn;t have any problems and I also can follow the same path

this will also work,

select id,max(val1),max(val2),max(val3) from t4 group by id

Your question is not clear to me. ANyway, check whether follwing is suting your porblem.

Select * from Numbers Where CIRC = 9010  and NPA <> 9010 and NXX <> 9010

you can use date add function to add one monthe to the date

DATEADD(m, 1, pubdate)

Same issue. hopr you will get some idea from this

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=117472

Yes u can delete all the tables and empty the logs ,

But as frank said most reliable and easy way is to recreate database from the begining.

In that way...

I think problem is with the view

as it is ordering by a date which is not a index key I supose

I have used version 1.0 to some extend. it was a nice tool. hope version 2 is much better than 1.0

according to the microsoft (http://www.microsoft.com/sql/2005/default.asp) Pricing for SQL Server 2005 has not been finalized.

yes it should give zero records. as you are grouping them by c1,c2,c3. in your query count(c1) is 1

check this

select count(c1), C1, C2, C3 from ex1 group by  C1, C2,...

There are few discussion on this subject earlier on this forum

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=108279

You can search there are few more discussions as well

Did u check this.

http://www.kbalertz.com/kb_280102.aspx

Thank you for all your ideas

Thankx Jamie!