mgr_2k7 wrote: How should I view it? Poorly. This code is a mess and made less readable by the fact you haven't enclosed it in pre tags. When I did decipher the code, SPWebApplication is a Sharepoint class, so you've posted to the wrong forum. CCC solved so far: 2 (including a Hard One!)

try this select convert(varchar(10),cast(datevalue as datetime) ,120) from dateformats where convert(varchar(10),cast(datevalue as datetime) ,120) ='2007-10-01' Date Thu Sep 20 06:32:10 GMT-0400 (EDT) 2007 will not work for this query because it will cause convertion error exception. I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com

That's why i gave you such a great book suggestion. You should read it.

This is the sample code I used..... Word.ApplicationClass oWordApp = new Word.ApplicationClass(); oWordApp.Visible = true; Word.Document oWordDoc = oWordApp.Documents.Open(ref fileName, ref missing, ref readOnly, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref isVisible, ref missing, ref missing, ref missing, ref missing, ref missing); oWordDoc.Activate(); Can u plz help me?

mgr_2k7 wrote: Can any body post an article for opening Word, Excel, Presentations using C#. If possible include PDF as well. Thanks a lot. That would be a very short article as you can do it in a couple of lines using the framework. Deja View - the feeling that you've seen this post before. My blog | My articles

Thanks a lot guys. U all were a lot of help. Finally got it. ;P

I want the autocomplete feature on for all of them. ;)

I am extremely sorry if u have mistook my All Caps as being angry. I was coding the Stored Proc at that time......and as per company standards I had to keep it in All Caps. I am sorry , I forgot to switch it off while typing my problem. Anyways Guys, Cheerz. We have found a roundabout way of handling it. While checking the "select" query was imposing a big chunk, so we have decided to design a tertiary table and use it directly to fetch the records from them. This improved my time around 45%. What intially took us 2:30 hrs to implement 10 lakh records, is now taking us 1:20 hrs. Tx guys for all the help u have provided. :-D ;) Manish Ganguly.

Check this out http://www.codeproject.com/Ajax/AJAXAutoSuggest.asp[^] Vasudevan Deepak Kumar Personal Homepage Tech Gossips Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.

mgr_2k7 wrote: resetskippkgs Quoting from MSDN, this commandline switch is for the purpose of "Clears all options to skip loading added to VSPackages by users wishing to avoid loading problem VSPackages, then starts Visual Studio" Do you have custom addins or third party software that is interfering? You also need to check whether they are interfering? Vasudevan Deepak Kumar Personal Homepage Tech Gossips Regional Weblog (in Tamil) :: Voicing for the Society Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.

FINALLY GOT IT.... HAD TO TYPE THE FOLLOWING IN THE COMMAND PROMPT devenv /resetskippkgs :) ;) :laugh: