This outline should work:

declare @funCode char(1)

set @funCode = 'B'

if @funcode = 'A'

begin

print 'The function code was ''A''.'

end

else if @funcode = 'B'

begin

print 'The function code was ''B''.'

end

else if @funcode = 'C'

begin

print...

Can't say I share your enthusiasm for the B-man, but good for you for sticking your neck out in his defense.

Like most people, I in fact have little to no...

Hi - yes, it's technically possible to write a procedure like what you are after, and it can be made to work. It just gets quite confusing to read and...

Cory - there are a great many flow control problems in this code... I am having trouble explaining. I think that your BEGIN and END blocks are in the wrong...

Also, consider that this one proc maybe does too many different things. Your whole flow control issue might go away if you create separate SPs for each operation. It's always...

I see two issues - first, it seems you might be missing a begin ... end block for the Else portion of that first conditional statement. Second, not related to...

It sounds like you are in for a big ol' heap of data entry. Could you use a service like

http://www.dotcom-infoway.com/dataentry.asp

?

[I just got that from a Google search;...

Just a join, right?

select c.id, c.bid, c.name, b.name, b.aid, a.name

from c

inner join b on c.bid=b.id

inner join a on a.id=b.aid

I've seen this type of question before and composed an answer -- it was quite challenging for me the first time. This was originally in

http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9924

There was another similar...

"I'll bet the reason more people don't graduate from rodeo clown school is because they don't pass Being Funny While Getting Gored in the Ass 101." -- Donald Junter

courtesy of...

I feel sure Lauren meant to write

select * from table_name where column_name like 'aa%' OR

column_name like 'bb%' OR

column_name like 'ccc%' etc etc

"column_name like 'aa%' and column_name like 'bb%'" would...

Well, kinda. Do some reading on this, really. This format will not allow you to get all the information you need to do the job well.

Basically, you want to create...

Hey Shoom,

That's a BIG topic for this little forum box :-).

If your concern is performance, then indexing can help; views propbably not. Views are a method to present the...

Is there some reason not to use actual computed columns, instead of calculating in the select statement?

Yea, that one. 😉