here's some of the things i could think of off the top of my head:

1. Is the query itself SARG-able?( search arguments in WHERE statements will use an index?)

look for...

without your table definition so we know what you are auditing, we cannot help much, but what you can do is simply insert into your audit table, from the sys.tables...

so, a string that happens to contain numbers then, since you included a space?

i...

SELECT 12345[highlight="#ffff11"]00000[/highlight] + ID, so as long as your Id is less than 99999, it fits your criteria.

sunil.mvs (6/15/2016)

---

we have started new team of datawarehouse in our company.

Team started working on SQL Server 2014 and TFS .

They developed packages using project deployment...

SQLPain (6/15/2016)

---

On the report a field is populated from a column X whose datatype is int. the problem is we don't if that number is a percentage or a amount,...

Lowell (6/15/2016)

---

my understanding is similar to George's:

services consume licenses, but tools and connectivity do not. that's reinforced by the same tools being part of a separate downloadable install package.

only when...

my understanding is similar to George's:

services consume licenses, but tools and connectivity do not. that's reinforced by the same tools being part of a separate downloadable install package.

only when you...

you keep missing the point about how tables do not have a natural or default order in SQL server.

they are treated as unordered rows of data.

all the rows are...

there is a paid oledb provider from cherrycitysoftware.com(since they cost $, i will not bother with a link) ; with that you could create a linked server or import via...

we need an example of duplicates making it in.

when i test, i get an error violating the PK, which would be expected.

insert into [Test_A]([V],[CA])SELECT '1','2'

insert into [Test_A]([V],[CA]) SELECT '1','2'

Msg 2627,...

ok, in that case, i would cross join the default value, and select it in the isnull:

SELECT M.member_name,

M.member_plan,

...

great job on providing sample data.

it looks like a simple isnull is needed, am i right?

SELECT M.member_name,

M.member_plan,

...

brad.mason5 (6/14/2016)

---

Anyone install latest management studio for SQL Server 2016?

Have issues with icons not displaying?

On a side note: How do you add images to the body? I add as...

it also looks to me like you could combine the WHERE statement into a single query, that might be more efficient too:

aww nevermind, i didn't notice the IS NOT NULL...