Quite good, but there's a small problem: in a few places where specifying the @dbname you should enclose it in [], to avoid problems when dbname is contains spaces... like...

Hi, I've already rated this as excellent, though (adding to what kselic said) surrounding the dbnames with [] is mandatory because you can have dbnames with various issues, like 'REGISTER...

Yes, you're right, but you know, it was only my first half of the workday, the second half should be holiday... 

Sorry, maybe I did'nt read very well... but for me it's around 10PM... still working (or better said learning from people on this forum...)

Hi,

not to be too pedantic, but it seems to me that the real problem is to explain to Igor that you can build all those 'CREATE something' scripts, put each...

Thanks again, Frank, very interesting...

Gigi

Hey Frank, I tried.... but to no avail, the only result was an EMPTY (search like) page from groups.google.de.....

Gigi

You said:

What if someone sells a product whose only purpose is to kill people? Should they be shut down?

think only about bombs and all that stuff, that's made for...

This is only to clarify the error message (the answer to your question was perfectly addresed by stephenkendrick ...)

In your query you use:

Sum(CAST(([Col014]/60)...

A different approach could be:

- MOVE the tables from Access to Sql Server

- change the Access application mdb to LINK tables (via ODBC) to the Sql Server, after using the...

After confirming what Frank says about 'resentation issue...' I just add that sometimes a 'vb format in tsql' can be usefule...

So take a look at:

http://www.novicksoftware.com/UDFofWeek/Vol1/T-SQL-UDF-Volume-1-Number-48-formatnumber.htm

HTH

Gigi

IMHO, maybe the problem lies in the 'LIKE' used to build the Sql stmt that searches your value...

The script has:

SET @VAR3=N'IF EXISTS( SELECT 1 FROM '+@VAR1+' WHERE '+@VAR2+' LIKE '''+

     ...

Adding my 0.1c to AJ Ahrens work...

Why not

SELECT FD.[ID], PG.Program + (CASE WHEN PG.Program IS NULL '(empty)' ELSE '' END)

  FROM Fund                     FD

    INNER JOIN ProgramFundsList PF ON...

Just to add 1c to Steve's words.....

If your string contains any SINGLE quote you should change it from A SINGLE QUOTE to TWO CONTIGUOUS SINGLE QUOTE, as in:

Dim strSQL As...

If you're doing this in a stored proc you could try, instead of:

DECLARE Qrecipient CURSOR FOR @Qry.

the following:

DECLARE @Curs varchar(8000)

SET @Curs = 'DECLARE Qrecipient CURSOR FOR ' + @Qry

EXEC (@Curs)

HTH

Luigi