Viewing 15 posts - 46 through 60 (of 217 total)
Gail, I'm in SQL profiler, and I ran it while executing the stored proc. Is there anything I should be looking for besides stmtCompleted? I see a bunch...
November 26, 2008 at 8:17 am
Yes, the stored proc is being run via an ASP website.
Thank you!
November 26, 2008 at 7:55 am
Im sorry...I'm using SQL Server 2000...what is sp_stmtcompleted?
Thanks!
November 25, 2008 at 1:30 pm
Well, if a page sequence of one does exist, then it prints the results and executes the 2 UPDATEs. If I manipulate the web app such that there is...
November 25, 2008 at 11:58 am
I added that to the SP and it prints the folderId and the results from the query.
Thank you
November 25, 2008 at 11:40 am
It's kind of long, but here it goes:
/**
* Shifts a page up within the folder that contains it by changing its pageSequence value.
*
* @param pageID the...
November 25, 2008 at 11:14 am
Thanks...I replaced my count with the exists statement, while working, it still runs the 2 UPDATE statements regardless of the results of the EXIST statement.
I even checked manually in query...
November 25, 2008 at 10:27 am
Jack, thanks for the post.
I tried your query, and it took about 2 minutes to run and returned 44,000 results(all zeroes).
My original query is
SELECT COUNT(EL.eventTargetId) AS NumberofHits
FROM na_production.dbo.EventLog EL...
May 1, 2008 at 7:21 am
Matt, thanks for the response!
I am trying to get the number of hits for each folder. And I am also trying to get the folder that has the maximum...
April 30, 2008 at 9:59 am
The problem is, is that due to security issues and network policy(which I cant change), the ONLY port that is open between the machine with Managment Studio and the DB...
March 4, 2008 at 12:35 pm
Would IsNull work for empty fields or just NULL fields?
Would something like this work?
CASE name
WHEN '' THEN 'UNKNOWN'
ELSE name
END AS Name
January 15, 2008 at 10:06 am
Thanks...so other than that, it looks good?
Thank you!
December 19, 2007 at 7:38 am
Thanks guys!
I am using SS 2000...but how could I write this query to be fully compliant in SS 2005?
Thanks!
June 29, 2007 at 8:45 am
Antares686: I receive an "Arithmetic overflow error converting numeric to data type numeric." error when running that query...I assume I need to do another CAST somewhere?
Thanks
May 16, 2007 at 1:44 pm
Viewing 15 posts - 46 through 60 (of 217 total)