You mean Cardinal Moden of the SQL Inquisition? :w00t::w00t::w00t:

Your penance is 10 Hail Mary's and 10 Our Father's.

Go and sin no more.

If you write a stored procedure with parameters, you can right click on the procedure in SMSS and select the Execute Stored Procedure option. You will...

I love this one.

Q: Can I use this syntax in SQL?

A: No

Q: Why not?

Because they didn't write the language to allow it that way.

I'm curious too, so please answer Gail's question.

You can get the number you want by means of a subquery which sums all the previous IDs,...

The nice thing about Lowell's CASE solution is that it could lead you to get away from the CURSOR entirely, which is always a happy thing.

Is your intent to store the resulting concatenated address in the target table or to store the various components? I always prefer storing the components, because it...

The best way I can think of to handle this is with a CASE expression to build the address1 column. Instead of doing this in a stored procedure, you...

Many thanks. 🙂

Flo, I had never heard of that before. How did you come across it?

Seems like it would be a heck of a lot easier to just know your source data, and where it is ultimately going to be stored. There is...

Nope.

You're welcome, and thanks for the feedback. Good luck to you.

Arrrg!!!

Chris, I totally lost track of this. My sincere apologies. I will look hard at it tonight.