Hi,

I think that I understand what you're after; something like this:

SELECT DB_NAME() AS DB, SUM(CAST(size/128.0 as DECIMAL(10,2))) AS Size_in_MB

, SUM(CAST(FILEPROPERTY(name, 'SpaceUsed')/128.0 AS DECIMAL(10,2))) AS Space_Used

, SUM(CAST(size/128.0-(FILEPROPERTY(name, 'SpaceUsed')/128.0) AS DECIMAL(10,2))) AS...

... I'm not a squid, but I am a genuine UK scaly-back (basically I fixed radio kit instead of being shot...

Speaking off offshoring, I took a call a couple of weeks ago from a company who asked if I'd like to outsource my SQL development to India. It all went...

If that's true, Steve, then we're better off in IT than journalism... One industry comparison down, how many does that leave?? :hehe:

Of course it's taking 3 minutes... It's got to format 12 reports!!! :crazy:

Jeff,

Here's a link to Googles Earth Hour effort....

http://www.google.co.uk/intl/en_uk/earthhour/

And this one's for the official blog saying that it may actually use more energy!

http://googleblog.blogspot.com/2007/08/is-black-new-green.html

This is not really DTS, but what the hey....

You must understand that eleven sub-reports are going to take some time to load the data from the procedures and apply the...

Jeff,

Thanks! Although I will watch out for my typos before future postings! 😀

You'd have to nest your IIF statements like this:

IIF(.., .., IIF(.., .., ..))

Hi,

You could use Dynamic SQL to do it. Something like the following

DECLARE @tableName VARCHAR(30)

DECLARE @newValue VARCHAR(30)

DECLARE @sql VARCHAR(2000)

/* Set Values */

SET @tableName = 'myTable'

SET @newValue = 'changeToThis'

/* Build Update statement...

Hi,

The account that SQL Server runs under will need permissions to the folder and the following should give you a good example of how to do it:

SELECT *

...

Thanks. It was the table1.date1 is less then table2.date2 that I'd missed.

😀

Thanks Jeff, I'd missed that completely.:blush:

Is there a better way than just adding CASE statments to filter these correctly?

Ade.

It's a tough call, it's one of those things that can swing either way depending...

Hey no problem. During one contract a few years ago, that was all Excel and Access... Can't say I'm sad not to be working on that any more!! :hehe:

I think...