I wrote Clr function

Which copies XML

from Web server

to a file in the file system

The way I use the function

select dbo.downloadfile ('http://rates.fxcm.com/RatesXML','C:\Temp\RatesXML.xml')

this

Select * From

( Select account, dataset, stringvalue

From test) as A

Pivot

(

min(stringvalue)

for

dataset in (col1, col2, col3)

) as...

Here is an example of something that is doing the

Reverse of what you are trying to do

CREATE TABLE pvt (VendorID int, Emp1 int, Emp2 int,

...

Here is an example of something that is doing the

Reverse of what you are trying to do

CREATE TABLE pvt (VendorID int, Emp1 int, Emp2 int,

...

you can view this post

http://www.sqlservercentral.com/Forums/Topic1045762-391-1.aspx#bm1045818

Maybe if you tell me what you are trying to solve, why you need the query I could help,

Just might be a better solution for the problem you are trying...

this

select col3,col2,col1,coalesce(z.account,y.account,x.account) as account from

(select stringvalue as 'col3',account

from test where dataset='col3'

)as z

full join

(select stringvalue as 'col2',account

from test where dataset='col2'

) as y

on z.account=y.account

full join

(select stringvalue as 'col1',account

from test where...

you dont need to have the ssis install on non of the 2 computers

whan you create the steep

after you select

sql server integration services package

in the type drop...

you can run ssis package from a job

create a new job

and whan you add a steep to the job

in the type drop down list select

sql server integration services...

you can also read this artical

http://www.sqlservercentral.com/blogs/stratesql/archive/2010/11/04/return-of-the-index-analysis-report.aspx

the

select * from sys.dm_db_missing_index_details

the way it works the sql server optimaizer write

to dm_db_missing_index_details

indexs that will help the queries run

faster it know it base on the queryies that...

you can write this query to get all the missing indexs

select * from sys.dm_db_missing_index_details

interesting script

please give a feedback

if you need the highest combination

of val1 and val2

you need to write

select top 1 *,(value1+value2) as val_sum from @mytable

Order by rowsum desc