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...

Update and select statements are separate and exclusive in T-SQL and as far as I know there is no single statement that will do both. Can you give more...

Lots of good points highlighted and looking forward to reading part 2.