Here is another method. Again , Thanks for the Setup BOB!

;WITH CTE(RecID , RecType , Hierarchy , Msg,R)

AS

(

select RecID , RecType , Hierarchy , Msg, ROW_NUMBER() OVER(PARTITION BY RecType ORDER...

Another variation of the same functionality but with much faster code

;WITH ORDERED_TABLE (ID, period1, R1, pname1, R2)

AS

(SELECT ID1

,period1, ROW_NUMBER() OVER(PARTITION BY ID1 ORDER BY...

Thanks, NewBeeSQL

Jinx-640161 (4/29/2010)

---

I get a syntax error in the insert statement - it does not like :@SERVER_DB1.dbo.sp_msforeachtable

The error I get is: Incorrect syntax near '.'.

Can one use a variable like...

Beuatifully asked question and i-hope-it-is-beautiful code 😀

Here you go

;WITH perid_CTE (ID, c1, c2, c3) AS

(

SELECT ID1, [1] PERIOD1,[2] PERIOD2,[3] PERIOD3 FROM

(SELECT ID1, PERIOD1, ROW_NUMBER() OVER(PARTITION BY ID1 ORDER BY...

jwellington (4/29/2010)

---

Hi ColdCoffee,

Thanks for your post. I understand your frustration. Thanks so much for the information you have helped me with so far. It has certainly put me on the...

Wellington, as i had already asked, i need to see the records in your table (i dont want your orginal data, you may very well cook-up data that looks similar...

Ok, as you have decided to forgo the date fomat, it becomes my duty to provide you the code that will replace NULL dates with 'N/A'.

Here is that final (presumably...

My pleasure, explaining and learning with you, George!

Welcome, Mithun!

Oh Oh.. thats what..i was scratching my head to find this out.. Thanks Peter 🙂

Peter, i have got one doubt actually.. not related to the OP's request, but general doubt..

in your code , you have given the INSERT statement as

INSERT INTO @MissingNumbers

VALUES (1),(2),(4),(5),(7),(8),(11),(12),(13),(15),(17),(19),(20)

When i...

Hi Buddy,how about you going through this following article and helping us help you?? 🙂

CLICK HERE FOR FORUM POSTING ETIQUETTES - JEFF MODEN[/url]

When u do so, i am sure a...

Yana, you will have to use Dynamic SQL if you are unsure of the start and end dates.. Here is that piece of code..

SET NOCOUNT ON

IF OBJECT_ID('TEMPDB..#SomeTable1') IS NOT...

My pleasure, Harvey 🙂