please give a feedback

--you need to give the table stracture an data i did that for you

declare @mytable table(

[int] NULL,

[value1] [int] NULL,

[value2] [int] NULL

)

insert into @mytable

select 1,2,3

union all

select 1,3,3

union all

select 3,3,3

--than you...

please give feadback if this help you or not

please give feadback if this help you or not

write

sp_help <tablename>

or

sp_help GetProgramsPrivileges

try read this

How to import shapefiles into SQL Server 2008 via SSIS

http://social.msdn.microsoft.com/Forums/en/sqlspatial/thread/81e16acd-4c5a-4b78-8592-fdc73df3c40e

try watch tis webcast

http://www.sqlis.com/sqlis/post/Sorting-data-in-the-SSIS-Pipeline.aspx

try use ssis

it take me 8 secunds on my laptop

IF OBJECT_ID(N'tempdb..#Numbers') IS NOT NULL

DROP TABLE #Numbers;

CREATE...

i did not understand the question if the how do you set var in a query you write the answer your self

declare @FirstName varchar(50)

declare @LastName varchar(50)

SELECT top 1 @FirstName =first_name...

i found i can do it with perfmon

still be intersting if it can done wite a sql job

i found i can do it with perfmon

still be intersting if it can done wite a sql job

thanks for the help !!

it work for me like this

alter proc [dbo].[MySelect](@filed varchar(max))

as

begin

declare @sql nvarchar(max)

select @sql = 'select ' + @filed + ' from...

you can use ssis for moving the data and query

i try do this

declare @SQLString nvarchar(max)

DECLARE @fileds nvarchar(500);

SET @fileds = N'@fileds_value nvarchar(500)';

SET @SQLString =

N'SELECT @fileds_value from Customers';

EXECUTE sp_executesql @SQLString,@fileds,@fileds_value='custid,custname'

the result was this

custid,custname

custid,custname

custid,custname

custid,custname

custid,custname

custid,custname

custid,custname

custid,custname

custid,custname

custid,custname

custid,custname

custid,custname

custid,custname

custid,custname