Thank you for your help on this, but I'm having a hard time using the script... please don't kill me.  How would I use it if @ProductCode is from a...

The reason is that, I would also like to use this script in SQL Server 2008 and LEAD() function is not available in SQL 2008.

HI

Thanks for the reply.  Is it possible to do this without creating a function?

Thanks,

Hey Lowell,

Thank you for your help!  db_id is actually 7.  After I changed it, it worked.  I actually like your query, so I'll be using it since it...