There's probably a faster way, but this works I think:

select convert(varchar(11), cast('1978-01-25 00:00:00.000' as datetime), 13)

You can set the TablesList property via an Expression.

Try this:

use AdventureWorks2008R2 ;

GO

select avg(salesytd) avgSalesYTD,

a.PostalCode

from Sales.SalesPerson s

join Person.Person p on s.BusinessEntityID = p.BusinessEntityID

join Person.Address a on a.AddressID...

My pleasure - thank you for the feedback.

You need a logical OR on those precedence constraints.

Have a read here[/url] for examples.

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...