This works for your sample data. It may not work for your real data. It all depends upon if you can make the row that you don't want be the...

I came up with the same query and then I re-read the OP and it seemed he did not want anything 'hard coded'. So I came up with this.

Select M.member_name,...

sql_2005_fan (6/10/2016)

---

I need to run this query also on sql 2008 database and getting the following error on 2008.

The Parallel Data Warehouse (PDW) features are not enabled.

How can I rewrite...

Your stated requirements do not match up with your expected output. This is the output of a query showing the previous endDate in the row with the startDate that it...

Misread the problem.

Of course!

I don't have any of your tables...

This little test function works for me.

CREATE FUNCTION test()

RETURNS int

AS

BEGIN

DECLARE @Result int

SELECT @Result = 123

RETURN @Result

END;

select dbo.test()

I noticed that you are not assigning anything to...

😀

Or change the delimiter to something that should not ever be in the source data like a pipe | or tidle ~.

You are using an old and deprecated join method. You need to learn to use inner and left joins (among others) and aliases. It will make your code easier to...

You are right! I blew past it on the first page.

I'm not sure I understand his objection. If he can...

macdca (3/14/2016)

---

I have date and time stored in the following format: mm-dd-yyyy hh:mm:ss

I only need the date part, and want to use a data parameter where I specify only one...

This little snippet produces your desired output.

;with cte as

(

Select code, effective, termination,

row_number() over (partition by code order by...

As you said yourself, Column2 is a DATE. Therefore, whatever you...

Check out the QuoteName function in BOL.