if there is a trigger on your destination table, @@identity could return the identity from that other table instead of the one you inserted; that's why you need to use...

it's a tricky problem; if you give me a username and password, I can use any application i can get my grubby fingers on to connect with.

the easiest solution is...

I think the key is the expected output; if you can accept a single column with a string which contains the values, or do you still have to have up...

a key question is are their foreign keys tied to the current identitiy?

if there are, it makes it a lot harder, since you'd have to update those child foreign keys...

i'm thinking some overnight import/update process is failing; there's no "Activity record" or "Account Owner" as far as SQL is concerned; it really jumps out to me that some unattended...

looks like a business rule error in your application, not anything from SQL itself; I'd guess you have an app that is writing to the error log, instead of sya,...

i've seen this requirement before:

check out the Check Constraint example i made here, aptly named "ThereCanBeOnlyOne"

http://www.sqlservercentral.com/Forums/Topic789104-145-1.aspx

it uses a check constraint to make sure zero or one of the columns has...

a default sets the value of the column, so common sense would make you think of columns that cannot have the same value more than once.

i'd test it to be...

if there...

that is exactly why you'd want to not store a date as a number: 20091221 you can kind of read as a date, but what if the value is 20091250...

you'll want to use the GUI in SSMS;and change it to bigINT; the GUI will create a new table witht he proper structure, migrate the data, migrate all the foreign...

it depends on what your "number" is going to be;

SQL natively keeps the number of days since 01/01/1900:

select convert(decimal(12,0),getdate()) = 40167

select convert(decimal(12,4),getdate()) = 40166.5383

after the decimal point, it is the...

fill factor depends on the flavor of inserts, so it's not something that can use a rule of thumb/assumption;

for example, if the primary key of a table is date...

thanks for the input guys;

for my first pass of fixes, i used gvim, but it's not the kind of utility i'm used to...i prefer text editors that open multiple files,...

dates can seem tricky until you get used to them.

never convert a date to varchar or anything...always keep them in datetime .

this will give you the Monday of the current...