I'm not suggesting this is a good idea, but if avoiding dynamic sql is your only consideration then this might work.

Edit: I assumed you wanted the rest of the year...

This is a common problem with medical codes, 008.8 is not the same as 08.80.

I have always had to save as a text file, or open excel and add a...

This may or may not be relevant.

A while ago I had to set up a sql version of an oracle database(s).

I went with one sql database and multiple schemas that...

I think the only problem is the sql syntax. I was able to recreate it fine.

insert into table (Scenario)

Select @Scenario as Scenario

INSERT INTO Scenario

SELECT @Scenario as Scenario

If you dont want to switch to using a date counter, does this work?

Set @StartingMon = @StartingMon + CASE

WHEN RIGHT(CONVERT(CHAR(6),@StartingMon),2) =...

is this it?

http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/

If it completes without error, but nothing happens, perhaps its not finding the remote file. Does it complete instantly? or does it appear to download a file, but then the...

Can you include the join to the other tables in the proc?

Can you use TRY CATCH?

BEGIN TRY

ALTER TABLE tblproducts ADD isDelete bit

END TRY

BEGIN CATCH

END CATCH

Can you run the code directly on the remote server? I seem to remember getting cryptic errors from a linked server caused by syntax errors. Sometimes the data would change,...

From Visual Studio you can 'save a copy' of the package to the SSIS repository on the server. I don't know if this is a good way to do it,...

Null is not unknown. If I have a table of medical providers, the dob is null for a facility. That doesn't mean its unknown.

I chose null means null, because the...

What OS is on the box? If its XP then it has to be XP Pro so that you can run IIS, but I think it should tell you that.

Variation on the above.

DECLARE @T

TABLE (

row_id INTEGER PRIMARY KEY,

...

Can you post an example query?