Try sp_executesql

This question gets asked at least once a month usually more, I'm surprised you couldn't do a simple search to find the answer

Use Pubs

declare @SQLCommand nvarchar(4000)

declare @TableName varchar(50)

declare @myoutputRowcount...

In sql server DTS under package select save as, then save them as Structured storage file. Then send them. Then have the associate open dts select open, open the file,...

No, I would suggest you wait for it to finish.

If a transaction was running for an hour, and you killed it, it would take about an hour (generally speaking) to...

you can /may reduce the size of the file on a log shipped database.

Generally though if there are pending transactions it will not shrink very much unless you force a...

I believe that is because only c# can be used when creating code for sql 2005.

I havn't found anything to back that up though.

use sp_executesql with output parameter

CREATE PROCEDURE TEST_ROW_COUNT

@SQLeval nvarchar(2000),

@count int output

AS

BEGIN

declare @RowsReturned int

SP_EXECUTESQL @SQLeval,'N@RowsReturned int OUTPUT', @RowsReturned OUTPUT

SET @count = @RowsReturned

END

DECLARE @output as int

EXEC TEST_ROW_COUNT 'select @RowsReturned...

No

Create a source connection.

An excel destination.

Transform data task.

Select sql query.

Put in stored procedure name with parameter

Select the destination tab, DTS will interrogate the proc for the resultset, and create a...

Is this what your trying to explain

-- One table with only 3 rows?

Create table #Ref_Preference (Field varchar(50), Value varchar(10))

insert into #Ref_Preference (Field, Value)

select 'Schd_dt', 'Foo' union

select 'Plan_dt', 'Bar' union

select 'Ship_dt',...

the best/easiest way is SQL Compare it is a third party software to buy. They have a product to compare table schema and code, and also a product to compare...

Posted here.

There is no need to cross post. We usually check all boards

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=267793

Check out sqldts.com

http://www.sqldts.com/default.aspx?234

They have lots of info dts

or create a function.

use pubs

Create table mytable ([ID] int, col varchar(20))

insert into mytable ([id],col)

select 1, 'aaa' union

select 2, 'bbb' union

select 3, 'ccc' union

select 3, 'ddd' union

select 4, 'eee' union

select 5,...

Modified from code I found in the scripts section of this site.

(Sorry can't seem to find the original to give credit)

declare @DateX datetime

select @DateX = '02/12/2006'

-- First day of quarter...

select *

from #TestX

where AuditID in (select max(AuditID)

                  from #TestX

                  Group by ws_Num)

Results

129 F52A 3818

180 BC102A 4182

204 BH130A 7877

Do a search on "Trees in SQL" "Nested Sets" or Expanding Hierarchies on this site or google, you will get lots of info.