vempralachaitanya (11/9/2008)

---

--Query

update t set t.sno=

(select s.sno from t,s where s.sid=t.sid and t.sno is null)

where t.sno is null and t.sid=s.sid

am getting the following error

--error

Msg 4104, Sevel 16, State 1, Line 1

The...

I assume R.Barry Young was kidding ...

select name from sysobjects o1

where type in ('FN', 'IF', 'TF', 'P')

and ObjectProperty(id, 'IsMSShipped') = 0

and name...

tom.gilmore (11/10/2008)

---

The -Z parameter might work fine if you are an administrator or have rights to change passwords on the SQL Server instance, otherwise I don't think it will help...

The function CombineGroupNames can be dispensed with entirely by defining the view thus:

CREATE View [dbo].[ApplicationResources]

AS

SELECT R.[ResourceName]

,R.[IsEnabled]

,replace(replace(replace( (

...

Several people have complained that changing the text column to varchar(max) is bad because you are changing the data, which is right, so I'd just do the conversion in line..select...

Not every discussion...

SS 2005 doesn't have the '-=' operator, but if you trydeclare @i int

set @i=6

set @i=-+-+-@i

print @i you get -6, so it's consistent with 2K8.

I think the parser is just treating...

David (11/4/2008)

---

Sergiy, amazing! Can you explain how it works though?! In the past I've used ISNULL to simply replace a value if it is null. What I don't understand is...

I spent many years doing research in Nuclear Physics so I'm with Steve (and others) in the "Go Nuclear" camp.

While wind and wave may provide short term 'top-ups' we really...

I knew Express had AUTO_CLOSE on by default, but then went and ticked that and not the others. :hehe:

Must be working too hard! 😀

I checked the references and the New Scientist article refers to the collapse of LTCM in 1998 which nearly caused a global collapse. This is analysed here and here (Wikipedia).

The...

My reading of the history...

Matt Miller (10/14/2008)

---

IBM's revenue is off by a penny, which triggers an alert on someone's system, which tells EVERYONE, and next thing you know, IBM is in the tank, just...

Sorry, Steve, Just stating it isn't doesn't...

GSquared (10/14/2008)

---

As soon as precision excedes accuracy, it's all wasted effort. Useless. But people like to rely on it and make decisions based on it, even if it's...