As Sean indicated, formatting your code helps make it legible to humans. Computers for the most part don't care about white space (unless you are working with Python, where...

select memberid, membername

from member

group...

The question becomes, which of us gets three first. ...

Not sure about either, I just play.

Sign me up for next year.

That could be the issue. Plus, looking up the db_ddladmin role, it doesn't appear to have alter permissions to tables, procedures, functions, and a few...

Is the individually attempting to make changes to a table that has data or to empty tables?

Only if the data in the BIGINT columns will convert to INT. If the values exceed the range of allowable values in an INT column, the conversion from BIGINT...

Going back a few employers I combined Current and Historical data into the same tables when downloading and importing data from our ISAM databases into SQL Server. Doing this...

Looking forward to next year!

Darko Martinovic (12/19/2016)

---

Hi,

Thank you for your observation :-).

I haven't emphasized enough scenario for using this utility.

Visibility of this button should depends of your application rights.

Usually only...

You are welcome.

I am in the process of trying to learn how to shred XML for importing data into our system. It is getting interesting as...

Eirikur Eiriksson (12/18/2016)

---

Jeff Moden (12/18/2016)

---

You just can't believe all the examples I've been through in the last 24 hours never mind the ones I've seen over the last decade or...

Only issue I really have is that the user can control if the trigger fires or not. Since this is basically an audit feature the users should not have...

May have been a lot of typing, but then I built it step by step:

set nocount on;

set statistics time on;

with BaseDate as (

select DATEADD(day,datediff(day,0,getdate()),0) BaseDate

), WorkingDate as (

select

Today = DATEADD(second,datediff(second,BaseDate,getdate()),BaseDate)

from

BaseDate

),...

Indianrock (12/16/2016)

---

Regarding the modifications Lynn Pettis made to the OP query. I attached the plan.

------LYNN PETTIS CHANGE

-- 92 rows in QA in 03:29 first run 10...