No problem.

I was responding to this statement:

I generally use SQL2K8 and i'm used to the format on it. Unfortunately the company i'm working for are on 2K5 and they're not...

What is there about your proc which works on 2008 and not 2005?

I explained the behaviour of STR() (or so I thought).

For your purposes, it is not suitable. If instead you cast your variables as, say, varchar(30) and then print them, you...

krishnaprasad14 (1/31/2012)

---

Thank you for the reply. But here we are not deleteing existed records in UNMATCH table.

[For example, today we got 3 records into Unmatch obkect and tomorrow may be...

Koen Verbeeck (1/30/2012)

---

Use an Execute SQL Task to create a backup of the database.

Use another...

I'm afraid that I don't 100% understand what you are doing. But as you are operating on a single server, I would be tempted to do the whole thing in...

So is it the case that you only ever want to insert new data and that you are not worried about updates?

Is the PK ID an identity column? Just wondering...

Or maybe you...

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