Antares, you need a beer. Be happy to buy you one when we get together some day.

Interesting peeves. I too have no love for the RIAA and SCO, but also...

Thanks as well. We've worked hard to build a community. Glad you have found it helpful and looking forward to seeing you help some other people.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL...

Congrats as well. And thanks for the contributions.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

Congrats, personally answering questions is a nice break from work, much better than cigarettes .

Plus I learn a few things from watching randome threads.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of...

I think Andy Warren has some hard copies. Send him an email and he might be able to get you one (awarren@sqlservercentral.com)

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 -...

research, ask specific questions, learn from others.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

charindex is my vote. IN doesn't work with string variables.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

Tools | Customize

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

Good idea, please post it.

I'd prbably attack it by getting the ASCII code and incrementing that, rolling over on Z, but that's me.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002...

OR

If exists( select * from table where val is null)

select 'null'

else

select sum()....

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

Not in Enterprise Manager. You can for the login and if they use QA and the Object Browser, they should get better performance.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002...

Good suggestions above. If it's been working and suddenly doen't, either you have a data problem (most likely) or someone changed the code/schema.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002...

You need to write the trigger as if multiple records exist, so do the check as a join between the "inserted" table and the other table and perform the update...

agreed.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

Paritioning makes sense in some cases. Not sold on it for the main db, but for cases where you can "archive" data, moving some of it makes sense.

For instances, you...