thx all, it seems that I lost a reply

However I find another solution

create proc usp_write2Excel (@fileName varchar(100),@NumOfColumns tinyint,@query varchar(200))

as

begin

declare @dosStmt varchar(200)

declare @tsqlStmt varchar(500)

declare...

grrrr I lost my post :@ ...

again ... U_U

My principal table

CREATE TABLE ##table_metodo1

(rfqKey int, rfqName varchar (255), Family varchar(255),

Repet float, Freq float, total float, pos int )

INSERT INTO ##table_metodo1

VALUES...

It would work if there is a way that i can index keyword with family, from the information in the db, but there isn't.

The real problem is I have...

Hi again, ..... I don't know what to say, I was trying to get the results from yesterday to post them, but now all works fine, In fact there is...

Well like a said the first and the second join are correct, I already verify that.

the table estructure in #temp1 is

rfqName varchar(255), rfq int, ptn int

#temp2

ptn int, Family...

Well, hi there and thx for the replie

I will explain what I want to do

I have a table ##table_metodo1 with the ranking of Families for each rfqKey (id), but some...

Yep, that's the Idea, and I prove that and it works perfectly.. So my conclusion it's that the query fails with a large size of data.

Because i don see anything...

but the procedures are not nested, and a temp table It's destroyed when the create procedure finish

that's not the problem.. the problem was that I have multiple procedures, and I need to use the output table of another procedure, and in order to do that i...

Thx, a lot... that's what I want, and you show me some tricks with that query...

I thought that nobody will answer me at that point, but yesterday I was able...

thx both... i was missing the "use tempdb" statement when I try to search the table name in information_schema.tables

thx both of you

If the above questions are affirmative then the solution will be something like this

SELECT bno, MAX (CASE WHEN gno = 1 THEN point) AS 1,

MAX (CASE WHEN gno = 2...

can't you just drop the table B?? and then execute the select .. into

Related to your questions:

1 Yes I use SQL Server 2000

2 the f1, f2, fx are only names, in fact there are a varchar(255) with a long name, like "Steels and...

mmm I can calculate the max number of families.. but I think I didn't explain very well my prbolem....

Well after a not to short procedure with querys an temporary tables,...