I tend to use a result set, keep things consistent, but no real reason why output parameters don't work. They've confused developers at times, so I stick with what they're...

Sorry, no idea here, but I haven't done that much with UDFs.

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

This is a little vauge. Do you mean an automatic report from the server? Send it to LTP1. There is no facility within the server to print reports. Everything happens...

Reindexing can eat up some space (temporarily) and easily cause the db to grow.

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

Yikes!! Review every one!!

We get like 400 posts a day here. That's a bit much, but you do bring up an interesting point. "Guru" might be not be the best...

Thanks for the complement. Tell your friends!

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

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...