Don't know why you didn't have success with the methods you mention, but try this:

declare @sql varchar(400)

set @sql='select ''?''as dbname;select * from information_schema.routines

where charindex(''shipping_total'',specific_name) 0'

exec sp_msforeachdb @sql

(Assuming you want...

Your restore error message is not appearing - I think it is looking for a linked jpg file - please update your post to include it.

Backup/Restore should have no problem moving databases between servers. How far are you getting when you try this method?

As a result of using the 'distinct' keyword, duplicate records in the output recordset are not displayed. Remove 'distinct' from my query and the multiple records will be displayed.

My previous query is equivalent to the following:

select distinct b.firstname, b.lastname

from tablea a, tableb b

where contains(a.field1, ' "run" and "hide" ') and

(a.field3 = b.field1)

so that should help you understand....

Sounds nasty! First point to make is that if you do not have a shared unique identifier (or combination of identifiers) that will allow direct matching between the imported...

Something like this?

select distinct b.firstname, b.lastname

from tablea a

inner join tableb b on a.field3 = b.field1

where contains(a.field1, ' "run" and "hide" ')

Regards

Phil

Hi FenqC, your question is slightly unclear. Can you give an example of a few records in tables A and B and what you want to return? I'm sure...

Check BOL under "limitations-Analysis Services" and you'll get the info you need.

Phil

Jeez, perhaps I had one-too-many beers last night. Well spotted and I think I'll keep quiet for a while!

BOL suggests that TOP should be used:

"It is recommended that DELETE, INSERT, and UPDATE statements currently using SET ROWCOUNT be rewritten to use the TOP syntax. For more information, see...

I think you could do this using local variables - something like this:

declare @batchno int, @detailno int

SELECT TOP 1 @batchno = d.batchno, @detailno = detailno

FROM detail AS d

INNER JOIN batch...

How about this one? Going back to your very first post on this, if the table is called 'test' and your columns are 'cola' and 'colb':

select distinct 'cola' =...

select top 10

will give you the first 10 rows (and the specific rows which are returned depend on any ORDER BY clause in your query).

Eg, perhaps you...

I think you are heading towards some sort of SQL differencing tool - ie something that allows you to compare two SQL Server dbs and identify schema differences between the...