I can consider that but its probably not the best solution in my situation

-There are networking restrictions between the source and target. The target doesn't know the source exists.

-I'd like...

http://msdn.microsoft.com/en-us/library/bb510625.aspx

target_table cannot be a remote table

I have tested this and it seems so.

>> How important is it that these are in an exact order?

Its not critical to the functioning of the app. Its really a matter of understandability to the end user...

Thanks!

DECLARE @retval int

EXECUTE @retval = sp_executesql @String, @params, @ID

if @retval = 0

print 'execution successful';

else

print 'execution failed';

--CREATE PROCEDURE uspSub

--@ID INT

--AS

--SELECT getdate()

--CREATE PROCEDURE uspSub2

--@ID INT

--AS

--SELECT getdate()

DECLARE @String nvarchar(4000)

DECLARE @params nvarchar(4000)

DECLARE @Procedure varchar (150)

DECLARE @ID INT

--I would like to set this flag to Y if...

>>However, can I ask a different question, why do you want to go about building the command dynamically?

I could be calling multiple procedures here in (excuse me for saying this)...

If you want to export a different set of results depending on the value of your field called ref you can accomplish this server side or package side.

Server side

-prepare a...

Brilliant. Thank you all.

Correct, sorry about that. Revised

--5

INSERT INTO #Transactions (ItemID,StartDate,EndDate) VALUES (5,'1/1/2001',NULL)

INSERT INTO #Transactions (ItemID,StartDate,EndDate) VALUES (5,'1/1/2001','12/1/2002')

INSERT INTO #Transactions (ItemID,StartDate,EndDate) VALUES (5,'1/1/2003',NULL)

INSERT INTO #Transactions (ItemID,StartDate,EndDate) VALUES (5,'1/1/2003','9/1/2003')

INSERT INTO #Transactions (ItemID,StartDate,EndDate) VALUES (5,'1/1/2004',NULL)

Thanks!

>>What exactly goes into #MyInternalList ?

MyInternalList is determined by internal business logic, it will change day to day. The external list is maintained by my vendor.

The transactions table...

I guess I could go on the assumption that if the item appears on the list a number of times that is even then it has been added and removed....

Thank you. I am looking at adding EXECUTE permissions for this user. My only concern is security issues. I believe permission on this procedure was removed when the 'lockdown' tool...

The GUI works fine with an administrative account

Using the non-privileged account and running

declare @SmoRoot nvarchar(100)

exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\Setup', N'SQLPath', @SmoRoot OUTPUT

I get:

EXECUTE permission denied on object 'xp_instance_regread', database 'master',...

Are you trying to give other unprivileged users the ability to kick off the package? If so setting appropriate permissions can be tricky. One potential solution is have the procedure...

You may find that the use of a calendar table will make you query simpler.

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html

However you get results it looks like you want to pivot the TimeLineDate field...