Oh Jeez... the simplicity of your solution is even more proof of your genius... I'm a bit ashamed that I didn't figure it out on my own... much like "SQL...

You, Sir, are not only a genius, but you've made my day... I tested it and that is precisely what I was looking for!

I've gotta ask, David... how in the...

David,

Seems a bit complex in light of Jan's second solution.  What was wrong with it?

Undocumented "feature"?  So what would SET @Counter = @Counter+1 be?

Hi Mike...

Perhaps this will help... do read the comments... you'll figure how to use it... could turn it into a table variable function, I suppose...

USE Master

GO

CREATE PROCEDURE dbo.sp_GetDirectoryFileInfo

/****************************************************************************************

 PURPOSE:

 This...

You can also call it from xp_CmdShell.

But, what does the VBScript you want to execute actually do?  Lot's of folks overlook the power built into SQL Server and try to...

Yep... do a backup.

You shouldn't... you should store the file name only and let the external app get the file using the file name.

You still haven't told us, Janet... why do you need to do such a thing?  Might lead to something even "cooler" if we knew...

>>Or did I misunderstand what's going on?

Just a bit, Scott... the OSQL would be executed by a scheduled "DOS Batch" process... not from SQL... that would make the SPIDs match...

Heh... yeah... When I started my post, your post wasn't there yet... I got interupted and came back to it.  When I finally did post (forum hint: I always copy...

Kinda... if you don't consider any type of rounding, the FLOAT 17 digit's in the example I gave came up with the wrong answer...

But, after re-reading your posts, I...

>> For the above if there is no backup with in last 24 hrs then it will show null.

Does that mean the query did want you wanted or not? 

Yeah... didn't even look at that part, Serqiy... just knew the outer table was the wrong one and quit there... good catch.

Heh... the "golden plate" was correct... somebody forgot to wash the glass though JacekO is correct... the method being suggested doesn't use...