First some sample data:

USE tempdb; -- a safe place for testing on a dev/sandbox instance

GO

-- create table for storing sample data

CREATE TABLE dbo.TableA

(

AssetName nvarchar(50),

AssetID...

First, Welcome - you've definately come to the right place. SQLServerCentral.com is a goldmine.

Ditto everything Eric said. I would also highly recommend:

Star Schema The Complete Reference

Next, regarding the...

I've always found that error to be misleading and is usually a result (in my experience anyhow) of not including a record for a non-nullable column. This will give me...

Me: "OK, I'll do it. You don't have to keep reminding me every 6 months!"

Unfortunately the wife and I don't always find the same things funny. :ermm:

Welcome to SSC!

I'm still not 100% clear on what the output should look like and this solution might not be complete but it's a start...

DECLARE @sampledata TABLE(ip varchar(12) NOT...

NewSSAS (12/12/2016)

---

Thanks Alan. I appreciate your explanation and I agree with you.

It worked when I removed the DECLARE and Set from the query and I am trying to set the...

Yes - this logic should be put into a stored proc. What the stored proc looks like will depend on what you are doing with @Current_College_year & @Prior_College_year.

If these...

Indianrock (12/9/2016)

---

I've heard this advice everywhere. Don't do things to change the way the sql optimizer produces plans etc. "it's smart so don't use plan guides, query hints,...

sgmunson (12/8/2016)

---

Alan.B (12/8/2016)

---

Ok, say I have two tables table1 and table2 and I want to find records from table1 that don't exist in table2 or vise-versa. I could use EXCEPT...

That FULL JOIN solution was what I'd seen before - The HAVING solution works just as well. Excellent work, thanks Luis!

On a similar note, I really like CONCAT (available for SQL Serve 2012+) because it's cleaner and circumvents the need to do any casting/converting when dealing with numbers.

DECLARE @table...

Ditto.

Doing some code cleanup today, running into lots of this

insert into <someTable>

select <a bunch of stuff>

...

Manic Star (12/8/2016)

---

Luis Cazares (12/8/2016)

---

Ed Wagner (12/8/2016)

---

Revenant (12/8/2016)

---

Kaye Cahs (12/8/2016)

---

Manic Star (12/8/2016)

---

crookj (12/8/2016)

---

Brandie Tarvin (12/8/2016)

---

Stuart Davies (12/8/2016)

---

Ray K (12/7/2016)

---

whereisSQL? (12/7/2016)

---

Manic Star (12/7/2016)

---

Ed Wagner (12/7/2016)

---

djj (12/7/2016)

---

Luis Cazares (12/7/2016)

---

Ed Wagner (12/7/2016)

---

DamianC (12/7/2016)

---

Revenant...

You don't need coalesce here. NULL values are neither equal nor unequal when compared to other because NULL is unknown. Does a bag with an unknown number of apples have...