Something like this...

DECLARE

@BegDate DATE = '2016-01-05',

@EndDate DATE = '2016-06-22';

WITH

n (n) AS (SELECT 1 FROM (VALUES (1),(1),(1),(1),(1),(1),(1),(1),(1),(1)) n (n)),

cte_MonthStart (MonthBeg) AS (

SELECT TOP (DATEDIFF(mm, @BegDate, @EndDate) +1)

CAST(DATEADD(mm, ROW_NUMBER()...

SET ANSI_PADDING (Transact-SQL)

This is a situation where a function will actually out perform a permanent tally table...

The function...

CREATE FUNCTION dbo.tfn_Tally

(

@RowCount INT

)

RETURNS TABLE WITH SCHEMABINDING

RETURN

WITH

n (n) AS (SELECT 1 FROM (VALUES (1),(1),(1),(1),(1),(1),(1),(1),(1),(1))...

You have 2 columns that have the ANSI Padding turned off in the middle of the table.

Just think about what you're asking SQL Server to return to you... If...

rocky_498 (9/28/2016)

---

I am using AND not OR. Correct me If I am wrong.

WHERE CID IS NOT NULL

AND MID IS NOT NULL

This means when both conditions met

if my query is...

rocky_498 (9/28/2016)

...

SELECT * FROM Null_Table

WHERE CID IS NOT NULL

AND MID IS NOT NULL

Note:- Please help me to understand, I should receive 3 records after I run the final query, why...

valeryk2000 (9/27/2016)

---

Thank you. However the task may be more complicated: in some cases there is more than 2 IDs (check 10011580, 10014918, just for example, in my table posted @...

Here are two solutions... The 1st will work in 2008 & 2008R2. The 2nd will work with 2012 and above...

Note: The full script, including the creation & population of test...

Srl832 (9/27/2016)

---

Yes, exactly. I couldn't think of a way to bind them together. I mean the method you proposed certainly works but it's that manual work of typing the...

Your problem is that you have nothing to bind the row groups together. Take a look at what I did below by adding a "SetNum" column to the data...

Once...

Almost sounds like you should actually post representative sample data and the expected results based on that data...

Forum Etiquette: How to post data/code on a forum to get the best...

To reiterate what Phil & Grant said... Answering questions here on this forum...

I can't speak for anyone else but I've learned an incredible amount here on this forum... Answering other...

Why not simply TRUNCATE the table?

If you want all of the data...

WITH

cte_temp AS (

SELECT

rn = ROW_NUMBER() OVER (PARTITION BY t.[Date], t.[Type] ORDER BY t.[Value]),

t.Date,

t.Type,

t.Value

FROM

#temp t

)

SELECT

[Schema] = MIN(CASE WHEN t.Type = 'Schema' THEN t.Value...