Eirikur Eiriksson (1/19/2016)

---

aaron.reese (1/19/2016)

---

@jacob and @jeff

SSRS is not my natural home 😀 so I was not aware that IIF(x AND y) is a bitwise operation. Maybe I wasn't asking...

Eirikur Eiriksson (1/19/2016)

---

GilaMonster (1/19/2016)

---

*sigh* All but one comment on a blog post are of the form 'Did you try X?' 'Have you compared Y?' 'Probably should have a test with...

Throwing in the CASE using Eirikur's wonderful setup yielded this on one million rows on my machine (tangentially, I'm embarrassed that Eirikur's laptop is faster than my test server :blush:):

T_TEXT...

This sounds less like FREEPROCCACHE didn't work and more like you just had some queries get compiled with poor plans. After a subsequent clearing of the cache, they happened to...

You have to actually configure the...

If you're wanting to see the objects that are referenced by that stored procedure, then you're checking the wrong thing in the WHERE clause.

As written, that query is looking for...

Also keep in mind the database context. If you're running this without specifying your database, and your...

Just a cautionary note on the CASE version: be aware of how your implementation handles ties. If you're not careful with the CASE, then you can get incorrect results, as...

Jeff Moden (1/18/2016)

---

Jacob Wilkins (1/13/2016)

---

I might be misunderstanding you, but if you're starting with the integer value (it sounds like you are?), then I find this method a bit more...

Eric M Russell (1/18/2016)

---

Why not use the T-SQL bitwise operators?

https://msdn.microsoft.com/en-us/library/ms174965.aspx

For example:

3 & 0 = 0

3 & 1 = 1

3 & 2 = 2

3 & 4 = 0

123456 & 1 =...

That's not quite what that does. 🙂

AND is bitwise AND there.

So it takes 2 to the power of 1 less than the bit to validate (so, if validating the first...

It doesn't matter that there are no matching rows in the postal table.

If that query returns 126 rows, that means there are 126 ZipCodes in the Import table that occur...

Alas, I was almost going to go to Nashville, but transportation's easier to Chicago, so I'm aiming for that one.

Welsh Corgi (1/14/2016)

---

I execute the following Query:

INSERT INTO POSTAL (ID,Latitude, ID.Longitude, CityTownshipID, CountyRegionID,StateProvinceID,CountryID)

SELECT ZipCode, Latitude, Longitude,CityTownshipID , CountyRegionID, StateProvinceID, CountryID

FROM Postal_Codes_Import

WHERE NOT EXISTS (SELECT *

...

I seem to recall that with SSAS you have to use the form A-(INT(A/B)*B) as a substitute for A%B, since SSAS lacks a modulo operator.

That would work out to something...