Jeff Moden (11/18/2008)

---

The really good part about it all is that no matter what goes wrong, I always learn something new even if it's only how to "read minds" a...

Take a look at this post, the concept is the same:

http://www.sqlservercentral.com/Forums/Topic602485-1291-1.aspx

If you need help applying this method to your situation, please provide table DDL/sample data as inserts.

Heh, I was about to post roughly the same query, and specifically waited until you posted because I saw you reading it too :P.

If you only want citations with a date > 11/12/05 that don't exist in the table, add

AND C.Date > '11/12/2005'

to the end of Lynn's query.

Also, for future reference,...

I was counting those as gaps, even though the new enrollment period started the next day. Let me see if I can re-work it to not count those.

My final select query was wrong. It's always the little things! If that's what you were using to check all of your tests, that explains the results. After...

Here's an example. Jeff may have some fine tuning to suggest for this.

[font="Courier New"]

------------- CTE to concatenate U_soBLNo -----------------

;WITH ConcatB(DocDate, [Shipping Line],CB) AS(

SELECT QC.DocDate,[Shipping Line],STUFF((SELECT

        ', ' + U_soBLNo

    FROM

        [Query_Concat] QC2

    WHERE...

Have a look at this:

http://www.sqlservercentral.com/articles/T-SQL/63003/

[font="Courier New"]

--------------- CREATE SAMPLE DATA TABLE ------------------

DECLARE @a TABLE(

A  VARCHAR(5),

B  VARCHAR(5))

INSERT INTO @a(A,B)

SELECT 'a','x1' UNION ALL

SELECT 'a','x2' UNION ALL

SELECT 'a','x3' UNION ALL

SELECT 'b','y1' UNION ALL

SELECT 'b','y2'

-----------------------------------------------------------

------------- CTE to...

My pleasure, glad we could help.

Omair Aleem (11/14/2008)

---

Hey Thanks buddy.. yes not your fault... I'm sorry I didnt let you know that it wasnt the only thing I was working with.. but is your query...

You've been attacked by Single quotes! FIND COVER! (Sorry, it's Friday, and I need a beer)(And the Select and from's I told you to add were from when I...

Yerp, that's correct as it is. Just add a SELECT to the beginning, and a FROM, and replace the column names with your actual field names, and you're in...

So, what's the question?

http://msdn.microsoft.com/en-us/library/ms130214(SQL.90).aspx