Wayne West (1/4/2016)

---

Steve, I'd like to see your code because I can't duplicate it. I ran the following:

DECLARE @HashThis VARCHAR(20) = 'January 1, 2016';

SELECT 'MD2' AS HashType, hashbytes('MD2',@HashThis) AS...

robert-819720 (1/1/2016)

---

Fascinating and brilliant solution Alan. I really value your effort on this.

I do believe that there is one significant caveat with the Quirky Update (just love the name it...

Hi

Thanks for scripts.

Please see code below, where I have added an IDENTITY column to each table to help determine which rows are which.

I think I need some more explanation on...

seems very similar request to one posted earlier today

http://www.sqlservercentral.com/Forums/Topic1748862-3077-1.aspx

??

please read the following document and then post back with DDL/sample data and expected results.

http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum

if you provide the setups, then you are far more likely to get a tried and...

please read the following document and then post back with DDL/sample data and expected results.

http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum

just to be clear...what records do you want returned....you have not provided any sample data so...here is a quick mock up

CREATE TABLE NurserySchool(

ID ...

Jeff...if I recall someone...

Hi...think some scripts / sample data and expected results will help please.

see here for good practice

http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

can you tell us a little more about what you are trying to do

suggest you provide some sample data and expected results

http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

seems you asked a very similar question...

this article may help you

http://www.databasejournal.com/features/mssql/using-the-rollup-cube-and-grouping-sets-operators.html

some sample data will help please

please see this post

http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

can you explain a little more as to why you allow multiple race choice....??

EDIT...seems that Luis has very kindly done the...

mm7861 (11/18/2015)

---

Yes agree that LAG LEAD cannot add rows. I've managed to amend the CTE suggestion to work how I need it, a long with the outer join approach. Basically...

ok....so will each unique asset have...