You need to clarify.

Will the report (instance) contain data from only 1 database at a time?

Or will it contain data from N number (2-9 in your example) of databases at...

THANK YOU !! FOR POSTING THIS TIP. 

I was in the same boat, thank goodness for "exact phrase" google searches.

Here is my code...

There is a way to specify the collation with the query.  I dont have books online at work with me (I'm in an oracle place right now).

I suggest

Make sure you...

You can investiage using GUID (uniqueidentifier) as the PK (primary key) and FK (foreign key).

And look into "link servers".

You can't get a "real" PK/FK relationship accross databases.

However, you could hack...

Well.  this will help:

select * from DBXServ.pubs.dbo.titles

where DBXServ is ~~another server.

Check out the

"Identifying a Data Source Using a Linked Server Name" in Sql Server 2000 BOL.

and

"Inserting Rows Using SELECT INTO"

and

"How...

 I have the same type UDF (user defined function)

Insert into MyRealTable ( someField1 )

SELECT ITEM FROM dbo.udf_10_comma_delimited_char('abc,def,ghi,jkl' , ',' )

Its as simple as that.  The 8000 is...

YOu can try this, if you want more specific info.

I didn't write it.

Check the URL where I found the code also:

if exists

(select

if exists

(select * from sysobjects where id = object_id('dbo.udf_10_comma_delimited_char') and

Try this

The UDF is one I use alot, as alot of "old" db's use string values with a delim.  ....

This is also an intro into @variableTables, one of teh coolest...

If you had any java experience at all, then go with C# (Microsoft).

If you've had any VB experience at all, then go with VB.NET.

If you have nothing, then I'd go...

A dot net web app is a great front end to an MSDE database because of the disconnected state of the dataset.

If you have a VB6 forms app,then I'd be...

#tempTables also have nested scope.  Aka, if you call a recursive stored procedure OR you have prcA call prcB (and prcA defines the #tempTable), then prcB can use it also.

The...

That I dont' know.

Maybe you can write a VBS script to try it, and see if its a CF issue or not.

I've written one CF page in my life, to...

Whenever I have a weirdo situation, I write a UDF to handle it.

this will get you started. I wrote it up in a few minutes, so I didn't cover everything....

Maybe this can help:

if exists (select * from sysobjects where id = object_id('dbo.fnc_10_parse_string') and xtype = 'TF')

 drop function dbo.fnc_10_parse_string

GO

CREATE  FUNCTION dbo.fnc_10_parse_string( @list varchar(8000))

RETURNS @tablevalues TABLE

               ( itemid int IDENTITY(1,1)  ,...