Update:

I just amended the code to add a line to the join clause only letting through those records with a VINT > 0:

SELECT

i.CPSP35

,i.VINT35

,(i.CPSP35 / i.VINT35) as High

FROM...

GilaMonster (8/17/2015)

---

What does this return?

SELECT

i.CPSP35

,i.VINT35

FROM dbo.SSCCWorderExtract e

WHERE VINT35 = 0

SQL may run the division before it does the filter and join, so if there are rows with VINT35...

It might be worth adding that Facebook runs on MySQL and PHP with in excess of 50 million transactions per second (as of a couple of years ago anyway).

Thanks but its still giving me the message "The view contains a convert that is imprecise or...

Thanks EdVassie for that response. Very interesting stuff.

I used your code and adapted it as there was an issue where the directory couldn't be deleted if it contained files (or it could have been to do with...

I'm not verifying it exists at all. I'm just deleting it, and when it doesn't exists, then I have a problem. I suppose that's my question now then isn't it,...

Andy this is turning into a really interesting series and I can't wait to see what further BIML wizardry you've got in store for us.

Andy Leonard (7/17/2013)

---

Koen: thanks for answering Vijay's question!

theboyholty (7/17/2013)

---

You mentioned an article in the Stairway Series called "Building an Incremental Load Package – Level 3" maybe I'm being thick but...

You mentioned an article in the Stairway Series called "Building an Incremental Load Package – Level 3" maybe I'm being thick but I couldn't find that article. There was one...

Jeff Moden (6/27/2013)

---

Maybe compared to the original code but with all of the RBAR you have in the code you posted, "lightning" isn't the word...

Purely in the interests of throwing the cat amongts the pigeons, you can write a line of code in a stored proc to drop itself you know. I know it...

I don't understand why so many people are so happy to be presented with a simple question, or so pleased with themselves for getting it right. personally I prefer something...

Jeff Burton (4/18/2013)

---

I have been using this technique for many years. It's much easier to maintain than dynamic SQL. I have also used it for dynamic GROUP BY...

I'm more than a little surprised that this technique is being put about as being new or clever. Surely its the neatest and most logical way to deal with the...