Phil Parkin (10/9/2014)

---

With the numbers' you're talking about - you're going to have to address a way to compare like attribute to like attribute. Since you said that the attribue...

With the numbers' you're talking about - you're going to have to address a way to compare like attribute to like attribute. Since you said that the attribue ID's might...

ScottPletcher (10/8/2014)

---

joepacelli (10/8/2014)

---

The outputrowcount is fine. It returns 1

it's my identity column which is returning 0

I also tried Ident_current('dbo.jobid')

This returns the correct value

But, according to MSDN site

Be cautious about using...

The requirement is that it be appropriately separated from previous SQL statements, not that is HAS to have a ; or Go before it. If your CTE is the...

Eric M Russell (10/6/2014)

---

sqldriver (10/6/2014)

---

At what point do you decide to throw it in and start over from scratch? This thing uses 38 tables, countless temp tables, 47 stored procs...

I'd approach it kind of like a piece of unclaimed luggage: Isolate it, then put a fireproof container around it and try to see if it detonates.

All right...

What is giving you the error? I can save the tag you show as XML just fine, so I think your error is likely elsewhere.

I've often found...

Assuming you need this to be able to truly recurse through n number of levels - here's an actual recursive version of it:

WITH testdata as (

select 1 as ID, 0.11...

Why not simply maintain 2 separate tables and union them when needed? What value do you get out of jamming two separate concepts into the same structure? For...

Alvin Ramard (9/29/2014)

---

SQLRNNR (9/29/2014)

---

Koen Verbeeck (9/29/2014)

---

Hopefully you didn't change them right away, because...

Can you give an example of the outputs? Just trying to ascertain what the actual difference are?

It's going to be hard to troubleshoot this minus test data and expected results.

That said - something does jump out: The only place you have the ORDER...

One more wrinkle: are you confident that the client you're dealing with "agrees" with your version of what's proprietary? In other words, is there a chance for blow-back...

The issue looks to be that your two rates aren't equivalent, i.e. this formula

(Us-->GB Rate) = 1/(GB-->US rate)

turns out to not be true with the values you're providing. ...

djackson 22568 (9/24/2014)

---

andrew gothard (9/24/2014)

---

Bwahaa, that's apparently fixed now with their express recharge process...