Try

select convert(decimal(9, 2), DD_INSTALL_AMOUNT)

This is fairly easy to write from a table.  It is hard to describe in abstract.

I usually have to use a subquery embedded in a subquery that identifies uniquely the first...

If you had a table that had all of the keys in it, you could iterate through that table, delete all of the records based on that key, then delete...

Try

UPDATE clean SET branchid = branches.branchid

FROM clean inner join branches on clean.ppi = branches.ppi

There is too much detail to weed out.  Let's say I have an incident table with an action.

create table incident (incidentid int)

create table action (actionid int identity(1,1) , incidentid int,...

goPackage.SaveToSQLServer "(local)",,, DTSSQLStgFlag_UseTrustedConnection

select count(*) from

table1 inner join table2

on table1.name = table2.name

where table2.job = 'driver'

Set nocount on

declare @results varchar(8000)

select @results = isnull(@results + ',', '') + inventoryname from inventory

inner JOIN InventoryUsage

on Inventory.inventoryID = InventoryUsage.inventoryID

and Inventory.InventoryVersion = InventoryUsage.InventoryVersion

inner JOIN inventorysale

on inventorysale.InventoryUsageID = InventoryUsage.InventoryUsageID

and InventorySale.InventoryUsageVersion =...

You absolutely have to comment out or delete the following line:

goPackage.Execute

This is what executes the package and you don't want this to apply.

First of all, how do you run the VB code?  I usually use MS Access.  I create a module, then I paste the code in.  You may need to fix...

select Country, count(*) as NoOfMatchesPlayed,

  sum(case when MyScore > OppScore then 1 else 0 end) as Win,

  sum(case when MyScore < OppScore then 1 else 0 end) as Loss,

  sum(case...

The only way that I can think of to do this (and I haven't tested it) is to have a second job that runs every five or so minutes to...

I would suggest that you post this on a .Net framework or ASP.Net user group.

The application doesn't need to get input from the user does it?  Message box, console application waiting for hit return.

Check this out:

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