when I excute my application, , the error - 'when casting from number the value must be a number'
I am not sure if it's blowing up on this statment
retVal = (int)cmd.Parameters["@pIntErrDescOut"].Value;
"@pIntErrDescOut is a value passed from the stored procedure and its data type is int.
Also I am inserting a value into the database by setting this parameter cmd.Parameters["@PerLevel"].Value = PerLevel.Text.Trim(); --- The value data type is int in the database. How can I convert to numeric before inserting.
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs).
Being someone who is always looking for alternatives to "work your data", I came across this …