Another way, which is little documented, is using the stored procedure

msdb.dbo.sp_ssis_putpackage

which will allow you automate deployment using TSQL 🙂

Another way to kick of a subscription is to use sp_start_job and kick off the job SQL server automatically creates for each subscription. The name typically has a generic GUID...

I agree, I just used a table variables so you can run this code anywhere without even needing the right to create objects in a database.

Also, I did not...

In this case I would use a simple tally table:

DECLARE @source TABLE (SegNo int, Date_Field smalldatetime, Month_Count int, Payment decimal(10,2))

DECLARE @tally TABLE (N int)

INSERT INTO @tally(N)

SELECT ROW_NUMBER() OVER (ORDER BY...

If you only have alphanumeric values on your column you can use STUFF in combination with PATINDEX to get rid of the junk:

DECLARE @teststring nvarchar(20)

SET @teststring = 'test ' +...

Won't it will break if people put the same song in there twice?