Exactly!  We're trying to implement a CI process, and what you stated is spot on -- I want to ensure that the branch in source control matches exactly what's deployed.  As I...

starunit (1/10/2017)

---

Interesting article indeed.

As other commentators have noted, statistical results can be manipulated in many ways to fit the desired outcome.

I'd like to add that the 'input' side of the...

Thanks again for the info and help, all!

drew.allen (11/7/2016)

---

Since you want the final result as a numeric value, it doesn't make sense to manipulate the string. Try the following:

SELECT m.origval, n.comp_val

FROM #mytab m

CROSS APPLY (

SELECT TOP...

Luis Cazares (11/7/2016)

---

This might work.

create table #mytab (origval varchar(max))

insert #mytab values

('1.2'), --should convert to 1.3

('6.25'), --should...

Thank you as well! But grrrr..... now I'm running into a new problem; the data I'm working with is in a varchar(max) column, and I'm getting the error "Operand...

Wow! Thanks for the quick and helpful reply. The code isn't quite perfect (3.0 returns 3.1, for example), but it gives me a great head start. 🙂

Interesting info and answers, thanks. This particular API system is from Mulesoft, but there are others. I'm getting the impression this is a "shiny new thing" that many...

Thank you!! Your sample script was quite helpful, and worked perfectly well. I resolved the problem in my own case when I reset the database owner using the ALTER...

Thank you for the quick reply! I found that indeed, the databases had different owners. I changed the owner on one database so that they're in synch, then...

Excellent suggestions, thank you! I wasn't aware of the Discard Results option - amazing how there's always more to learn no matter how long you work with something. ...

Thanks much for the push in the right direction! I'll have to read up on the gaps and islands stuff - that's perfect. I'll have to turn this into...

Phil Parkin (9/18/2013)[hrOne fairly standard approach is as follows (note: 'ChangeDate' refers to the maximum of DateCreated and DateModified and is a datetime(2) value):

1) Set @ChangeDate = max(ChangeDate) from your...

I gave up on this. I think the SMO transfer class (and therefore the SSIS transfer objects task) simply doesn't allow for changing certain object properties. My workaround...

aaron.reese (9/16/2013)

---

your problem is going to be that a dataflow requires the field names and types of both the source and destination to be defined prior to compilation so you...