It's very interesting how this starts as a concatenation theme, but now it has become an implicit conversion issue. By the way, the only implicit conversion in wich I trust...

Good question, altough not clear at all:

I don't know if [Table B] is single-column or multi-column, but if it's multi-column, null values are storeds in [Column Name]? I assumed that...

Now I have one more reason to love table variables 😉

In short, I got a job offer last week for a 50%+ pay increase. I accepted it, and submitted my resignation at my current employer. Four days later the...

After many years working in IT, I have learned that nothing is as simple as it looks at first sight, and 1+1 not always gives 2 as result (altough should...

A couple months ago, I learn by the hard way that you can't use table variables in dynamic SQL, when I had to optimize a sp based on dynamic SQL...

Maybe I'm wrong, but I think that this QoD is about the right reason (instead the right answer), of "why I participate in the QoD?", and make us think about...

Another day, another wrong answer. But now I know a little bit more about restoring database options 😀

Thanks!

It's hard to find a right answer when the knowledge is not enough, and in fact you must read the question author's mind to do it.

Steve! Should you review and...

In your VB code you can comment out the time out setting, to use the server default setting:

' objCommand.CommandTimeout = 0

In your sp code, put BEGIN TRANSACTION before BEGIN TRY,...

This is not true:

A Table Variable can have primary keys and indexes defined.

Unless the meaning of what you said is:

A Table Variable can have an index defined as...

If you want the most recent records, simply change the ORDER BY

SELECT v.ACCTNO

,v.NAME

,vs.TERMS

,po.ENTER_DATE

,po.ID

FROM VENDOR v

LEFT JOIN VEND_SET vs on v.ACCTNO = vs.ACCTNO

LEFT JOIN PURCH_ORDER po on v.ACCTNO = po.ACCTNO

WHERE...

Now I know why this question is worth 2 points:

One point is for the question per se.

The other point is due for the high grade of difficulty on read the...

This may sound a little bit pretentious (or too much), But I want to continue working in IT until my last day of life, and I have no intention of...

The fact of having some feature available doesn't means that you have to do use of it. As happen with cursors, which is a feature that I have used pretty...