Here's a way to make lots of constrained test data of many types... so far as not making "too many" rows, I agree, partially... when you are experimenting to make...

luissantos (10/19/2007)

---

I hold many lines because i want to return for each u_subconta (account of Customer) all the movment of this account.But i thinks that is not the problem.

My problem...

Heh... I thought the same thing... but there's two columns that look very much alike...

Committed_Fund_ID

Committed_Fund_Item_ID

I don't see the Committed_Fund_Item_ID being used in the problem GROUP BY query... 'course, the formatting...

Heh... yeah... I forgot about that. Well said...

Not sure I agee about linked servers always being slower... I've found that it depends on the number of hops it has to make... I've got several linked servers at...

Heh... I'm thinking you missed a great "tool box" opportunity with the DBA... not a problem... thanks for the feedback.

Umm... using passthrough "synonym" views to perform the crosstalk between databases without using the full 3 part naming convention was the whole purpose of the article... what's wierd...

Couple of us didn't... I missed that... sorry. :ermm:

vadimt (10/18/2007)

---

the first solution didnt work. because of the Tally i didnt implement.

i dont need it as a function because i need it only in one place in the whole...

By the way... this note cracked me up this morning... I almost...

Heh... what'cha gonna do with a CLR that can't be easily done with good performance in T-SQL anyway? 😀 Think of it as an "omen"...;)

Heh... thank you kindly for the "plug" 😀 Got a present for ya, MrPoleCat...

CREATE PROCEDURE dbo.AutoCrossTab

/**************************************************************************

Purpose:

-------

...

Went to the doctor and said "Doctor, when I hold my arm up like this (deomonstrating strange angle to arm), it hurts like hell". Doctor said, "Don't do that......

Not sure why you're trying to do such a simple thing in such a difficult manner... but, using YOUR code...

SELECT * FROM #TestTable

WHERE Title LIKE '%'+@dummy+'%'[/b] or Title is null

OR...

I think you'll find the problem in one of the text columns... you may have some trailing spaces in some of the descriptions. You can check for those by...