Database

Kapilkp wrote:

a column of unicode data

1. Wrong; a table-valued function[^] may return more than one value as part of a result-set;
    
2. Correct; functions may not have OUTPUT parameters;
    
3. Wrong; a multi-statement UDF may contain[^]:
   
   • assignment statements;
   • control-of-flow statements (except TRY...CATCH);
   • DECLARE statements;
   • SELECT statements;
   • cursor operations referencing local cursors;
   • INSERT, UPDATE and DELETE statements modifying local table variables; and
   • EXECUTE statements calling extended stored procedures[^];
   
    
4. Sort-of; a function may call an extended stored procedure[^], but not a regular stored procedure;
    
5. Correct; a function may not contain a TRY...CATCH block;

The following statements are valid in a function: ... EXECUTE statements calling extended stored procedures.

Richard Deeming wrote:

Almost - I had to look a couple up to confirm what I thought.

Richard Deeming wrote:

Why would you disagree with #4 when it's documented in BOL[^]?

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
They hate us for our freedom![^]

SELECT user_id, SUM(CASE WHEN stkhstm.transaction_type = 'RECP' then 1 else 0 end) , 
SUM(CASE WHEN stkhstm.transaction_type = 'SRET' then 1 else 0 end)  
FROM vektron.scheme.stkhstm stkhstm
GROUP BY user_id

SELECT user_id, SUM(CASE WHEN stkhstm.transaction_type = 'RECP' then 1 else 0 end) * 
SUM(CASE WHEN stkhstm.movement_date > #01/01/2012# then 1 else 0 end) * sum(CASE WHEN stkhstm.movement_date < #01/01/2013# then 1 else 0 end), 
SUM(CASE WHEN stkhstm.transaction_type = 'SRET' then 1 else 0 end)  
FROM vektron.scheme.stkhstm stkhstm
GROUP BY user_id

SELECT user_id, 
SUM(CASE WHEN (stkhstm.transaction_type = 'RECP' AND stkhstm.movement_date >= {ts '2012-01-01 00:00:00'} AND stkhstm.movement_date < {ts '2013-01-01 00:00:00'})  then 1 else 0 end)  , 
SUM(CASE WHEN (stkhstm.transaction_type = 'SRET' AND stkhstm.movement_date >= {ts '2012-01-01 00:00:00'} AND stkhstm.movement_date < {ts '2013-01-01 00:00:00'}) then 1 else 0 end)  
FROM vektron.scheme.stkhstm stkhstm
GROUP BY user_id