I don't know the specific answer to your question but I have generally found it better to create a temp table or table variable (depending on size) and insert each...

One thing I couldn't do easily was to deal with dates (that are date values in excel). These would show as "44649.94918" in the values table. When you would probably...

I just noticed that you need the table to start in column 1 for this to work properly. Although here is a version that works if the table starts at...

I don't think you have to respect people in order to do a good job for them, or with them for that matter. Some people are virtually impossible to respect...

"Therefore, since brevity is the soul of wit,
And tediousness the limbs and outward flourishes,
I will be brief: "
Shakespeare advocates keeping it short and sweet.
As does...

"I know I've made some very poor decisions recently, but I can give you my complete assurance that my work will be back to normal. I've still got the greatest...

Anyone else find it really disturbing when your typing a gmail and it auto finishes your sentence...?
gooogle knows your kink.... get used to it.
Google knows your wife is...

I watched the good, the bad and the ugly again on netflix... Somehow it had a 3 star rating.... unbelievable. That's a 5 star film.
I like Clint behind the...

I totally agree. Time is essentially represented as a scale data type starting from an agreed zero point. When the clocks change you are effectively removing or adding units from...

Confucius was asked what he would do if he was a governor. He said he would "rectify the names" to make words correspond to reality!
You're clearly on the right...

You've created a set of all the records in table temp_1
left joined it to Temp_2 using the ID
You've then applied a where clause to this set that filters...