In my opinion, it would be much tidier and easier to manage all of this if you keep all of the data in SQL Server rather than mixing your db...

Good question and one which I've considered in the past.  Seems to me that you have to limit direct access to the database (keep the only authorised users / roles...

Wow, that's a busy server – Terminal Services, SQL Server, C# development, SQL Server development and SQL Server admin!

As EM and QA work well from other PCs/servers, why don't you just...

I think you are summing across the entire resultset – so you will get the same numbers every time.  You need something more along these lines:

SELECT Merchant.MerchantId, Merchant.MerchantName, DefinedPaymentDistribution.DistributionName, PaymentType.PaymentTypeName,

Check out this link – it may help you out.

http://www.sqlservercentral.com/columnists/sjones/tamethosestringspart7.asp

There's probably a really elegant way of doing this. This isn't it, but it works 

select '$' + convert(varchar(30), cast(amount as money),1) as Formatted_Cash ...

replacing 'amount' with...

I think I would go down the multiple job steps route.  If any of the jobs fails, you'll be able to identify more quickly exactly where the process is going...

This will get you some of the way - it works in the current database, so you'd need to iterate round all the dbs you need to check.

SELECT table_catalog, table_name,...

Not sure whether you would want to do this because of data storage considerations, but if this is a query which you execute regularly, could you add a new calculated...

Just a small typo in this, should be

select id, convert(varchar(10), date, 120) from temp

Ace - that will be filed in my 'Useful SQL Utilities' folder, thanks.

Thanks v much, that's nearly exactly what I need.  But the 'Name' field that is returned appears to be the logical file name corresponding with the data/log file selected (and...

Noeld – please explain why you should not cast a datetime as int.  I have used

cast(cast(GETDATE() - 0.5 as integer) as DateTime)

with apparent success.  Just interested ... the...

I have a similar related question.  I have a script which uses a cursor to update a large number of records - is there any way of indicating progress (10...

Alternatively, after performing the delete, go into EM, design table and set the Identity Seed of the primary key to something else (eg 2) and click on Save. Then set...