Seems to me a series of procs called by a master proc would be better as that way if/when the data changes, you only have to add a new proc...

Concatenation can be handy if you're pulling from a spreadsheet. I've had to do that with small data sets. Just a =Concatenate("Select '", A1, "', '", B1, "'...

Neat article and nicely written. I'm new to SQL but it's great to have this reference on how to change that procedural thought into a set thought.

By the way,...

This question was worded improperly. Per this article which compares what SQL Express can and cannot do SQL Server Express Features, Resporting Services is not supported by SQL Server...

It's all Al Gore's fault. Damn global warming!

Wonder if Al Gore is part of the Thread's plot to take over the world?

heh. There are times when I wish the longest domestic flight was that short in the US. Went up from Florida to Washington State to visit relatives over...

I dunno, perhaps the fine application...

You really need to only post on the forum that applies. If you're using SQL 2005, please only post on the 2005 forums.

You won't be "missing" any...

Yeah, could be. From what I saw last night, that blizzard was a nasty one. My sympathies to the people up in ND with their flooding. Not...

:-D:-D:-D:-D:-D:-D

Activity on the Thread seems to have diminished. Should I be worried? Is THE THREAD executing its plan to take over the world and that's why no new...

GSquared (3/26/2009)

---

You could put the level range and level step in the join table.

Thus, if the recipe goes from level 10 to level 25, but only has 10, 15, 20,...

Hi Jack,

Well, my first question is whether or not it is a no-no to have a table joining three tables. I know if you want the one-to-many or many-to-many...

Cool. Thanks. 🙂

Guess I'm starting to understand this BOL thingie.

I added the column and dropped the inserted column and it worked just fine. Got the same identity...

Yeah, I have to agree with Bob. I'm new to SQL and CR's help didn't make much sense to me. Had it been me getting that, I would...

Chris Morris (3/24/2009)

---

Nope, I'm an only child, and they wouldn't let me...