good suggestions i will take a look.

my question is why does it work with compatibility mode 2008 not with comparability mode 2014?

because I have 100's of procs that use the declare @today datetime

I am needing to compare the data from 2 different locations.

I have a openrowset to a remote location i bring back the null values when i do a left...

much more robust but for some reason one of my columns equUK [decimal] [14,0] is coming back as equUK decimal(38,38).

ahh found it. had to change the typ.percision to col.percision and...

Alan B. Thanks make sense.

Table Data Type.?

i have sql compare, i forgot one thing. we have a time offset between hq and offices which is handled in our custom replication. example a record has a update...

Ok will do.

I have a table TagId with keys of Location and IDval

i have an audit table with keys tablename, Location, IDVAL

the table TAGID has a trigger that writes the...

just the query to get my counts back by city.

my problem is i the record i need to keep could be say row 5 of a partition (of 7). so...

the table the data is coming from. i will be updating the datedeleted field from null to getdate()

I guess the name is of my table is confusing. it is not so much a audit as a replication table.

A table that keeps track of what needs to me...

The XML is being loaded in to a staging (temp) table for use in the joining.

Separate audit table for each of the tables would at this time not viable as...

yes the individual table do have their own keys and indexes.

When a record is added or changed a proc is called to insert the base keys to the audit table.

it...

with the current design, we see no other method then as a heap.

Let me pose this additional info

we have 15 col's that are represent Keys of the tables being entered

3...