The biggest reason is simply performance. ...

Jeffrey Williams (9/1/2008)

---

Maybe I am misreading this - but it sounds like all you need to do is change the join in the view from an inner join to a...

I wonder why some of the folks from Redmond saw fit to use it to define some of the information schema views if...

Heh... I'm thinking this is strong justification for tele-commuting. 😛 Let's all become agoraphobic and avoid the epidemic, conspiracys, and a modicum of common sense. 😉

Do like Excel does... do the calculations using FLOAT (Barry implied it with 100.0) and then round the answer to the correct number of decimal points for display. If...

OpenRowset cannot take variables as part of it's syntax. You'll need to do the whole OpenRowset thing as dynamic SQL.

As previously suggested, have you looked into "parameter sniffing"? Google it.

Also, are there any settings differences between the two servers like "auto statistics", etc. Last but not least,...

It could simply be a case of "parameter sniffing"... Google it.

Also, are "auto statisics" enabled or not?

Heh... I love "sneaky". That's awesome! Thanks for the tip! 🙂

EDIT - BEWARE !!!!  THE LINK ABOVE...

Pulkit Lall (8/31/2008)

---

when i tried to run the command, it gave me 5 resultsets with 5 random numbers and not 1 random number.

So, the answer is 5 resultsets with 5...

GilaMonster (9/1/2008)

---

Of course, because there are...

Ah... got it... thanks for the feedback.

Still, if the table were properly normalized, this would be a piece of cake. 🙂

Good article!

You did forget to mention one workaround for the UDT's that would allow it to work across all databases including TempDB... Define the UDT in the Master...

Yes... but please look at the actual execution plan...

balbirsinghsodhi (9/1/2008)

---

There was a DDL trigger on that database and I deleted that trigger and ran the code as a stored procedure and it's working fine. You guys rock. Thanks...