in second query we have ParentLevelId = 6 and added additional join on sublocation so can't it be rewritten in single statement

The first one also inserting into #TEMP_SUBSYS, please double check

Here is my SP

CREATE PROCEDURE dbo.usp_Env_Inventory_GetTankDashboardDetails(@USERID int ,

...

i have just given one example , but in my real cases there are 100's of tables which need this so looking for some generic solution that can be applies...

i can't just go and design in SSIS because by businees client still using the SQL 2000 server so i should develop only using DTS.

Can anyone please help me hoe can i achieve this functionality.

Quicker responses are appreciated..

Guys please help me the one who knows about the DTS packages

Posted long back but no replies

jwbart06 (7/26/2011)

---

I would have to agree that it is very slick.

I was trying to think of doing it with out having to rely on sys.columns, but I can not think...

Thanks anthony .

So is my assumption is correct beacuse of the master compatabality set 100 the user specific databases are set to 80 still we have access to new feature...

This is logically correct but the data in the table is not updated with this select statement.

I Have to update the data on ID column.

Sory for the confudion i have updated the query there is no @tax_ref_id

For each roe of #temp table i have to updated the buss_seqnno

while inserting the #temp2 the name and ID (identity ) columns should be in order

For sequence we have have to follow the sequence (requirement already specified for this )

ok finally solutions could be

using hundreds .. of sql taks cannot we achieve this

.NET script component

Any alternates .................. ????????