Thought it might be worth adding some bulk test data:

-- You'll need Jeff Moden's Tally table for this http://www.sqlservercentral.com/articles/T-SQL/62867/

TRUNCATE TABLE [dbo].[OfficeCounty]

DELETE [dbo].[County]

DELETE [dbo].[Office]

-- Generate 26*26*10 counties (10 counties...

Lynn Pettis (6/4/2015)

---

Jonathan AC Roberts (6/4/2015)

---

The reason a semicolon is required before the WITH in a CTE as that WITH has two uses, it can be used for hints e.g....

The reason a semicolon is required before the WITH in a CTE as that WITH has two uses, it can be used for hints e.g.

SELECT * FROM MyTable WITH...

asushil (5/15/2015)

---

Interesting Solution way back i was looking such solution for printing bar Code Labels for given no of item for given number of times.

some expert gentlemen on MSDN...

But it doesn't do the same thing. The function I wrote displays the value of an int in...

To do what?

Mark D Powell (4/28/2015)

---

Unless I typed over the comment by accident there is an error in the comments since BitsIn returns 4 for an input of 15 while the comment...

Well it probably is bit of an obscure/esoteric thing to do but one of the most efficient ways of storing items that are switched is in a bit string within...

Michael Meierruth (4/28/2015)

---

Jonathan AC Roberts (4/28/2015)

---

~ is the T-SQL's bitwise NOT operator. It inverts all the bits in an integer.

It's used so the right-most bit, which is set to...

~ is the T-SQL's bitwise NOT operator. It inverts all the bits in an integer.

It's used so the right-most bit, which is set to 1 two's compliment signed integer...

There might be the odd special situation where this is a good idea and will work but from what I can see you need to rely on there being a...

If you make all the FK's ON DELETE CASCADE you can just delete small batches of rows from the Sample table. You would need indexes on the SampleID columns on...

Normally when an example is given using values A, B and C they should be taken as algebraic variables who's contents can change. More like this example:

DECLARE @a...

Alexander-449406 (6/6/2014)

---

I have generated test data with 1 000 000 000 000 000 000 000 rows and according to my tests all the queries proposed run within 1 second. You...

This script may be ok to use on some occasions but if the entry of the parameters is from an external input, e.g. a web page, then it could be...