I'm not sure why you have the status description in there. Does it really matter if a status is linked to a particular table?

Are you saying that if a Customer...

Yeah, get the front end programmers to split out the crap and remove the ORs. Stuff like that is a mess.

Might be easier to suck those desired codes into a...

Let's not get crazy with the upside down font now....this thread is hard enough to follow.

I'll ask (sorry for the delay). I know I've seen it up there at times.

Be aware that we cache some of that info, so a refresh doesn't kill the db...

Thanks, Mel!

Be aware the first couple hours of the newsletter send (9pm MST), things slow way down. We are working on new hardware to alleviate that.

The designer might be caching something. Interesting that a refresh worked.

Glad you're moving forward. I'll remember to ask the next person about the designer and refreshing things.

Hopefully we can help you with that here. Feel free to ask questions on those finer areas and hopefully we can help.

Barry,

That's interesting. I might give that a try.

Sounds like you're moving in a good direction. Good luck, and remember that you should feel good you're doing the best you can with what you have. Don't let it...

People on this forum provide help for free. We don't do consultancy or design. That's what a consultant if for. You pay for their expertise, and they provide you information....

print @p_cob1 in the procedure without the IF/ELSE. I wonder if it's not quite what you think, some other syntax issue.

Paul,

I am a fairly light editor. I try to let you keep your voice, where a lot of editors beat it down into prose that's more academic and standard.

I can't...

Correct, some roles do not need a database user. They will typically be mapped to some user, like guest or dbo. A sysadmin will map to dbo.

I use reverse chronology so that I see the changes first when I'm looking. Over time when there are lots of changes, it's easy to get a little lost at...