The SELECT item identified by the ORDER BY number 1 contains a variable as part of the expression identifying a column position. Variables are only allowed when ordering by an expression referencing a column name.

Variables are only allowed when ordering by an expression referencing a column name.

this means using the variable in a case or if statement  (me thinks)

Remove json syntax from strings

with JavaScriptSerializer class

 JavaScriptSerializer javaScriptDeserializer = new JavaScriptSerializer();
                List<string> idList = javaScriptDeserializer.Deserialize<List<String>>(Ids);

Social skills over Methodology

here

Table types in sql server

are read only

check time of specific parts of sp's

SELECT  requests.session_id,
        requests.status,
        requests.command,
        requests.statement_start_offset,
        requests.statement_end_offset,
        requests.total_elapsed_time,
        SUBSTRING(details.text,
                  requests.statement_start_offset / 2,
                  (requests.statement_end_offset - requests.statement_start_offset) / 2)  as problem
FROM    sys.dm_exec_requests requests
CROSS APPLY sys.dm_exec_sql_text (requests.plan_handle) details
WHERE   requests.session_id > 20
ORDER BY total_elapsed_time DESC

special characters in blogspot

have to be encoded

e.g. &lt;

ListView I couldnt see my columns

I was covering them with a toolbar