Kevin,

This is (in my opinion) a data presentation issue, not a data storage issue.  If we can look at it that way, then there is an easy solution:  use the...

There are lots of ways to do this, and somebody might chime in with a better idea (I'm not convinced this is the best way to go, but I'm a...

Correct.  Which is why the following in Oracle is a LEFT join even though the (+) is on the RIGHT. 

SELECT ... FROM A, B
WHERE A.X = B.Y (+)

You should...

Thanks Bill - I appreciate the moral support, especially from a 10-Century man such as yourself (wowza!  there can't be that many of you, I bet). 

I almost didn't post...

Well ... thanks!  I don't usually lose my patience with people, and I feel stupid for tooting my own horn, but I was a little frustrated with Sukhoi.  Thanks for...

Wake up on the wrong side of the bed, Sukhoi? 

I do know Oracle, and I know it extremely well - sorry.  I also...

I'll cross the culture lines on this one (see my sig below, SPECIALLY REPRODUCED for this post.  Not that it's something I'm proud of, ... well ... at least not here! ...

No, there isn't anything really similar to that in SQL Server.  Of course, the BREAK statement is not an Oracle *server* command, but a SQL*Plus command.  It tells SQL*Plus to...

Analau,

The first method is passing arguments using named parameters.  With this method, exec myproc @p1=@v1, @p2=@v2 output means that the procedure myproc has a parameter named @p1 which you want to...

I think the parameter syntax for sp_executesql just has you confused a little.  It *is* confusing at first, too!

Here's an example of retrieving a count of user-defined tables in the...

Warning:  this post contains potentially offensive language.  That's right, I'm going to use the "S" word.

Sybase.

Sybase had behavior in its version of Transact-SQL that allowed you to continue a string...

FYI, it looks like you've posted this to the wrong forum - this forum is for SQL Server 2005 (aka "Yukon"), which is currently in beta.  You may want to...

The .ADP itself can be opened for editing by only one user.  This means that only one user at a time can post new forms, macros, reports, etc. 

However, that's...

I'm afraid I don't really know any specific resources for ADPs.  Maybe somebody else can chime in on that. 

> It does help as these are database specific roles/permissions...

First, let me make a fairly imprecise (but helpful) definition.  An expression is something that can be turned into a value.  For example, in the statement SELECT productid, productname FROM product...