Strommy :laugh:

I like the "random join" the most.

That's a trick question, alright. But don't get so upset you didn't answer it correctly - I didn't either. My thoughts went something like "A predicate for joins that I...

Thanks Doug,

The trouble happens when I try to assign the "SourceObject" of a subform as some view/query. I tried to use "dbo.*" and "SomeUser.*" schemes but may be didn't try...

Thanks JJ,

It seems I can't figure out the connection string but may be this is because I'm using an ADP.

In Access 2003 project connected to SS2000 you can use the visual query builder of Access - for example to give the opportunity to your users to query quickly (without...

JJ B you wrote:

For example, on start-up, I have some code that loops through pass-through queries and links to the relevant databases for each query... The code for setting connection...

If you have a subscription for SQL Server Magazine there is an article by Ben-Gan:

http://www.sqlmag.com/Article/ArticleID/94376/sql_server_94376.html

where he compares several different methods of creating a sequence of integers placed in a...

It would be nice to put links in this old article to articles you published (later)which deal with SS 2005. And links to articles about fixed database roles and server logins ...

I meant using something like

select ..., CAST(datevalue AS varchar(10))  as strDate, ...

Glad to be helpful.

On the other side, there should be a better way to access user variables in queries. What if I want to use the same variable more than once?...

I am not sure if I understood correctly this:

Parameter Mapping = Variable Name User::FlatFileName, Direction Input, Data Type VARCHAR, Parameter Name ?

but the "Parameter name" in your...

It seems to me you should use a parametric query, i.e. replace the variable by a question mark (?), and then map your variable to a parameter (say 0). This...

I don't know if the above use of parameters is a bug but the way I solved the problem is to save the values that go into the parameters into...

Well, I am retracting my claim ... The schema described above works - I was just mixing statements which work in a sql script but are not quite legal in a query. A...

I am inserting some values from the files I read into a table - but this works. Where the SQL task breaks is when I want to get my grip...