You could use a CASE Expression:
CASE WHEN VT1.ValueText = 'No' THEN VT2.ValueText ELSE VT1.ValueText END AS ValueText
Assume VT is value form the left hand side of...

Have to agree with Steve here. If you had 1 or 2 values coming back, then OUTPUT parameters would be fine, but you have 18 variables there. A resultset is...

At first I thought the same thing, Phil. Then i read it again and, unless I'm mistaken, the OP is actually setting the value of a date to a variable,...

I'm not sure I completely understand what your requirement is here, what do you mean my the value obtained by a parameter? Does your SP have a OUTPUT value that...

As Beatrix said. The best thing to do is as soon as you switch the database recovery mode is take a backup, if you're able to. Otherwise, any transaction log...

Also, 26/08/2014 5:23 is not 2 hours ahead of 26-08-2014 15:23, it's 10 hours before. 26/08/2014 5:23 = 26/08/2014 05:23 = 26/08/2014 5:23am.

Are all the...

Have to agree with Phil here, how does 1409030583 become 2014-08-26 05:23:00.000? I can't see any correlated numbers in these two values, apart from that (possibly) the 14 at the...

The error is giving the game away here, you haven'tt supplied enough columns. Your table @BaseTable has 11 columns, however, your OUTPUT INTO only has 8. You need to supply...