Had some time so I added my Dynamic solution. Note that I forgot to add the column names in my first example but it looks like Luis had you...

A simple Unpivot works but if you don't know how many columns there can be you will need to look at a Dynamic Query.

DECLARE @test-2 TABLE (colx VARCHAR(8), coly VARCHAR(8),...

I suspect we might need a little more information. When I read

I'm thinking all you want...

pwalter83 (12/4/2015)

---

pwalter83 (12/4/2015)

---

GilaMonster (12/4/2015)

---

The TIME data type stores a time of day, not a time interval. Since a day has only 24 hours, that's the max that TIME can store...

Here are a couple of examples but I highly recommend you read up on string functions.

https://msdn.microsoft.com/en-us/library/ms181984.aspx

DECLARE @time VARCHAR(10) = '25:10:20'

--Lazy way & will break if pattern is different

SELECT

CAST(SUBSTRING(@time,1,2) AS INT)...

Oh man is it ever! LOL

https://msdn.microsoft.com/en-CA/library/ms191320.aspx

Google is your friend. 😉

Ok, try something like this:

DECLARE @RefInfo TABLE (schoolid int, ColumnID int, Value varchar(100))

DECLARE @test-2TABLE (schoolid int, ColumnID int, Value varchar(100), insertedDate Date)

INSERT INTO @RefInfo VALUES (1000,1,'PRI'),(2000,1,'PUB'),(3000,1,'SEMI-PUB'),(4000,1,'SEMI-PRI'),(1000,2,'ENG'),(2000,2,'MUSIC'),(3000,2,'ARTS'),(4000,2,'ENG')

INSERT INTO @test-2 VALUES

(1000,1,'2001-01-01','2005-12-31 00:00:00'),

(1000,1,'2002-01-01','2006-12-31...

Here are a couple of examples:

DECLARE @RefInfo TABLE (schoolid int, ColumnID int, Value varchar(100))

INSERT INTO @RefInfo VALUES (1000,1,'PRI'),(2000,1,'PUB'),(3000,1,'SEMI-PUB'),(4000,1,'SEMI-PRI'),(1000,2,'ENG'),(2000,2,'MUSIC'),(3000,2,'ARTS'),(4000,2,'ENG')

--USING CROSS TABS

SELECT

schoolid,

MAX(CASE WHEN columnID = 1 THEN value END) AS funding,

MAX(CASE WHEN...

Luis Cazares (11/11/2015)

---

yb751 (11/11/2015)

---

Well I just finished talking with our Dev team and I realized that the attributes do not need to be updated individually. Also any searches would...

Well I just finished talking with our Dev team and I realized that the attributes do not need to be updated individually. Also any searches would be offloaded by...

Alvin Ramard (11/11/2015)

---

I'm not 100% sure of exactly what your situation is, but it looks like you should keep on using that key values pair table. Just make sure you...

Brandie Tarvin (11/5/2015)

---

Grant Fritchey (11/5/2015)

---

GilaMonster (11/5/2015)

---

PowerBI is very...

You can also just right click on the DB in question in SSMS and select reports -> Disk Usage. If you have any Autogrow or even (yikes) Authoshrink events...

Well I agree with you on...