Temp Tables and Such 1

[TonyRosen]

I need to create a temp table, however, I also need to check if it exists first ...

For Example ...

If #this_table exists, just update the thing ...

Else, create #this_table, and then update it.

I know this is easy, but I just can't think it through for some reason ... it's giving me fits.

 

[RhythmAddict112]

Why not do a count, if not.eof then it exists.
ie;

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Your ConnectionString"

strSql = "SELECT COUNT(*) As 'count' FROM SysObjects WHERE name = 'Tablename'"

if rs("count") > 0 Then
The table exists
else
The table doesn't exist
end if

 

[TonyRosen]

That worked awesomely ... it appears .... thanks!

 

[RhythmAddict112]

Sure thing