Ah, this gives the dodgy result:

select @x Dec, @y Float, cast(@y as numeric(28,15)) casted

So looks like it may be cast as float and then back to numeric in STR()

Thanks Jeff

I checked that BOL entry out this morning, then tried stuff like this:

declare @x decimal(28,15) = 98.43075

declare @y float

set @y = @x

select @x Dec, @y Float

in the expectation...

Also, is there any external configuration going on? If so, merely searching the packages is not enough, you'll also need to look in the config files/areas.

--edit: fix typo

This might not be an enjoyable task.

Where are the packages currently stored? If they're in the file system, you might be able to do some sort of wildcard text search...

jasonmorris (1/20/2012)

---

Phil,

Thanks for that.

I forgot to mention that the variable is declared as DECIMAL(28,15) so I am surprised it causes a rounding issue.

I've never come across this issue before and...

You added an extra decimal place and that was just enough to highlight the rounding issues associated with the Numeric data type, which is what STR assumes.

raiserror('Your master data table has been truncated. Please have a quiet chat with your DBA', 1,1) with nowait

Read BOL to make sure you understand the concepts behind the...

Does the stored proc include Try ... Catch and RaiseError error trapping?

If not, you could try implementing that and see if it does what you wish.

subahan_syed (1/18/2012)

---

Hello -

I'm looking to import multiple excel sheets in one file into multiple SQL tables using SSIS, at the end of the package run, I want to move the...

GilaMonster (1/18/2012)

---

Intentionally.

http://en.wikipedia.org/wiki/Wikipedia:SOPA_initiative/Learn_more

Is it still possible to access Wikipedia...

Can we 'do a Wikipedia' on this thread and block it? Permanently.:hehe:

Hi Sean and thanks for the response.

My point is that using Object Explorer to connect works as you would expect (with colour coding from Registered Servers) unless that colour coding...

I know that this is an old thread, but I think it's the best place...

I've just been caught out by this - luckily nothing major, but still a production server...

public2 61705 (1/16/2012)

---

I hope to eventually offload the whole thing to the users or at least a group of select users. But it seems I'm stuck well before that.

And no,...

Elliott Whitlow (1/16/2012)

---

Is the process known? What I mean is that if Phase 1 returns X result you will ALWAYS go Branch A, if it returns Y then you...