With no code, no idea of the data involved, my swag is both will take...

1. Have you verified that the schemas and indexes are identical between databases.

2. Is there any difference the number of rows being insert between the databases.

3. Read...

Garadin (10/31/2008)

---

You don't need a loop, or a cursor. All you need to do is:

1. Create a clustered index on your row# column. (It is most likely...

Also curious, how big was the database you lost?

Making a guess here about nvl...

This:

sysdate between org.effective_start_date and nvl(org.effective_end_date,sysdate)

would be this:

getdate() between org.effective_start_date and isnull(org.effective_end_date, getdate())

what does this do: nvl(org.effective_end_date,sysdate)?

paul.starr (11/3/2008)

---

maybe its this line i have commented out:

how would i write this line:

--and between GetDate()org.effective_start_date and GetDate() org.effective_end_date

data types

EFFECTIVE_START_DATE ...

As you are converting from pl/sql to t-sql, is it safe to say you are also porting the database from oracle to sql server? You provided the data types...

Something is missing somewhere. I don't see anything that would cause this conversion error: Error converting data type nvarchar to float. The only non-character data type is ca.account_established_date,...

What version is MSDE? Can you connect to it with QA? If so, do this: select @@VERSION and report the results.

Here is a starting point: BOL (Books On-Line).

Lookup the following:

sys.databases

sys.tables

sys.columns

sys.types

Missing the data types for org.known_as and ca.attribute3.

You can do this by one of two ways, backup/restore or detach/attach.

If you check the code I posted, you'll see that I created a table, inserted some records, then added a column, and inserted additional records. I used the exact...

Elisabeth Rédei (11/3/2008)

---

Hi,

If you want a default value; use a Default getdate(), it you want to enforce a NOT NULL constraint; add a CHECK constraint. Or both.

You can add the...