<root>

<Department>

<Department_ID>10</Department_ID>

<Department_Name>Government </Department_Name>

<Employees>

<Employee>

<Employee_Name>Manutosh</Employee_Name>

<Employee_Age>28</Employee_Age>

</Employee>

</Employees>

</Department>

<Department>

<Department_ID>20</Department_ID>

<Department_Name>ECMP </Department_Name>

<Employees>

<Employee>

<Employee_Name>Virender</Employee_Name>

<Employee_Age>27</Employee_Age>

</Employee>

</Employees>

</Department>

<Department>

<Department_ID>30</Department_ID>

<Department_Name>FS </Department_Name>

<Employees>

<Employee>

<Employee_Name>Sumit</Employee_Name>

<Employee_Age>24</Employee_Age>

</Employee>

</Employees>

</Department>

</root>

this is my xml file Andras and that can be come in some other format also means a more level of nesting so how can...

...

You can make a procedure like this

create procedure aatest

@listParam varchar(2000)

as

declare

@sql nvarchar(2000)

--set @listParam='''Manutosh'',''Mahesh'''

print @listparam

set @sql= 'SELECT* FROM login'+' where '+ 'username IN '+'(' +@listParam+')'

exec sp_executesql @sql

exec aatest '''Manutosh'',''Mahesh'''

You get...

Hi all,

           it is still not working. Please help me.

                                             Thanks

                                                 Manutosh

I don't wanna use DTS tool. I just want to do that with "select * into" clause.If there is no choice with this clause I got down.

                                     Thanks for your...

Hi

        Thanks Phill

                    It works fine

                                        Manutosh

Hi,

I have given this query

select convert(decimal(11,3),20.160)/100

result-  .2016000

I need only 20.16

                     Please help me its urgent. I have given this query to my client.

                                     Thanks

                                          Manutosh

Hi,

I have given this query

select convert(decimal(11,3),20.160)/100

result-  .2016000

I need only 20.16

                     Please help me its urgent. I have given this query to my client.

                                     Thanks

                                          Manutosh

Hi ,

          It is still I found 0 in tha last.Suppose I give 20.160 the result should be 20.16 not include 0 at last.

                                                             Thanks

                                                                  Manutosh

The datatype of that column is int but we change it into varchar.

                                  Thanks in advance.

                                         Manutosh