It'll delete records associated to users with a created date prior to the timestamp being used.

Have you tried doing an inner join between a few of these tables to...

Just because you're deleting records that are linked to another table, nothings to say there might be records in the other tables are are inconsistent/incorrect. For example, what if the...

When you subtract X days from GETDATE(), you will get a residual number of hours, minutes, milliseconds etc depending on how far through the day you are.

If you want to...

Sounds like something hellish in the making. Your post indicates you want the leftmost column with a Y in to be 1 and all other columns on that row to...

An alternative syntax to achieve the same for all tables and views in a schema would be:

GRANT SELECT ON SCHEMA:DBO TO user_or_role_namehere;

I'd originally written this as a pair of CLR functions and used Geometry/Geography, but found little/no benefit in terms of performance/readability - it actually ended up being a lot more...