Your sample data looks good. But the results set is simply the sample data directly SELECTed out of the table you provided.

You need to give us consumable sample data...

Steven Willis (7/31/2013)

---

If you ever use dynamic SQL using the built-in system function 'sp_executeSQL' and try to use an OUTPUT parameter the function will not work unless you explicitly append...

Sounds like you have what is called an adjacency list with people/houses and you may be able to resolve this with a recursive CTE (or perhaps not).

Two questions:

1. Do you...

For display purposes these 2 results would be identical (except of course for the specific words):

SELECT 'THIS IS A VARCHAR STRING', N'THIS IS AN NVARCHAR STRING';

There may be a slight...

Sean Lange (7/31/2013)

---

dwain.c (7/30/2013)

---

I love SQL bin-packing problems! Hate to disagree with you Sean but they don't need to be overly complicated.

Before I suggest a solution, shouldn't the answer...

Here's another approach for your dissection table:

with SCC_CTE(VENDID, VENDTYPE)

as (select 'ABC', 1 union all

select 'ABC', 0 union all

select 'ABC', 0 union all

select 'XYZ', 1 union all

select 'XYZ', 0 union all

select...

Rakesh.Chaudhary (7/30/2013)

---

Hi,

I want to put results into excel from Sql script , In results it is having three different result sets returned

Like as below.

Select * from...

Here's an example that processes 100 random integers up to 3-tuples with target value of 100. It takes less than 3 seconds to run on my box.

DECLARE @t TABLE...

I love SQL bin-packing problems! Hate to disagree with you Sean but they don't need to be overly complicated.

Before I suggest a solution, shouldn't the answer be 4, 6...

Just wanted you all to know I appreciate the research you've done and I haven't absconded from this thread. Merely lurking until I have something of value to add.

That is my 45kg Mekong Catfish! Not a record by any means (they grow well over 100kg) but a record for me.

And you're...

Steven Willis (7/29/2013)

---

dwain.c (7/29/2013)

---

I like it. I'm trying to think of a way to incorporate it in my signature.

Reminds me of the...

I like it. I'm trying to think of a way to incorporate it in my signature.

Reminds me of the quote ChrisM has...

Your expected results are off for the <30 days column (can't be less of a percent than <20 days), but something like this should do it:

SELECT datein

...

Oh my! The word is out.

And here...