I'd consider invoking the package using a sql server broker queue in conjunction with a trigger on a table (some effort required) or more tactically, just a sql job polls...

I don't get the opening and closing balance figures, where/how/what is the business logic there? I would expect to have some attribute of a client or invoice that holds a...

Have you considered a trace for locks? A theory to test would be see if when the dba's run it (If they're doing so intraday), whatever's locking the process during...

is this in relation to a median over a very large dataset and what is the most performant way to return the aggregate?

the result is correct. by convention whole numbers(integers) are not padded with leading zeros, decimals are however.

yes, you can read xls files into sql server using openrowset(), it requires specific permissions and is typically used for loading data into a table.
If it were possible...

I would probably opt for a set based approach where you create a list of dates and then join them against your target dataset to pick out what you need.

two ways i could think of would be the following:
option 1.  maintain an external process in the form of a script which builds the SQL project files based on some...

Hi,

Very interesting article. However, I wasn't sure if the reason for architechting this solution was to facilitate log shipping replication for SQL 2000 and below, or as a way of...

it's true is kind of rubbish because it can't handle multiple paths. The Maintenance plan executes a command similar to the one below:

xp_delete_file 0,'+@backuppath+',N''bak'','+@DeleteDate+',1

@backuppath speaks for itself

@DeleteDate is the...

have you looked into the log shipping executables used by SQL to transfer log files when implementing logshipping?

That would be a really good way of copying as you could probably...