And (missed it), Antares has even better reasons...

Heh... there's just a pot-wad of undocumented features and sprocs in SQL Server... most would warn against using them because if they're undocumented, they could disappear on the next service...

For me, it's because most things that you query are tables... for a view or a function, you might want to use the Hungarian notation to make it obvious that...

Or, you could try posting in the "Access" forum 😉

Not odd behaviour... same as what happens with most numeric datatypes...

DECLARE @Datum2 INT

SET @Datum2 = ''

SELECT @Datum2

IF OBJECT_ID('TempDB..##my_temp_table','U') IS NOT NULL

PRINT 'Table Exists'

ELSE

...

FYI... sp_MSforeachdb uses a cursor 😉

Use WITH ROLLUP... search for the correct "NULLS"...

CREATE TABLE #DirInfo

(

SubDirectory SYSNAME,

Depth...

Heh... and what better way to do that than to use FLOAT...

b_boy (11/29/2007)

---

I used the following script to create the table for the results to be inputed into the space_used table, but doesnt to work as i get the...

Heh... that reminds me of a saying...

"Even if the majority agrees on an idiotic idea... it's still an idiotic idea." 😛

Heh... thanks for that, Jason. Hope a couple of other folks take heed of that little lesson...

In the meantime, what's the best way for me to get this dried...

Heh... oh yeah... almost forgot...

"NO... I am NOT smarter than a 5^th grader!" 😛

( :blush: Wait a minute...