|
|
|
January 2003 March 2003 April 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 July 2007 August 2007 September 2007 October 2007 |
Setting error levels Posted by des_crocker NO[at]SPAM harcourt.com at 8/28/2003 2:20:09 AM Dear all,
Is there a way of changing the error level in SQL? I want to insert
records into a table with a primary key, and there will be some
duplicates. Rather than the statement failing with an error when it
encounters a duplicate key, I want to be able to change the error to a
warning and ...more >>
Memory just goes up and up and up... Posted by george d lake at 8/21/2003 3:01:10 PM Hi,
I have SQL 2000 set to use 256MB to 400MB of RAM, but if I go to the
Task Manager (win2K) I can see that sql is using 438MB or RAM and 438MB or
Virtual Memory.
The box was rebooted a few hours ago.
How can I stop the memory getting so high?
Thanks.
...more >>
query problem, #temptable Posted by u489685058 NO[at]SPAM spawnkill.ip-mobilphone.net at 8/21/2003 5:34:34 AM studentID,# of exams, # of passGrades, exam, result
Database is designed to return all above but it prints
the exam and result part only if result < 50.
select studentID,# of exams, # of passGrades, exam,
result
from
A, B, C
where C.result < 50
resulted in nothing to return if there are ...more >>
SQL Query Problem - Possible? Posted by cake NO[at]SPAM lenel.com at 8/20/2003 1:19:28 PM Hi folks. I am by no means an SQL guru but I was hoping someone could
tell if it is possible to answer the following question using the data
below:
What is the maximum datetime for A_DEVICE = 1 and the maximum datetime
for A_DEVICE = 2 for each B_BID?
I would also like the output to look l...more >>
problem Posted by u489685058 NO[at]SPAM spawnkill.ip-mobilphone.net at 8/20/2003 2:05:21 AM it won't quite work.
student exam grade
1 math 90
1 chem 89
1 phys 88
1 his 88
1 Geo 85
2 math 89
2 chem 84
2 phys 83
2 Geo 81
3 Lit 80
3 GYM 79
3 highest:
1 ma...more >>
Sony laptop with AMD processor - Cannot install SQL Posted by meh at 8/19/2003 11:55:11 PM I have above server and I cannot install MS.SQL server on it.
I have WIN-xp professional.
I tried sql 2000 personal version as well as sql 2000 professional version,
it says "cannot install on this operating system "
I would appreciate if someone please help me.
Thanks.
...more >>
Question (need help) Posted by u352142333 NO[at]SPAM spawnkill.ip-mobilphone.net at 8/18/2003 7:26:01 PM Crystal Report/Sql:
Got:
select A,B,C,D,count(*) cnt
from AA,AB,AC,AD
where C.Res <> 0
group by A,B,c,D
order By B
How to modify the above to return only the top 3
count(*) where output looks like?.
B D1 6 D2 5 D3 4
--
Sent by msg_2222 from yahoo part from com
Thi...more >>
Newbie Question(Need Help) Posted by u352142333 NO[at]SPAM spawnkill.ip-mobilphone.net at 8/18/2003 5:44:57 AM StudentID Gender Age
1 Male 12
2 Male 10
3 Femaile 16
4 Male 09
5 Male 14
6 Female 12
7 Female 13
8 Male 14
SQL:
how to return 3 highest age
with its correspon...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
NewBie Question (Request) Posted by u352142333 NO[at]SPAM spawnkill.ip-mobilphone.net at 8/13/2003 8:54:53 PM Could someone give two SQL examples that generate
cr reports like the followings:
(1)
Country City count(City)
A AA 3
A AB 2
A AC 5
B BA 3
B BB 1
(2)
Country City countMin City countMed City countMax
A A...more >>
question with Highest occurrences Posted by u352142333 NO[at]SPAM spawnkill.ip-mobilphone.net at 8/13/2003 5:45:11 AM Have a table:
1 = Good , 2 = mild and 3 = Bad
Country city weather
A AB 1
A CD 2
A EF 3
B AABB 1
And So on.
Need for each country, the 1st and 2nd highest %Good
weather City. sql or crystal report way.
--
Sent by msg_...more >>
Can't Update New Column in Table Posted by jeff_carver NO[at]SPAM hotmail.com at 8/6/2003 11:21:37 AM I added a new column to a table (using Enterprise Manager, logged on
as dbo), but any update I make (either with an update query or by
hand-jamming a value via Enterprise Manager) doesn't "stick" -- no
error message, but the value remains null. I can add an identical
column to any other table i...more >>
How widespread is the use of triggers these days and how concerned about performance?.... Posted by nkannan NO[at]SPAM earthlink.net at 8/1/2003 7:00:47 PM Fifteen years ago when databases were primarily used in the context of
transaction-intensive applications, triggers were a nice feature of a
DBMS system that did not get used because of performance concerns.
Fast forward 15 years, it seems to me that 95% of database usage is
for
non-transacti...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |