Quick example of how this can be done, you should be able to work it from there.

😎

USE tempdb;

GO

SET NOCOUNT ON;

GO

IF OBJECT_ID(N'tempdb..#tmp_CustInfo') IS NOT NULL DROP TABLE #tmp_CustInfo;

CREATE TABLE #tmp_CustInfo

(patID varchar(20),

enc_date...

24 times more Steve:-D

😎

He he, C350 (50.000 in 0x), my favorite engine ever since the '67 Camaro:-D

😎

Lynn Pettis (7/29/2015)

---

Oh Silver Spoon, how do you manage to keep a job when you keep asking such basic questions. At least you found the answer to one of...

SQLRNNR (7/29/2015)

---

WayneS (7/29/2015)

---

Table...

Demanding

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...