# Thursday, 24 August 2006

This is just one of those little reminders to self. Self, you never seem to remember how to assign the return value from a stored procedure to a variable in SQL. I try various forms and always seem to miss the right one. So, in an effort to mark it for my future use, I place it here in the blog.

One does NOT accomplish it through any of these methods:

DECLARE @ReturnedValue INT

    SET @ReturnedValue = StoredProcedure @Param1, @Param2

IF( @ReturnedValue = @Something )

BEGIN

    --Do This Stuff

END

 

DECLARE @ReturnedValue INT

    SET @ReturnedValue = StoredProcedure ( @Param1, @Param2 )

IF( @ReturnedValue = @Something )

BEGIN

    --Do This Stuff

END

 

DECLARE @ReturnedValue INT

    SET @ReturnedValue = EXEC StoredProcedure @Param1, @Param2

IF( @ReturnedValue = @Something )

BEGIN

    --Do This Stuff

END

 

DECLARE @ReturnedValue INT

    SET @ReturnedValue = EXEC StoredProcedure ( @Param1, @Param2 )

IF( @ReturnedValue = @Something )

BEGIN

    --Do This Stuff

END

One does by this method:

DECLARE @ReturnedValue INT

EXEC    @ReturnedValue = StoredProcedure @Param1, @Param2

IF( @ReturnedValue = @Something )

BEGIN

    --Do This Stuff

END

I just have to remember the order. I suppose it makes sense when I see it, but I forget when it's time to type it. It's just too easy to get mixed up with Function format.

Thursday, 24 August 2006 17:50:34 (Pacific Daylight Time, UTC-07:00)  #    Comments [0]
# Wednesday, 23 August 2006

We always want to take advantage of Rick Strahl's time in the northwest. He's a fabulous presenter and really knows his stuff when it comes to programming ASP. He'll be heading home to Hawaii next month, so don't miss this opportunity to see him one more time!

WHAT: August PADNUG Meeting
WHEN:

Wednesday 08/30/2006
6:00 p.m. Pizza (by Microsoft)
6:30 p.m. Presentation

WHERE: PCC Auditorium at Capital Center
18640 NW Walker Road
Beaverton, Oregon
The auditorium is in room 1508 through entrance B. There is a $2 parking fee. The kiosk for paying for parking is located between entrances B and C.
WHO:

Rick Strahl
Rick Strahl is president of West Wind Technologies on Maui, Hawaii. The company specializes in Web and distributed application development, training and tools with focus on ASP.NET and .NET in general. Rick is author of West Wind Web Connection, a powerful and widely used Web application framework, West Wind HTML Help Builder and West Wind Web Store and Business Framework for .NET and Visual FoxPro. He also collaborates with Kevin McNeish on the Mere Mortals Framework for .NET. Rick is a Microsoft C# MVP, a frequent contributor to magazines and books and speaks frequently at professional developer conferences all over the world. He is co-publisher and co-editor of CoDe magazine. In the summer months, Rick spends his time in beautiful Hood River, Oregon to play on the river, forests and mountains.

TOPIC:

Taking ATLAS for a ride
This session presents ATLAS, Microsoft's new client side/AJAX extension for ASP.NET slanted for release as an Add-on for ASP.NET 2.0 later this year. ATLAS introduces a rich framework for remote scripting with a wide variety of tools and approaches available to build rich client applications. In this session he'll overview the features available in the framework and show business oriented examples of how to utilize the various features. We'll look at the server centric approach with ATLAS Server controls like UpdatePanel, and a client centric approach relying on core ATLAS network features and the client side ATLAS framework and contrast the two approaches.

Looking forward to seeing you all there!

Wednesday, 23 August 2006 07:58:07 (Pacific Daylight Time, UTC-07:00)  #    Comments [0]
# Wednesday, 02 August 2006

Not surprisingly, with the fabulous, big Code Camp event last month, there wasn't a place for having a Nerd Dinner. Heavens, we had enough food, fun, and geeking out that day to last until the next month!

Well, guess what? The next month has arrived!

We're going to kick it off early this month and finally get back to the West side of town for one. Heck, it's been four months since we visited Washington Square - we can only hope that they have found other business to keep them running while we've been away.

What: Portland Nerd Dinner
Where: Washington Square Food Court (Second Floor; typically, straight out from Picture People)
When: Wednesday, August 9, starting around 6:30 PM
Why: To keep the food court at Washington Square afloat!

Be There and Be Square!

Wednesday, 02 August 2006 00:32:40 (Pacific Daylight Time, UTC-07:00)  #    Comments [1]
# Monday, 24 July 2006

Come out to our July meeting to learn about Amazon Web Services.

WHAT: July PADNUG Meeting
WHEN:

Wednesday 07/26/2006
6:00 p.m. Pizza (by Centerstance)
6:30 p.m. Presentation

WHERE: PCC Auditorium at Capital Center
18640 NW Walker Road
Beaverton, Oregon
The auditorium is in room 1508 through entrance B. There is a $2 parking fee. The kiosk for paying for parking is located between entrances B and C.
WHO:

Mike Culver
Amazon Web Services Evangelist, will provide an overview of Amazon Web Services and show you the possibilities created by these innovative offerings

TOPIC:

Amazon Web Services
Learn how you can create innovation applications and launch online businesses leveraging world-class technology and content platform that powers the Amazon web site for millions of customers everyday.

Looking forward to seeing you all there!

Monday, 24 July 2006 00:27:47 (Pacific Daylight Time, UTC-07:00)  #    Comments [0]
# Tuesday, 18 July 2006

No surprise... I was using some of the Russinovich, et al, tools today to check things on my computer. Heck, on the home machine, I have Process Explorer set up in place of Task Manager.

That Microsoft has acquired the company is exciting news. As Scott mentions in his Ultimate List, "...anything these guys do is pure gold." From the tools to the Big Sony Flap, Mark and his cohorts have given a lot to the computing world.

Tuesday, 18 July 2006 19:02:29 (Pacific Daylight Time, UTC-07:00)  #    Comments [0]
# Wednesday, 05 July 2006

So yesterday was the Fourth of July. Oregon doesn't allow very interesting fireworks... as I recall, nothing that goes up in the air and can only move around on the ground in a limited space.

Of course, many people will take a trip out-of-state to get a few more interesting devices. Having a more firework friendly state like Washington next door can certainly contribute to that.

But now, I must say that these devices just don't carry much thrill. It's like they are all just sparklers and snakes to me after this year's celebration. Why?

We got to participate in a full-size fireworks show!

Greg Hughes has been doing these shows for several years. When talk of this event came around last year, I made a note to myself to watch for Greg's call for volunteers this year. When it came, Jesann and I hurried to speak up.

This show happens up in Clatskanie, Oregon and we set up the display right next to the local treatment plant. Not the nicest place to hang out, but the wind was generally in our favor.

All told, there were nearly 400 shells to fire off. Nearly one-third of them were five-inch with the rest being four-inch. These things are big. Most of the day is spent burying the mortars and placing the shells into them.

After loading them all up, we took some time for a bit of a break. Time to go grab a bite to eat and change clothes as Jesann and I wore shorts through the day and needed to put something a bit safer (and warmer) on for the evening.

Throughout the day, Greg was providing safety tips and double checking to see who really wanted to participate in lighting the shells off. I knew that I wanted to, but Jesann was  little bit apprehensive about such activity.

The show started at just about ten o'clock sharp. There were seven of us lighting and Greg rotated us in.

Once it began, it was a constant bombardment. The force that the explosions carry is amazing. Those of us who weren't currently lighting stood back about twenty to thirty feet and you could feel it quite well from there. I was the last 'newbie' to light, but that had the absolutely thrilling advantage of putting me on a long section of five inch shells.

And I thought the compression from twenty feet was noticeable. Try being right next to these things!

It is amazing how much excitement there is to having these mortars exploding less than a foot from your head.

At the beginning of the lighting, I did manage to look up and see some of the shells explode in the sky above. I soon realized, though, that I had seen that plenty of times in my life. The lighting and launching, though, was brand new.

Having spent the better part of eight hours getting the show set up, it was all blown to heck in less than half of an hour. And yes, it was very well worth it.

Greg has more details posted on his blog at the following locations:

What can I say? I'm hooked! Normal fireworks just don't carry the thrill for me anymore :).

Wednesday, 05 July 2006 08:42:40 (Pacific Daylight Time, UTC-07:00)  #    Comments [0]
# Friday, 23 June 2006

A group from work went to have lunch at the Merchant of Venice Cafe today and had an absolutely horrible time of it. I guess the quickest way to go is to bullet the problems...

  • Smallish circular table for seven big guys... and no, they can't push two other tables together for us despite having done so for an other group despite the specific request to do so.
  • "Sorry... not enough menus so you'll have to share." Three menus for seven people and one 'Specials' sheet. First, there was hardly anyone in the place yet. Second, why don't you have enough for everyone?
  • Small glass of lemonade of which they ran out... and still charged the full two dollar price!
  • Three of us ordered small pizzas. Mine was different. They brought out three of the same.
  • The waiter actually came back w/ the wrong pizza and asked, "wouldn't you like the same pizza as your friends?" You've got to be kidding!
  • The remake of the pizza took so long, I finally told him that we needed to go and to forget it. It was still on the bill.
  • It took so long for the bill to arrive that the pizza finished. He offered to pack it and not charge; even though it had already been charged.
  • Got the togo... it was burnt, not as-ordered, and packed in a box half the size needed.

I've been to this store once before and it was fine. This time convinced me to never go again. The fact that everything went wrong is forgivable if they take the time and effort to make it up to you. They just didn't seem to care.

Friday, 23 June 2006 14:53:29 (Pacific Daylight Time, UTC-07:00)  #    Comments [0]

Come out to our June meeting to learn source control best practices.

WHAT: June PADNUG Meeting
WHEN:

Wednesday 06/28/2006
6:00 p.m. Pizza (by InfoGroup NorthWest)
6:30 p.m. Presentation

WHERE: PCC Auditorium at Capital Center
18640 NW Walker Road
Beaverton, Oregon
The auditorium is in room 1508 through entrance B. There is a $2 parking fee. The kiosk for paying for parking is located between entrances B and C.
WHO:

Patrick Cauldwell
After completing a Bachelor's degree in the unlikely field of East Asian Studies, Patrick Cauldwell fell into the software industry. Since then he has written tools that helped Intel localize software into 17 languages; architected large E-Commerce web sites like 800.com and gear.com while at STEP Technology, and spoken nationwide about how to build large scalable applications. Patrick is currently an architect/developer at Corillian Corporation, where he designs and develops software for online banking.

TOPIC:

Making Good Use of Source Control
We’ll discuss source control best practices, and how those practices apply to some common SCC packages. The emphasis will be on practices and procedures, not the mechanics of a particular SCC solution. Specific attention will go to how source control fits into an agile development process and continuous integration.

Looking forward to seeing you all there!

Friday, 23 June 2006 00:06:35 (Pacific Daylight Time, UTC-07:00)  #    Comments [0]
# Wednesday, 14 June 2006

Let's have a Nerd Dinner!

What perfect timing: Next week there's this little MSDN Event. It's on Tuesday. It's across the street from the Lloyd Center. Doesn't this sound like a great reason to get a bunch of nerds together?

What: Portland Nerd Dinner
Where: Lloyd Center Food Court (Third Floor; typically, straight out from Billy Heartbeats - 2039)
When: Tuesday, June 20, starting around 6:30 PM
Why: We're Going to Be There Anyway!

Be There and Be Square!

Wednesday, 14 June 2006 23:14:26 (Pacific Daylight Time, UTC-07:00)  #    Comments [0]
# Friday, 02 June 2006

Via Travis at Parasthesia:

Your results:
You are Will Riker

Will Riker
65%
James T. Kirk (Captain)
60%
Worf
60%
Geordi LaForge
55%
Chekov
50%
Jean-Luc Picard
50%
Spock
47%
Mr. Scott
45%
Uhura
40%
Data
40%
Leonard McCoy (Bones)
35%
Deanna Troi
35%
An Expendable Character (Redshirt)
35%
Beverly Crusher
30%
Mr. Sulu
15%
At times you are self-centered
but you have many friends.
You love many women, but the right
woman could get you to settle down.
Click here to take the Star Trek Personality Quiz
Friday, 02 June 2006 22:07:26 (Pacific Daylight Time, UTC-07:00)  #    Comments [0]
# Saturday, 27 May 2006

Come out to this month's meeting to learn tricks to building a reusable ASP.NET toolbox. Mark your calendar and come join the fun.

WHAT: May PADNUG Meeting
WHEN:

Wednesday 05/31/2006
6:00 p.m. Pizza
6:30 p.m. Presentation

WHERE: PCC Auditorium at Capital Center
18640 NW Walker Road
Beaverton, Oregon
The auditorium is in room 1508 through entrance B. There is a $2 parking fee. The kiosk for paying for parking is located between entrances B and C.
WHO:

Rick Strahl
Rick Strahl is president of West Wind Technologies on Maui, Hawaii. The company specializes in Web and distributed application development, training and tools with focus on ASP.NET and .NET in general. Rick is author of West Wind Web Connection, a powerful and widely used Web application framework, West Wind HTML Help Builder and West Wind Web Store and Business Framework for .NET and Visual FoxPro. He also collaborates with Kevin McNeish on the Mere Mortals Framework for .NET. Rick is a Microsoft C# MVP, a frequent contributor to magazines and books and speaks frequently at professional developer conferences all over the world. He is co-publisher and co-editor of CoDe magazine. In the summer months, Rick spends his time in beautiful Hood River, Oregon to play on the river, forests and mountains.

TOPIC:

Building a reusable ASP.NET Toolbox
This session demonstrates some re-usable tools, classes and components that every Web Application should integrate. Every application needs a core set of features, like managing configuration settings, handling and reporting errors consistently, logging requests, providing application status information, displaying consistent error and information message pages, managing application cookies consistently and more. In this session I'll demonstrate a handful of useful utility classes and processes that accomplish these tasks in a reusable fashion and show how they work under the covers.

Looking forward to seeing you all there!

Saturday, 27 May 2006 14:22:13 (Pacific Daylight Time, UTC-07:00)  #    Comments [0]
# Tuesday, 23 May 2006

This is a question asked of Google that led to my blog today. Of course, I haven't blogged on such a thing, but I figure what the heck? Let's do it!

For the next person that searches for such an item, the opposite of SELECT TOP is also SELECT TOP. Huh? You simply change the ORDER BY clause to be descending. For example, if you have a query such as:

SELECT TOP 10 FirstName, LastName, BirthDate

  FROM Persons

 ORDER BY LastName, FirstName

then the opposite would be:

SELECT TOP 10 FirstName, LastName, BirthDate

  FROM Persons

 ORDER BY LastName DESC, FirstName DESC

Simple, huh?

You may be asking, "What if I don't care about the order?" Then I have to say that you don't really care about TOP versus BOTTOM, either as you are going to get a random (as far as we know) set of rows in either case.

Tuesday, 23 May 2006 00:04:28 (Pacific Daylight Time, UTC-07:00)  #    Comments [3]
# Monday, 22 May 2006

It's coming this weekend! X-Men: The Last Stand is released as of Friday and we're going to celebrate immediately.

If you would like to Fandango, click <<here>>.

What: Portland Nerd Dinner Movie
WhereCentury 16 Cedar Hills Crossing (Cedar Hills Crossing used to be Beaverton Mall)
When: Friday, May 26, 5:20 PM (Get there early if you can! It's opening night!)
Why: 'Cuz it's the coolest movie this year!

Be There and Be Square!

Monday, 22 May 2006 16:10:02 (Pacific Daylight Time, UTC-07:00)  #    Comments [0]
# Wednesday, 10 May 2006

I finally got the Microsoft Ergonomic Keyboard 4000 (sheesh! what a mouthful) and I do love it. So much so that I bought a second one for the office.

One thing I keep wishing with the MS keyboards, though, is to trade in the 'zoom' button for a scroll like the what you get with the mice. The customization software just doesn't offer such a feature. Well, of course, someone has found a way to 'hack' it.

Andy Atkinson has an article showing how to make such changes. The only addendum I would provide is that with my drivers, the file to run is "itype.exe" instead of "type32.exe"

Very handy... heck, what else can I change in here....

Wednesday, 10 May 2006 08:26:11 (Pacific Daylight Time, UTC-07:00)  #    Comments [2]
# Tuesday, 25 April 2006

Come out to this months meeting to hear all about Developing on Windows Mobile.

WHAT: April PADNUG Meeting
WHEN:

Wednesday 04/26/2006
6:00 p.m. Pizza, Sponsored by 3Leaf
6:30 p.m. Presentation

WHERE: PCC Auditorium at Capital Center
18640 NW Walker Road
Beaverton, Oregon
The auditorium is in room 1508 through entrance B. There is a $2 parking fee. The kiosk for paying for parking is located between entrances B and C.
WHO:

Rory Blyth
Rory is an author, former co-host of the .NET Rocks Internet talk show. He has experience with many different platforms and languages, but his passion lies in using and helping people with .NET technologies.

TOPIC:

Developing on Windows Mobile
A Presentation on Developing on Windows Mobile.

Looking forward to seeing you all there!

Tuesday, 25 April 2006 22:59:07 (Pacific Daylight Time, UTC-07:00)  #    Comments [0]
# Wednesday, 19 April 2006

It's that time again! Nerd Dinner!

Can you believe the great weather we're having this April?!? Let's celebrate the coming of this wonderful spring by getting together for some crappy mall food out Lloyd Center way...

What: Portland Nerd Dinner
Where: Lloyd Center Food Court (Third Floor; typically, straight out from Billy Heartbeats - 2039)
When: Tuesday, April 25, starting around 6:30 PM
Why: Look Folks! It's Spring!

Be There and Be Square!

Wednesday, 19 April 2006 23:07:32 (Pacific Daylight Time, UTC-07:00)  #    Comments [0]