Comments by pratap420 (Top 26 by date)

Here client means Oracle software? or any driver?

Order by col3,id is using in 2012 also.But storage order in temp table different with respect to 2000.

If I add order by in cursor,the result set will be different in 2012.But business team still referring 2000 db only.And they expecting same data in 2012.

How come you assign two values in a single variable in a single shot? If you want you can use multiple variables to assign multiple values

unfortunately I missed it ..Thanks

what's your expected output?

Thanks John for your response

Thanks Praveen. I think employers expecting more knowledge on performance tuning even from 2yrs exp guys and they were expecting from guys to had a exp on such cases.

Thanks for update.But I need to check if any breakage in the code/syntax wise deprecation

In development environment we are not using XML config file .We are passing paths,values through variables by manually.Even my job has to execute by manually only

I am passing the XML file path to Procedure.In procedure i am getting the XML using file path.During this process ,I used varchar instead of Nvarchar .So that am getting this issue.Now I fixed it . Thanks Richard for your valuable suggestion.

Thanks all for your suggestions.

I am not clear with your table .Table is having 4 cols but row are showing more cols
Can you rearrange the table

yes correct CHill. My openquery using column names only.

Excellent thought.Its working as per my requirement .I learnt nice logic today.
Thanks Andrius,Maciej

I tried Dispaly:inline,inline-block but no fruitful result.My code already using span.

Thanks Maciej.Actually I have 8 cols in table1 .If I do like that query cost will be more .My job is already taking 20 mins ,If I add this it will add few more mins time.So,I need to give very very optimized script with out effecting original time.
I posted sol2 for this requirement,but still I need some more optimized script.Please have a look into Solution2 and provide comments

yeah correct . sample data :

table1 : col1 col2 col3
file_abc Dfile_xyz Mfile_mnp
file_afc Dfile_xyz Mfile_mnp
file_afc Dfile_acd Mfile_oop
table 2: id value
1 file_afc
2 Dfile_acd
3 Mfile_mnp
4 file_abc
5 Dfile_xyz
6 Mfile_oop
7 .......
8 .........

whatever values in table1 col1,col2,col3 we are going to insert into table2 .
1.Everytime based on table1 , data will be inserted into table2 with out duplicating data .
2.By using tabl1,table2 we will insert result to table3 .

Now I want table 3 would be
table3_id col1_id col2_id col3_id
1 4 5 3
2 1 5 3
3 1 2 6
step 1 I have done using unpivot concept.I am working for step2.
Note : all these three tables are perminent tables

In your example you have one table for unpivot but in my case I need to use two tables.But how?

Sorry for confusion.I already have table1,table2.By using these two tables I need to insert into other table (final_table),like
col1 col2 col3
1 2 3
10 12 9
Here 1,2,3,10,12,9 all these values are from table2 ids corresponding to table1 col values .

No for sample I gave like that but actually my table1 has fixed 8 cols like this,data will be different for each row and table2 data will be increased based on table1 col data .Table2 always have distinct rows .