Something tells me you were trying something like this:

DECLARE @myTable TABLE (Applicants_ID INT, APPL_CURRENT_STATUS VARCHAR(2), APPL_CURRENT_STATUS_DATE DATETIME)

INSERT INTO @myTable

VALUES (1111111, 'RF', '2014-07-10 00:00:00.000'), (1111111, 'RW', '2012-06-01 00:00:00.000'), (1111111, 'AT', '2015-05-06...

Luis Cazares (7/26/2016)

---

djj (7/26/2016)

---

TomThomson (7/24/2016)

---

Jeff Moden (7/24/2016)

---

Hugo Kornelis (7/22/2016)

---

That will give...

Unfortunately sometimes non work factors forces your hand. I have shared custody of my son which restricts the region where I can work. On top of that the...

Rover

Sean Lange (7/20/2016)

---

Y.B. (7/20/2016)

---

I got a PM from an OP saying simply 'douche bag'. LOL

Granted, I'm having a really bad day and could have responded better...on the other hand...

Steve Jones - SSC Editor (7/20/2016)

---

Y.B. (7/20/2016)

---

I got a PM from an OP saying simply 'douche bag'. LOL

Granted, I'm having a really bad day and could have responded better...on...

Another difference between temp tables and table variables that I like keep in mind is that you can't refer to a table variable inside dynamic sql unless it was declared...

I got a PM from an OP saying simply 'douche bag'. LOL

Granted, I'm having a really bad day and could have responded better...on the other hand at least he...

This is too vague for us to give you an answer...

Eric M Russell (7/20/2016)

---

Which aspect of this do you need advice on?

Create a table to contain one row for each DBA along with their contact details and what days of...

+1

You won't have to worry about constraints with a bit. You can map it to whatever you want on the front...

Luis Cazares (7/14/2016)

---

I suggest that you follow the link I posted. There's a similar version of your code which runs about 4 times...

What you originally proposed isn't that complicated...

with t as (

select 1 as Comp, 'a' as Person union all

select 2 as Comp, 'a' as Person union all

select 3 as Comp, 'a'...

Package

djj (7/11/2016)

---

Y.B. (7/11/2016)

---

I just bought a brand new F-150 last week and I'm so pumped. Can't wait to get my hands on it (still waiting on delivery). Been...