dbursey (4/18/2013)

---

From the other side of the fence - I've asked questions here and got ripped a new one because I didn't provide actual examples - sometimes it's hard to...

churlbut (4/18/2013)

---

I don't understand why someone would get annoyed by a forum post asking for interview questions, sounds like there are quite a few people that are kinda snobby in...

Jim P. (4/17/2013)

---

Thats not obviously my final conclusions, there could be real downsides to the topics this seems to address, but my first impression is that its a net...

Jim P. (4/17/2013)

---

patrickmcginnis59 10839 (4/17/2013)

---

Now, I'm willing to play devils advocate for either side, so I'm curious about what alternative motivations for each side we can think of? Obviously big...

djackson 22568 (4/15/2013)

---

Steve,

I am not sure I agree with this being a cool...

Sean Lange (4/17/2013)

---

patrickmcginnis59 10839 (4/17/2013)

---

Sort of a generic approach. I don't think it compares very favorably to the microsoft specific approach, ie., 'UPDATE FROM'.

Hopefully someone can take my DDL and...

Sort of a generic approach. I don't think it compares very favorably to the microsoft specific approach, ie., 'UPDATE FROM'.

Hopefully someone can take my DDL and we can start one...

this is a fairly interesting topic!

However, what you're looking for might not exist in a perfect form. What you seem to be asking is for a tool that allows management...

I know I'm posting the obvious here but I would have liked making income a discrete item by dividing the values into ranges and selecting on that.

Pseudocode of my guess!

Select e.entityId,

a.name,

a.title,

a.address,

e.rank

From (

Select entityId, max(Rank) Rank

from (

Select

Top(50)

e.entityId

keyTable.Rank

From

entity e

inner join ContainsTable(srch_param, param_val, @contains_srch_param) as keyTable on e.entityId = keyTable.key

-- Order by keyTable.Rank desc (probably not needed)

Union

Select

Top(50)

e.entityId

keyTable.Rank

From

entity e

inner join...

In all seriousness, have you had a look at Microsoft "lightswitch?" Its a darn neat looking product, maybe worth a look. I haven't heard much from it lately though, maybe...

The answer is as always, "cubes".

With cubes, you can enable creative use of multinational, specialized skillsets enabling proactive analysis of transformational datasets allowing the organization to leverage the diversity of...

456789psw (4/9/2013)

---

I commonly find CTE using spool operators in the execution plan. According to Microsoft the spool operator uses the temp table.

"The Table Spool operator scans the input and...

Perfect case for a CASE!

btw nice post subject, I'm going to use your code myself!

edit: you could probably move the case clause elsewhere to take care of the comparison, for...

Make sure one of the traces isn't still in progress! LOL dumb suggestion, shows how little I know etc etc but I haven't met my post quota for this week...