I Just Realized I Never Mentioned...

Thread Rating:

0 Vote(s) - 0 Average
1
2
3
4
5

Linear Mode

I Just Realized I Never Mentioned...

Bob Schroeck Offline

Chief Screwball and Head Loon Wrangler

Posts: 27,671
Threads: 2,278
Joined: Sep 2002
Reputation: 21

#146

03-27-2010, 03:24 PM

Thanks, Spud. Yes, I feel a lot better about it after reading that. I did briefly investigate table variables via the help; but they're something well beyond any SQL I'd ever done before, and given that I was under a time constraint I didn't feel I could afford to experiment. And I looked at the CASE statement, but it seems to be used only for multiple-choice operations inside a SELECT.
-- Bob
---------
Then the horns kicked in...
...and my shoes began to squeak.

Website Find

« Next Oldest | Next Newest »

Messages In This Thread

I Just Realized I Never Mentioned... - by Bob Schroeck - 01-29-2010, 06:42 AM

[No subject] - by Jeanne Hedge - 01-29-2010, 06:54 AM

[No subject] - by Foxboy - 01-29-2010, 06:58 AM

[No subject] - by Bob Schroeck - 01-29-2010, 07:00 AM

[No subject] - by David Lewis - 01-29-2010, 05:46 PM

Good Luck - by Rev Dark - 01-29-2010, 06:01 PM

[No subject] - by Logan Darklighter - 01-29-2010, 06:22 PM

[No subject] - by Wiregeek - 01-29-2010, 08:34 PM

[No subject] - by Norgarth - 01-29-2010, 08:58 PM

[No subject] - by Bob Schroeck - 01-29-2010, 11:18 PM

[No subject] - by Foxboy - 01-30-2010, 12:51 AM

[No subject] - by ECSNorway - 02-03-2010, 07:19 AM

[No subject] - by Bob Schroeck - 02-03-2010, 08:59 AM

[No subject] - by Bob Schroeck - 02-03-2010, 10:06 PM

[No subject] - by Kurisu - 02-04-2010, 02:16 AM

[No subject] - by Bob Schroeck - 02-04-2010, 04:26 AM

[No subject] - by Bob Schroeck - 02-10-2010, 11:13 PM

[No subject] - by Bob Schroeck - 02-11-2010, 06:31 PM

[No subject] - by robkelk - 02-12-2010, 02:28 AM

[No subject] - by Bob Schroeck - 02-12-2010, 04:38 AM

[No subject] - by ordnance11 - 02-12-2010, 09:03 PM

[No subject] - by Bob Schroeck - 02-13-2010, 04:33 AM

[No subject] - by Black Aeronaut - 02-15-2010, 05:59 PM

[No subject] - by Bob Schroeck - 02-16-2010, 10:03 PM

[No subject] - by robkelk - 02-17-2010, 03:09 AM

[No subject] - by Bob Schroeck - 02-17-2010, 05:39 AM

[No subject] - by Bluemage - 02-17-2010, 06:29 AM

[No subject] - by ordnance11 - 02-17-2010, 08:05 AM

[No subject] - by Bob Schroeck - 02-17-2010, 04:53 PM

[No subject] - by ordnance11 - 02-17-2010, 05:05 PM

[No subject] - by ordnance11 - 02-17-2010, 05:07 PM

[No subject] - by robkelk - 02-18-2010, 05:33 AM

[No subject] - by ordnance11 - 02-18-2010, 08:06 AM

[No subject] - by Black Aeronaut - 02-18-2010, 04:32 PM

[No subject] - by Bob Schroeck - 02-18-2010, 04:54 PM

[No subject] - by ordnance11 - 02-18-2010, 05:30 PM

[No subject] - by Black Aeronaut - 02-18-2010, 05:30 PM

[No subject] - by Bob Schroeck - 02-18-2010, 06:08 PM

[No subject] - by ECSNorway - 02-18-2010, 07:37 PM

[No subject] - by ordnance11 - 02-19-2010, 02:19 AM

[No subject] - by ordnance11 - 02-20-2010, 01:33 AM

[No subject] - by Black Aeronaut - 02-20-2010, 09:26 AM

[No subject] - by ordnance11 - 02-24-2010, 11:19 AM

Wow, that was fast! - by Bob Schroeck - 02-24-2010, 08:21 PM

[No subject] - by Bob Schroeck - 02-24-2010, 08:34 PM

[No subject] - by ordnance11 - 02-25-2010, 02:57 AM

[No subject] - by robkelk - 02-25-2010, 03:36 AM

[No subject] - by Foxboy - 02-25-2010, 05:04 AM

[No subject] - by Bob Schroeck - 02-25-2010, 07:13 PM

[No subject] - by ordnance11 - 02-26-2010, 06:21 AM

[No subject] - by ordnance11 - 02-27-2010, 11:34 PM

[No subject] - by ordnance11 - 03-01-2010, 02:39 AM

[No subject] - by Bob Schroeck - 03-01-2010, 02:34 PM

[No subject] - by robkelk - 03-01-2010, 04:40 PM

[No subject] - by Bob Schroeck - 03-01-2010, 05:02 PM

[No subject] - by Kurisu - 03-01-2010, 11:58 PM

[No subject] - by Bob Schroeck - 03-02-2010, 07:09 AM

[No subject] - by ordnance11 - 03-02-2010, 07:20 AM

[No subject] - by Bob Schroeck - 03-02-2010, 04:36 PM

[No subject] - by ordnance11 - 03-02-2010, 05:51 PM

[No subject] - by Bob Schroeck - 03-02-2010, 09:43 PM

[No subject] - by robkelk - 03-03-2010, 03:20 AM

[No subject] - by Bob Schroeck - 03-03-2010, 05:12 AM

[No subject] - by ordnance11 - 03-05-2010, 02:51 AM

Impossible Requirements, A Continuing Series - by Bob Schroeck - 03-05-2010, 06:50 PM

[No subject] - by Bluemage - 03-06-2010, 01:40 AM

[No subject] - by Jinx999 - 03-06-2010, 01:50 AM

[No subject] - by robkelk - 03-06-2010, 02:29 AM

[No subject] - by Bob Schroeck - 03-06-2010, 03:21 AM

[No subject] - by sweno - 03-06-2010, 05:35 AM

[No subject] - by HoagieOfDoom - 03-06-2010, 07:06 AM

[No subject] - by Black Aeronaut - 03-06-2010, 05:23 PM

[No subject] - by ordnance11 - 03-06-2010, 10:11 PM

[No subject] - by ECSNorway - 03-07-2010, 04:57 AM

Holy Cow. - by Bob Schroeck - 03-08-2010, 08:15 PM

[No subject] - by ordnance11 - 03-09-2010, 01:47 AM

[No subject] - by ordnance11 - 03-10-2010, 04:27 AM

[No subject] - by Jeanne Hedge - 03-10-2010, 06:22 AM

[No subject] - by Black Aeronaut - 03-10-2010, 06:37 AM

[No subject] - by ordnance11 - 03-10-2010, 07:31 AM

[No subject] - by Bob Schroeck - 03-10-2010, 04:35 PM

[No subject] - by Bob Schroeck - 03-10-2010, 09:32 PM

[No subject] - by ordnance11 - 03-10-2010, 09:55 PM

[No subject] - by ordnance11 - 03-10-2010, 09:57 PM

[No subject] - by Kurisu - 03-11-2010, 04:30 AM

[No subject] - by ordnance11 - 03-11-2010, 07:46 AM

[No subject] - by ordnance11 - 03-12-2010, 04:51 AM

[No subject] - by Sofaspud - 03-12-2010, 07:52 AM

[No subject] - by ECSNorway - 03-12-2010, 04:35 PM

[No subject] - by Bob Schroeck - 03-12-2010, 05:02 PM

[No subject] - by Bob Schroeck - 03-12-2010, 05:13 PM

[No subject] - by Black Aeronaut - 03-12-2010, 05:18 PM

[No subject] - by ordnance11 - 03-12-2010, 10:26 PM

[No subject] - by Black Aeronaut - 03-12-2010, 10:38 PM

[No subject] - by Bob Schroeck - 03-12-2010, 11:08 PM

[No subject] - by ordnance11 - 03-13-2010, 12:01 AM

[No subject] - by Bob Schroeck - 03-13-2010, 12:56 AM

[No subject] - by ordnance11 - 03-13-2010, 01:48 AM

[No subject] - by robkelk - 03-13-2010, 03:27 AM

[No subject] - by ordnance11 - 03-13-2010, 05:55 AM

[No subject] - by Sofaspud - 03-13-2010, 06:21 AM

[No subject] - by Bob Schroeck - 03-13-2010, 06:06 PM

Good news and bad news - by ordnance11 - 03-16-2010, 02:38 AM

[No subject] - by robkelk - 03-16-2010, 02:39 AM

[No subject] - by Bob Schroeck - 03-16-2010, 02:54 AM

[No subject] - by Sofaspud - 03-16-2010, 02:58 AM

[No subject] - by Bob Schroeck - 03-16-2010, 11:41 PM

[No subject] - by ordnance11 - 03-17-2010, 12:08 AM

[No subject] - by Sofaspud - 03-17-2010, 01:21 AM

[No subject] - by robkelk - 03-17-2010, 02:00 AM

[No subject] - by Bob Schroeck - 03-17-2010, 02:10 AM

[No subject] - by ordnance11 - 03-17-2010, 08:11 AM

[No subject] - by ordnance11 - 03-19-2010, 05:32 AM

[No subject] - by robkelk - 03-19-2010, 05:35 AM

Missed it by that much! aka the fix is in - by ordnance11 - 03-20-2010, 01:31 AM

[No subject] - by Bob Schroeck - 03-20-2010, 04:28 AM

Why am I doing this again? - by ordnance11 - 03-21-2010, 03:39 AM

[No subject] - by robkelk - 03-22-2010, 02:03 PM

[No subject] - by Bob Schroeck - 03-22-2010, 04:39 PM

I'm having one of those days. - by Bob Schroeck - 03-22-2010, 04:55 PM

[No subject] - by Bob Schroeck - 03-22-2010, 05:30 PM

Job Hunting analogy - by ordnance11 - 03-22-2010, 11:56 PM

[No subject] - by Jeanne Hedge - 03-23-2010, 03:06 AM

Talk about side tracked - by ordnance11 - 03-23-2010, 08:40 PM

[No subject] - by Bob Schroeck - 03-23-2010, 09:12 PM

[No subject] - by robkelk - 03-24-2010, 01:46 AM

[No subject] - by ordnance11 - 03-24-2010, 02:23 AM

[No subject] - by Bob Schroeck - 03-24-2010, 03:19 AM

Today's The Day For Bad Spelling... - by Bob Schroeck - 03-24-2010, 05:20 PM

[No subject] - by jpub - 03-24-2010, 06:45 PM

[No subject] - by Bob Schroeck - 03-24-2010, 07:38 PM

[No subject] - by robkelk - 03-25-2010, 01:34 AM

[No subject] - by jpub - 03-25-2010, 01:57 AM

Talk about serendipity - by ordnance11 - 03-25-2010, 03:07 AM

Good news and bad news - by ordnance11 - 03-25-2010, 11:23 PM

[No subject] - by Bob Schroeck - 03-26-2010, 01:12 AM

Everytime I Start To Fill Depressed... - by ordnance11 - 03-26-2010, 03:12 AM

Note to self - by ordnance11 - 03-26-2010, 11:28 PM

[No subject] - by Bob Schroeck - 03-26-2010, 11:42 PM

[No subject] - by The Wanderer - 03-27-2010, 12:33 AM

[No subject] - by ordnance11 - 03-27-2010, 03:21 AM

[No subject] - by Bob Schroeck - 03-27-2010, 03:44 AM

[No subject] - by ordnance11 - 03-27-2010, 03:54 AM

[No subject] - by Bob Schroeck - 03-27-2010, 04:06 AM

[No subject] - by Sofaspud - 03-27-2010, 07:53 AM

[No subject] - by Bob Schroeck - 03-27-2010, 03:24 PM

[No subject] - by Sofaspud - 03-27-2010, 10:41 PM

[No subject] - by Bob Schroeck - 03-28-2010, 04:42 AM

[No subject] - by The Wanderer - 03-28-2010, 04:47 AM

[No subject] - by Bob Schroeck - 03-29-2010, 06:31 PM

My first interview of the year-Serendipity strikes! - by ordnance11 - 03-30-2010, 03:36 AM

[No subject] - by robkelk - 03-30-2010, 03:43 AM

[No subject] - by ordnance11 - 03-30-2010, 03:57 AM

[No subject] - by Bob Schroeck - 03-30-2010, 04:57 AM

fly in the ointment - by ordnance11 - 03-30-2010, 07:17 PM

[No subject] - by Bob Schroeck - 03-31-2010, 12:34 PM

[No subject] - by Jinx999 - 03-31-2010, 12:40 PM

[No subject] - by The Wanderer - 03-31-2010, 03:23 PM

[No subject] - by Jeanne Hedge - 03-31-2010, 05:38 PM

Well? - by ordnance11 - 04-01-2010, 01:17 AM

[No subject] - by Bob Schroeck - 04-01-2010, 04:03 AM

[No subject] - by Bob Schroeck - 04-01-2010, 02:53 PM

[No subject] - by Jeanne Hedge - 04-02-2010, 12:22 AM

[No subject] - by Bob Schroeck - 04-02-2010, 04:19 AM

[No subject] - by ordnance11 - 04-02-2010, 03:36 PM

[No subject] - by Bob Schroeck - 04-02-2010, 07:48 PM

How true! - by ordnance11 - 04-03-2010, 02:28 AM

[No subject] - by Bob Schroeck - 04-03-2010, 02:32 AM

Make it one more - by ordnance11 - 04-05-2010, 12:23 AM

Goofy Job Requirements, Latest In A Series - by Bob Schroeck - 04-05-2010, 05:08 PM

[No subject] - by robkelk - 04-05-2010, 05:15 PM

[No subject] - by Bob Schroeck - 04-05-2010, 05:37 PM

[No subject] - by Jinx999 - 04-05-2010, 05:58 PM

[No subject] - by Bob Schroeck - 04-05-2010, 07:34 PM

[No subject] - by ordnance11 - 04-06-2010, 03:33 AM

[No subject] - by Bob Schroeck - 04-06-2010, 04:14 AM

[No subject] - by ordnance11 - 04-06-2010, 05:21 AM

[No subject] - by Bob Schroeck - 04-06-2010, 06:49 PM

[No subject] - by CattyNebulart - 04-07-2010, 01:31 AM

Pia Fidelis - by ordnance11 - 04-07-2010, 03:43 AM

Now we wait..Aaaargh! - by ordnance11 - 04-10-2010, 12:06 AM

[No subject] - by Bob Schroeck - 04-10-2010, 12:58 AM

Okay, I'll bite - by ordnance11 - 04-10-2010, 03:14 AM

[No subject] - by robkelk - 04-10-2010, 03:25 AM

[No subject] - by Bob Schroeck - 04-10-2010, 05:08 AM

[No subject] - by robkelk - 04-10-2010, 02:56 PM

[No subject] - by Bob Schroeck - 04-10-2010, 05:08 PM

Just got another bite. - by ordnance11 - 04-14-2010, 06:15 PM

[No subject] - by Bob Schroeck - 04-14-2010, 06:59 PM

[No subject] - by ECSNorway - 04-14-2010, 07:26 PM

[No subject] - by ordnance11 - 04-14-2010, 10:02 PM

All hope is not lost - by ordnance11 - 04-14-2010, 10:05 PM

[No subject] - by Bob Schroeck - 04-14-2010, 11:25 PM

Cool! - by ordnance11 - 04-16-2010, 11:50 PM

[No subject] - by Bob Schroeck - 04-17-2010, 12:03 AM

[No subject] - by ordnance11 - 04-17-2010, 03:02 AM

[No subject] - by Kurisu - 04-17-2010, 06:28 AM

[No subject] - by Jeanne Hedge - 04-17-2010, 05:28 PM

More good news - by ordnance11 - 04-18-2010, 06:56 PM

Now up to 7 - by ordnance11 - 04-21-2010, 12:54 AM

[No subject] - by Bob Schroeck - 04-21-2010, 03:31 AM

[No subject] - by ordnance11 - 04-21-2010, 04:41 AM

[No subject] - by Bob Schroeck - 04-21-2010, 03:23 PM

[No subject] - by Jorlem - 04-21-2010, 03:26 PM

On to 8! - by ordnance11 - 04-22-2010, 11:20 PM

[No subject] - by Bob Schroeck - 04-23-2010, 02:41 PM

[No subject] - by Bob Schroeck - 04-23-2010, 02:45 PM

[No subject] - by ordnance11 - 04-23-2010, 05:13 PM

[No subject] - by Bob Schroeck - 04-23-2010, 10:40 PM

[No subject] - by ordnance11 - 04-23-2010, 11:46 PM

[No subject] - by Kurisu - 04-24-2010, 07:43 AM

Ok I was wrong... - by ordnance11 - 04-25-2010, 08:04 AM

[No subject] - by Bob Schroeck - 04-25-2010, 06:16 PM

[No subject] - by robkelk - 04-25-2010, 10:34 PM

[No subject] - by Bob Schroeck - 04-26-2010, 12:43 AM

[No subject] - by Black Aeronaut - 04-26-2010, 11:34 AM

Today's Job Hunt Pet Peeve - by Bob Schroeck - 04-26-2010, 04:33 PM

Nein! Nein! Oops, wrong word! - by ordnance11 - 04-27-2010, 05:36 PM

Well I'll be.... - by ordnance11 - 04-29-2010, 12:37 AM

[No subject] - by Bob Schroeck - 04-29-2010, 03:11 AM

[No subject] - by ordnance11 - 04-29-2010, 05:31 AM

*Scratches head* - by ordnance11 - 04-29-2010, 11:45 PM

[No subject] - by Bob Schroeck - 04-30-2010, 02:31 PM

[No subject] - by ordnance11 - 04-30-2010, 03:28 PM

[No subject] - by Kurisu - 04-30-2010, 04:18 PM

[No subject] - by ordnance11 - 05-01-2010, 02:53 AM

[No subject] - by Bob Schroeck - 05-01-2010, 03:30 AM

Level 2 Clear - by ordnance11 - 05-04-2010, 05:10 AM

[No subject] - by Bob Schroeck - 05-04-2010, 05:38 AM

[No subject] - by Bob Schroeck - 05-04-2010, 07:22 PM

[No subject] - by ECSNorway - 05-04-2010, 08:25 PM

Status so far - by ordnance11 - 05-04-2010, 11:57 PM

One job search peeve.. - by ordnance11 - 05-05-2010, 11:51 PM

[No subject] - by jpub - 05-06-2010, 04:30 PM

[No subject] - by ordnance11 - 05-07-2010, 03:54 PM

[No subject] - by robkelk - 05-07-2010, 04:16 PM

[No subject] - by Bob Schroeck - 05-08-2010, 12:14 AM

Stay on target!....Stay on Target! - by ordnance11 - 05-08-2010, 04:02 AM

And I've been interviewing like a dog - by ordnance11 - 05-11-2010, 04:53 AM

On to number 3 - by ordnance11 - 05-11-2010, 08:50 PM

[No subject] - by ordnance11 - 05-11-2010, 10:23 PM

We're on a roll! - by ordnance11 - 05-12-2010, 11:09 PM

[No subject] - by Bob Schroeck - 05-13-2010, 01:12 AM

[No subject] - by ordnance11 - 05-13-2010, 01:49 AM

[No subject] - by Bob Schroeck - 05-13-2010, 08:12 PM

[No subject] - by ordnance11 - 05-13-2010, 08:59 PM

looking at the metrics - by ordnance11 - 05-14-2010, 11:35 PM

Okay..now I Really have all the services covered - by ordnance11 - 05-17-2010, 10:13 PM

[No subject] - by ordnance11 - 05-19-2010, 05:53 AM

[No subject] - by Bob Schroeck - 05-19-2010, 03:38 PM

[No subject] - by ordnance11 - 05-19-2010, 08:11 PM

[No subject] - by ordnance11 - 05-20-2010, 01:19 AM

[No subject] - by Black Aeronaut - 05-20-2010, 03:10 AM

Firing horror stories - by ordnance11 - 05-20-2010, 06:33 AM

[No subject] - by Bob Schroeck - 05-20-2010, 02:41 PM

[No subject] - by Black Aeronaut - 05-20-2010, 06:24 PM

[No subject] - by Bob Schroeck - 05-20-2010, 06:54 PM

[No subject] - by LynnInDenver - 05-21-2010, 03:43 AM

At least the cost of living will be cheap - by ordnance11 - 05-21-2010, 07:07 PM

Dare I hope? - by ordnance11 - 05-26-2010, 12:06 AM

[No subject] - by robkelk - 05-26-2010, 12:10 AM

Lesson fromn Star Wars - by ordnance11 - 05-26-2010, 12:57 AM

See what happens when you stay on target? - by ordnance11 - 05-27-2010, 01:16 AM

[No subject] - by ordnance11 - 05-29-2010, 04:32 AM

Well, at least I made an impression - by ordnance11 - 06-02-2010, 08:07 PM

[No subject] - by Bob Schroeck - 06-02-2010, 08:32 PM

[No subject] - by ordnance11 - 06-03-2010, 01:34 AM

[No subject] - by ordnance11 - 06-03-2010, 03:46 PM

[No subject] - by Bob Schroeck - 06-03-2010, 06:30 PM

Ask and ye shall receive! - by ordnance11 - 06-03-2010, 10:24 PM

[No subject] - by Bob Schroeck - 06-04-2010, 05:42 PM

[No subject] - by ordnance11 - 06-05-2010, 07:12 AM

[No subject] - by ordnance11 - 06-07-2010, 09:56 PM

[No subject] - by ordnance11 - 06-08-2010, 04:33 PM

Interesting article on the federal job process - by ordnance11 - 06-09-2010, 12:32 AM

[No subject] - by ordnance11 - 06-09-2010, 04:18 PM

[No subject] - by Bob Schroeck - 06-09-2010, 07:38 PM

[No subject] - by ordnance11 - 06-09-2010, 07:47 PM

Ah crud... - by ordnance11 - 06-11-2010, 06:55 AM

[No subject] - by ordnance11 - 06-11-2010, 07:32 PM

[No subject] - by Bob Schroeck - 06-12-2010, 02:14 AM

[No subject] - by ordnance11 - 06-12-2010, 02:55 AM

[No subject] - by Bob Schroeck - 06-12-2010, 03:30 PM

[No subject] - by ordnance11 - 06-14-2010, 10:02 PM

What's even more worse? - by ordnance11 - 06-15-2010, 06:16 PM

[No subject] - by robkelk - 06-16-2010, 12:55 AM

Dare I hope part 2 - by ordnance11 - 06-17-2010, 10:22 PM

[No subject] - by ordnance11 - 06-18-2010, 06:09 PM

So... they're hiring at the Bazaar? - by Bob Schroeck - 06-21-2010, 05:01 PM

So if two is coincidence, the 3 would be? - by ordnance11 - 06-21-2010, 08:34 PM

[No subject] - by ordnance11 - 06-21-2010, 11:35 PM

Re: So... they're hiring at the Bazaar? - by robkelk - 06-22-2010, 12:27 AM

[No subject] - by Bob Schroeck - 06-22-2010, 01:23 AM

[No subject] - by ECSNorway - 06-22-2010, 02:09 AM

[No subject] - by The Wanderer - 06-22-2010, 05:29 AM

[No subject] - by ordnance11 - 06-22-2010, 05:34 AM

[No subject] - by Kurisu - 06-22-2010, 12:13 PM

[No subject] - by Bob Schroeck - 06-22-2010, 12:49 PM

[No subject] - by Bob Schroeck - 06-22-2010, 06:45 PM

Serendipity- got to love it. - by ordnance11 - 06-22-2010, 08:15 PM

[No subject] - by Bob Schroeck - 06-23-2010, 02:35 AM

View a Printable Version

Forum Jump:

Users browsing this thread: 8 Guest(s)

Login
Username:
Password:	Lost Password?
	Remember me