I'm trying to do in sql server something that was very easy in Oracle Sql...
select col1||'''|'''||col2||'''|'''||col3||'''|'''||col4....etc from <usertable>
and I'd end up with a string with columns separated by a pipe (|) it would cope fine with dates not needing cast or convert etc...
There doesn't seem to be the equivalent in transact-sql used within sql server.
I appreciate that I have to cast date columns but the implication is that I can use the + operator but when I do so I get the message "Error converting varchar to numeric" implying it is trying to numerically add them together!!!
(e.g. select cast([timestamp] as varchar)+'|'+[No_]+'|'+ etc.... from <usertable> )
Any ideas what I'm doing wrong?