Hey,

i was editing the script, now i get this error:

script:

;WITH Estimates AS

(SELECT nh.id,nh.parent_id,nh.name AS 'PLAN',Levelnodes=1,

Jerarquia = CAST('\'+CAST(nh.name AS VARCHAR(200)) AS VARCHAR(MAX))

FROM testprojects tproy

INNER JOIN testplans tplan ON tproy.id=tplan.testproject_id

INNER...

Retry deleted.

Thanks.

I modified the script a bit and doesn't generate errors:-), but isn't listing the desired result .. please see document attached (img_1/DataExample.txt). If you can see the nodes_level with hierarchy..

Please...

ok I get it on the NOLOCK. Thanks.

@alan.B

your query give me this error:

Invalid object name 'Estimated'. 🙁

thank you very much.

You're not wrong, i work with peoplesoft.

The select of this UI is a PIVOT statement.

with the query att. the perfomance is OK, and if i handle by the UI i have the read 1 record by...

For the perfomance mostly..

Dependin of the column "Nivel",

if that have a value of 1 or 2 or 3 the columns 'A','B','C','D' must be empty,

That data r results from a dynamic query,

well that result i input to a temporary table, and then i made a update.

my test query:

DECLARE @sql NVARCHAR(MAX)

DECLARE @colCampoREPLACE ...

sorry, wrong post.

😛

if the temporary table is in dynamic sql?

Hmm, can u prove it?, i mean,

do you have an example and probe it what you say?

but he can insert the csv file into a table variable and then manipulate the data

Import to SQL

Like this:

select * from OpenRowset('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)};

DefaultDir=C:\External;','select top 5 * from

Mytext.txt')

Or try this:

OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Text;Database=C:\External',

'select * from TRANS.csv')

select top 50 * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Text;Database=c:\temp\captell;HDR=Yes;FORMAT=Delimited(;)', 'SELECT...