Thanks for the heads up and advice Paul.

It will work either way (with or without the linefeed) - query results options play a difference though.

Change your query results options from "results to grid" to "results to text"

That should fix it for you.

Create a return line

thanks for the question.

ChrisM@Work (8/22/2011)

---

Hi folks, I've not visited here for ages, I hope you are all well.

Anybody recruiting presently? We've been recruiting a DBA and a TSQL developer (with some role...

Super Pac-Man

Blues

Make this change and it will work in that case

,@tier_rate decimal(18,10)

Can you provide sample structure and data? Maybe there is something there between them that can be used.

An implicit conversion is happening. And when it is converted, a truncation is occurring.

Try this.

select round(((CAST(5000000000.00 AS DECIMAL(18,2))*CAST(2.0250000000 AS DECIMAL(26,10)))/111883775187.72)*932364.79,2)

Separate folder works, but more specificaly a separate file.

I am in favor of a negative knee-jerk reaction to tweeting from SQL Server. Thinking on the topic, I can see a few ways that it might be possible...

nice question

Ditto