Quick thought, you aren't giving the optimizer much to go on here, using a table value function to populate a table variable which by the way doesn't have any statistics...

Quick fix adding the "@" to the attribute names;-)

😎

set@cropXML.modify('

delete (/Crop/Varieties/Variety[@Id=sql:variable("@varietyid")]/SoilTypes/SoilType/YieldGoals/YieldGoal[@Id=sql:variable("@yieldid")]/Stages/Stage[@Id=sql:variable("@StageId")])[1]

');

Parachute

Given that humans have taken 200.000 years to become as stupid as they are and that computers do things much faster than humans, we (humans) should be afraid, very afraid:-D

😎

I think you have to rephrase this question, online analytical processing/olap is an approach to mda or multi dimensional analytics, which dimensional modelling is an integral...

You are very welcome!

😎

I just improved the code sample to demonstrate that query will use index seek if the proper index is in place.

thbaig (7/28/2015)

---

Hi,

I need to select records in column that start with '% ' -- %space e.g. column A = % mytest

I tried select column name with like operator but it...

Simple...

Brandie Tarvin (7/27/2015)

---

Eirikur Eiriksson (7/27/2015)

---

Brandie Tarvin (7/27/2015)

---

SQLRNNR (7/27/2015)

---

Brandie Tarvin (7/27/2015)

---

Wow. Even on The Thread I am having the learning of the stuff. I've never heard of this until today.

Thanks for...

Biank (7/27/2015)

---

Hello,

Anyone know if this is a bug that we can't insert getdate() value from SQL 2008 R2 to a smalldate column on a table in SQL 2005 via Linked...

Good work indeed Luis, nicely done!

😎

Although "theoretically" this is right, one cannot endorse the use of @@ROWCOUNT in that way, too many gaps and exceptions.

😎

Could anyone check this one out, feels like I'm missing something

😎

Quick thought, hope you have either the appropriate firewall/security measures in place or that the machine is either not connected or unplugged from the internet, XP is indeed inherently vulnerable...

Brandie Tarvin (7/27/2015)

---

SQLRNNR (7/27/2015)

---

Brandie Tarvin (7/27/2015)

---

Wow. Even on The Thread I am having the learning of the stuff. I've never heard of this until today.

Thanks for bring up the topic,...