Have you tried getting rid of the correlated sub-query? That's bound to be hurting you.

Select

...

ageuni (6/5/2008)

---

So in answer to the original post, businesses talking about putting business logic back into the application means they are correcting bad architecture choices made early on. They should...

Gwen (6/5/2008)

---

Your Pivot is doing a grouping by propertyID AND usecode, which is wrecking your "alignment". pull the usecode and price out (leave them in the combined), and I...

Considering it's a test - you're going to need to do most of the work.....

That being said - you're going to want to look up the SQL 2000 "method" for...

okkko -

I think Jack didn't include the part where he specifically built a "changelog" table somewhere. It actually looks like there's a utility database called dblog where he's...

Gwen -

Your Pivot is doing a grouping by propertyID AND usecode, which is wrecking your "alignment". pull the usecode and price out (leave them in the combined), and...

Rama (6/5/2008)

---

Hi Guys,

I have temp table #temptbl with two columns

I am inserting into two column by calculating some formula with exec.

INSERT INTO #TEMPTBL (formula,final_formula) EXEC ('SELECT...

Dugi (6/5/2008)

---

hmm interesting situation why the column should be the Primary Key column but on the other hand it is not clustered till it is primary key! ok ok everyday...

noeld (6/4/2008)

---

Matt Miller (6/4/2008)

---

I'd make sure to test that on a 2000 box. the sp_helpText returns something entirely different for sp_AddExtended in 2005. There's no mention of sysProperties.

Rut...

I'd make sure to test that on a 2000 box. the sp_helpText returns something entirely different for sp_AddExtended in 2005. There's no mention of sysProperties.

Rut roh....looks a bit...

Since you have lots of parameters to pass - I would probably look up "ADO Command" and get really familiar with it. There's a fair amount of readily available...

Michael Earl (6/4/2008)

---

But remember that the "pipe" being referred to is the one between the SQL Server and the RS Server. They could be on the same machine or...

Jeff Moden (6/4/2008)

---

Yep... I understand that... but why does it work in SQL Server 2000? What is it that allows sp_AddExtendedProperty to add a row to sysProperties without, apparently,...

david.burrows (6/4/2008)

---

I've got a package that imports a flat file into a table and unfortunately one of the fields that gets converted to money is coming in as just real...

Or - if you need multiple groups - it might look something like this:

SELECT t1.k1,

STUFF((SELECT ','+cast(t2.itemnum as varchar(20))

...