I removed the parameter from the SP and executed the SP (declare local variable and assign value instead) and it ran fine. I got the results in about 7 minutes. I tested this change in one server and I am testing it in other servers now. I will let you know. Thanks.
2005-03-08
I can't see your hard drive, so the image doesn't show, but the screen does take a few seconds to fill in (about 6 seconds for me). What I see in the mean time is some gray backround at the top for what will be a menu and three horizontal rules spaced out a bit […]
2005-03-02
Jon McMullin - You need to read the rulles before posting unhelpful comments.People need to know that they can post their problem here without people sneering at them - we've all done silly things, but hopefully we learn by them.
2005-02-25
Here's a shot in the dark:USE NORTHWIND SELECT CustomerID , COUNT(*) No_of_Orders , DATEDIFF(d,MIN(OrderDate), MAX(OrderDate)) TimeSpan , COUNT(*)*1.0 / DATEDIFF(d,MIN(OrderDate), MAX(OrderDate)) DailyOrder FROM Orders WHERE CustomerID = 'ERNSH' AND (OrderDate >='19960717' AND OrderDate <='19960723') GROUP BY CustomerIDBtw, since this is an exercise given to you, don't you think you should find the solution yourself?
2005-02-24
the following article could possibly help (it's about using AS and RS, look towards the end re: actions) but will depend a little on how dynamic you need to query. If it's only ever going to return customers etc, then this may work for you.http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp steve.
2005-02-20
2005-02-18
Thanks for the feedback. I tried this...-------------------------------------------<% var to = Server.CreateObject("ADODB.Recordset"); to.ActiveConnection = MM_s4r_STRING; to.Source = "SELECT newdate, news FROM dbo.news"; to.CursorType = 0; to.CursorLocation = 2; to.LockType = 1; to.Open(); var to_numRows = 0; %><%= Response.Write "&news=" & Server.URLEncode((to.Fields.Item("news").Value)) %> <%= Server.URLEncode((to.Fields.Item("newdate").Value)) %><% to.Close(); %>________________________________________--Response was 500 error. Microsoft JScript compilation error '800a03ee' Expected […]
2005-02-14
I'm not too sure of the rules of American football however if you are prepared for a little foreign intervention try Rugby. If Rugby looks too sissy try Australian football. The Aussies don't like to waste drinking time so they seem to have integrated the best aspects of rugby and the post match punch-up into […]
2005-02-13
Laughing - there are times I am working with my European collegues and their day starts many (many) hours before mine and ends somewhere within 30 minutes of my first cup of coffee at my desk. When I work with Asian countries I have the opposite issue. By the way, Frank is always on line.....
2005-02-11
IF you cannot see it and you know it is there CREATE a NEW package.... Only way I know of...
2005-02-09
I recently received a complaint that Query Store for a particular database was turned...
Hello Hello, We. Are. Back! The schedule for EightKB 2024 Edition has been announced!...
By Steve Jones
I had a customer that was looking to document a restore that had occurred...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers