I do not have much experience in reading SQL transaction errors. My server falls over allmost every time when receiving this event. I do see the memory load is VERY high, but it is not constant on every transaction.Computer type is AT/AT COMPATIBLE. Bios Version is SBR20 v16.00 Current time is 11:07:19 08/06/04. 4 Intel […]
2004-08-13
8 reads
Thanq Tal Mcmahon,very very thankz. This site is very very useful to me. Regards-Gopi
2004-07-28
JP, the HAVING clause has no effect in this query, because the estimateddate is part of the GROUP BY clause (and the MIN function is evaluated for each group and, of course, each group has only one date). I think the query should be written like this:SELECT r.roofid, c1.estimatedcost as CapCost, c1.estimateddate FROM tblcapitalexpenditures c1 INNER JOIN […]
2004-07-25
Given the simplicity of the SQL I would simply duplicate the query on the other side of an IF.I've got something similar in some of my procs, but I have some really convoluted series of parameters.What I found was that trying to write a single SQL statement that encompassed all possibilities resulted in code that […]
2004-07-07
Tell you what... it's a very bad habit that I have to not check BOL sometimes. I remenber when in our shop it was decided not to use compute by if favor of WITH ROLLUP but I stand corrected by Antares686!!! you do get 2 recorsets per group on the output its probably something […]
2004-05-31
HRm, though you're error message doesn't indicate this to be the problem - is the path to the test.xls file relative to the server? For example, if the test.xls resides on a department share and the logged in user has an R: drive mapped to that share, the server doesn't have a mapped R: drive […]
2004-05-26
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-05-21
This has added logic to validate after a friday holiday to move to monday.create function fn_NextTrDate(@TrDate datetime) returns datetime as begin -- knock off the time part. SET @TrDate = dateadd(d,datediff(d,0,@TrDate),0) -- advance to next date (not using datepart because of @@datefirst concerns) set @TrDate = dateadd(dd, case datename(dw, @TrDate) when 'Sunday' then […]
2004-05-17
I am being told that there is no benefit to having a primary key defined, especially a surrogate key of identity if it is not used in joins. We have another table of account information that does have unique rows (key is account_num) however the uniqueness is enforced only by an index that is created […]
2004-03-11
2004-03-11
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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