thanks - never knew about this technique.

i will have to take your word for it as i need to get the DBA's to set this up for me.

i'll will...

this is now resolved. having thought through the problem i made one adjustment to get the desired result.

=================================

aIM: To get the Stdev of trading activity by customer , product and...

Barry - this suggests to me that i need an additional aggregate in the query with the count of the trade count.

in your example i get some stdev's back...

🙂

thats EXCELLENT

thanks

i think i have just nailed this.

i changed the data field type to a VARCHAR(50) from a VARCHAR(MAX) and it now works.

dont know why - was thinking that the...

thanks -and i agree inserting this line break text into the sqlserver directly from a stored proc and then querying it does show the breaks.

(BTW i use visual studio...