Evil Kraig F (3/30/2012)

---

Need some help here. Have occassional insert failures from a VB .NET app that checks later and finds the records missing. Errors are not properly...

Each college has their own names and requirements for majors. is there a specific college your looking at or just in general. if in general that is near...

Jeff Moden (3/30/2012)

---

As a side bar, it's always amazed me that people find importance in the order of the data in a file without actually having something in the file...

PaulB-TheOneAndOnly (3/30/2012)

---

opc.three (3/30/2012)

---

The only way to ensure the data is not scrambled when inserting into a table is to reduce the "bacth commit size" to 1. Whether bcp, SSIS or...

thats not sql? what program are you using for this. its probably a syntax error as you suggest...

a.jean89 (3/30/2012)

---

This can be kind of common...

If you have a table 'person'

in which you store Father and Mother who points on an other row in the Table.

There is a lot...

MyDoggieJessie (3/30/2012)

---

Jeff Moden (3/30/2012)

---

Careful now... that's actually been deprecated not to mention that it will...

Lowell (3/30/2012)

---

we have that in a few tables;

it's usually something like an Entity and need to to identify the "prime" entity,

an example might be a table of bank...

opc.three (3/30/2012)

---

capn.hector (3/30/2012)

---

here in my shop we have a history table that we have no PK on. we just have FK's to the pertinent data and just insert to...

Using [MMG-Events] makes for better code portability than relying on quoted identifiers being on.

it may also be DBO.sp_name not DDO. may try that before bugging the dba but if thats not it i think that is the only course of action.

here in my shop we have a history table that we have no PK on. we just have FK's to the pertinent data and just insert to it.

since it...

Duplicate post, Please continue discussion in http://www.sqlservercentral.com/Forums/Topic1275106-392-1.aspx

PaulB-TheOneAndOnly (3/29/2012)

---

amita.gham (3/29/2012)

---

I have indexes on a table. I now need to Alter the table to add 2 columns, Is there any impact on indexes, Can i alter the table...

Lynn Pettis (3/29/2012)

---

Or, just use DISTINCT:

SELECT DISTINCT

bo.BackOfficeId,

u.ID,

u.UserName,

u.Email

FROM

dbo.BackOffice bo INNER JOIN

...