I have used DTS (in the past) and SSIS to migrate date from Oracle to SQL Server.

The largest was only about...

Subrata Bauri (7/15/2011)

---

GilaMonster (7/15/2011)

---

Dear Sir,

I will add a Column Like Entry No. and define it as Primary Key in the Table. I will increment the value of this Column at...

I just tested a DDL Rollback on a Create Table Statement and I was able to Rollback the Transaction.

GilaMonster (7/15/2011)

---

The one case that comes to mind is a staging table. If I'm importing data from some other system and I know that it's got data integrity issues, I'll...

GilaMonster (7/15/2011)

---

That question is tagged Oracle and the answers are Oracle-specific. Can't draw...

Just to add to what was already said you can go into add/remove programs and looking for Microsoft SQL Server 2008 (Server) and several other options.

But if you see the...

Yes the Identity value...

I believe that you are refering to the following issue:

SQL Server Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <=...

Jayanth_Kurup (7/15/2011)

---

Enforcing primary key on a table is purely a design decision , while sql doesn't force it; it allows suitable substitutes in columns such as identity columns , timestamps...

Do DDL statements always give you an implicit commit, or can you get an implicit rollback?

http://stackoverflow.com/questions/730621/do-ddl-statements-always-give-you-an-implicit-commit-or-can-you-get-an-implicit

Why not Dear Ma'am? 😀

In most cases it is undesirable...

Check and update your Data:

SELECT PiData.Date, PiData.Assoc_Name, PiAssoc.MgrName, PiData.Func_Name, PiData.Total_Proc,

PiData.Prod_Hrs, PiData.Paid_Hrs, Total_Proc/Prod_Hrs AS PPH, PiFunc.PPH_Goal,

PiData.Prod_Hrs/PiData.Paid_Hrs AS PTP, PiFunc.PTP_Goal

FROM tbl_PI_Functions AS PiFunc

FULL OUTER JOIN tbl_PI_Data AS PiData ON PiFunc.Func_Name...

You may want to double check the steps?

http://msdn.microsoft.com/en-us/library/ms186354.aspx

I forgot to mention that I resolved this issue. I got so many responses that I could not keep track of them. 🙂

Regards,

WC