Hi, I have found the solution, so am just posting an answer in case anyone else comes across this. Read the following link for information: http://sqladvice.com/blogs/gstark/archive/2008/02/12/Arithabort-Option-Effects-Stored-Procedure-Performance.aspx[^]

PIEBALDconsult wrote: Probably more portable too? I'd say so. Many DBMS support inline views. The need to optimize rises from a bad design.My articles[^]

Hi, thanks for the advice. I will try this and see what happens - I had registered the controls in the web.config file, but I will try put it onto the page and see what happens.

I am not quite sure what you want your result set to look like. It would be easier if you gave a list of the resultant columns. Are you looking for the last 6 orders of a particular product or simply the last 6 orders?

Browsers don't have the print formatting capabilities to do that. You can only simulate it by creating multiple tables that approx. fit a printed paged. However, each model of priner may print your simulated formatting differently. George -- modified at 5:59 Tuesday 14th August, 2007 "We make a living by what we get, we make a life by what we give." --Winston Churchill

Thank you for the answer.

Yeah i would guess the error is caused by not having the Javascript rendered due to the lack of the dll that contains it all. Take a look in the Assemlies section of the web.config file for a reference to System.Web.Atlas or something along those lines. I don't know for sure because I dont have them in any of mine

WinCVS (for NT) Vasudevan Deepak Kumar Personal Homepage Tech Gossips

Ok, I found a way of doing this, may not be the best, but it what I thought of: DECLARE @Length INT, @Count INT, @RandNum INT, @RandomString VARCHAR(6), @IsValid BIT SELECT @RandomString = '', @Count = 0, @IsValid = 0, @Length = 6 WHILE (@IsValid = 0) BEGIN WHILE @Count < @Length BEGIN SET @RandNum = SUBSTRING(CAST(Rand() AS VARCHAR(20)), 3, 2) IF (((@RandNum > = ASCII('0')) And (@RandNum <= ASCII('9')) Or (@RandNum > = ASCII('A')) And (@RandNum < = ASCII('Z')))) BEGIN SET @RandomString = @RandomString + CHAR(@RandNum) SET @Count = @Count + 1 END END --Check here that the number is unique IF (SELECT certificateSerialNumber FROM Certificate WHERE certificateSerialNumber = @RandomString) IS Null BEGIN SET @IsValid = 1 END END SELECT @RandomString This cannot be used as a function though, due to the RandNumber generator. You can also emit the last part that checks if the value is unique. Change the @Length and @RandomString size to suit the size of the field that you need.

That's as good a way as any. Thanks, they are all gone now. Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog

On XHTML - I've seen a couple of different approaches. Take a look at these links for some ideas: http://weblogs.asp.net/ssivakumar/archive/2004/11/05/252735.aspx[^] http://www.howtodothings.com/computers/a821-ensuring-xhtml-compliancy-in-aspnet-11.html[^] http://www.liquid-internet.co.uk/content/dynamic/pages/series1article1.aspx[^] On the BasePage question for setting the page title - here is a link to a post that I think does exactly what you want: http://wessamzeidan.net/cs/blog/archive/2006/01/18/141.aspx[^]

I don't. Perhaps you could search the control collection of the datagrid for the scroll bar and then remove it from the collection? However, I suspect that the second you add another record or resize the datagrid it would get recreated.

Hi there, I know that this is a kind of annoyed issues, you can quickly work around by copying the assembly obout_SlideMenu_NET.dll to the temp folder of your asp.net application: C:/WINDOWS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET Files/laundry.website/421ec9f8/18ded540

If everything else fails you can P/invoke LoadLibrary and then try to call the functions in the DLL somehow. I think I saw an article here somewhere doing just this, but I could be wrong. Good luck, mav

Stick a breakpoint in, and check that HttpContext.Current.Request.Url.Host returns something sensible - that might be what's confusing it -- Help me! I'm turning into a grapefruit! Buzzwords!