Lynn Pettis (11/30/2015)

---

Alvin Ramard (11/30/2015)

---

Lynn Pettis (11/30/2015)

---

Pulling hen's teeth, but based on what little detail you have been willing to provide, does the following help?

create table dbo.FirstTable(

...

I know we are stock piling silver spoons in the Tent in the Desert, but have we found a reliable vendor for crystal balls? Looks like we need to...

Alvin Ramard (11/30/2015)

---

Lynn Pettis (11/30/2015)

---

Pulling hen's teeth, but based on what little detail you have been willing to provide, does the following help?

create table dbo.FirstTable(

ColA int,

...

Lynn Pettis (11/30/2015)

---

Alvin Ramard (11/30/2015)

---

Sean Lange (11/30/2015)

---

Yeah...

Pulling hen's teeth, but based on what little detail you have been willing to provide, does the following help?

create table dbo.FirstTable(

ColA int,

ColB...

Alvin Ramard (11/30/2015)

---

Sean Lange (11/30/2015)

---

Yeah that question...

And what if the non null...

Sean Lange (11/30/2015)

---

Yes when doing a LEFT OUTER join the OUTER keyword is optional...but this discussion is about somebody...

Welsh Corgi (11/30/2015)

---

If you have on Index with Column A and another Index with Column A and Column B can't you just have the Index with Both Columns as long...

To give you a head start on me, here are a couple of articles that may help:

http://sqlmag.com/t-sql/intervals-and-counts-part-2

https://www.simple-talk.com/sql/t-sql-programming/calculating-gaps-between-overlapping-time-intervals-in-sql/

NJ-DBA (11/30/2015)

---

Hi Lynn,

I did include the DDL for the table directly in the post... I was asking kind of a generic question about the approach to the problem, not really...

NJ-DBA (11/30/2015)

---

This is a tricky one (for me anyways). Would appreciate any ideas on how to do this most effciently.

Let's say I have a table defined as:

Create table queue...

tt-615680 (11/27/2015)

---

Thank you for your reply, I'm running the following sql permission query which works fine on all other servers, the only difference is that a few of the databases...

caa (11/25/2015)

---

Here you go:

0x1: Published for snapshot or transactional replication

0x2: Subscribed to a snapshot or transactional publication

0x4: Published for merge replication

0x8: Subscribed to a merge publication

0x10: Functions as a distribution...

Interpreted:

I have no idea what you...