Does ID_old need to hold the previous ID's value after migration?

And the foreign key is ...

BirdsCensusSpeciesInfroM.BirdsSiteInfro_ID ties to BirdsSiteInfroM.ID

And I assume you'll be able to do this when there is...

Right click on the tables and select SCRIPT TABLE AS > CREATE > New Query window. 😀

I must admit, I only just now "re-found" the Subscribe To Topic under Topic Options. Man it's been a long...

ORDER BY

Post some DDL (Data Definition Language) a.k.a CREATE TABLE scripts of the source and target tables please.

I have some code handy that will help. 😀

I was taking the approach that if the OP had to type out the requirements, that it might help them see the error in their ways. :-/

SQL Kiwi (1/25/2012)

Whoa! This is a stop-and-start-again situation I am afraid. The code looks like it is based on some...

Read the article referenced in my signature please.

OOPS!

SELECT ID, AddedBy, Title, Path_String

FROM MyTable

WHERE...

SELECT ID, AddedBy, Title, Path_String

FROM MyTable

WHERE

Path_String Like @Paramter + '%'

Jumping in because I want to know too. 😀

Statistics?

I assume the report actually renders fine, but doesn't return the expected results.

Have you ran profiler? 😛

Some DDL and sample data would help. 🙂

EDIT: And what are your expected results?

So what time is 1065 ?

DECLARE @times TABLE

(timeValue VARCHAR(5))

INSERT @times (timeValue)

SELECT '745'

UNION ALL SELECT '1115'

UNION ALL SELECT...