found it. looks like sometime after sql 2014.

http://msdn.microsoft.com/en-us/library/ms143729%28v=sql.120%29.aspx

Hello Sean,

Thanks for the help really appreciate it. Looks like I solved my problem by using a cursor and updating the StartDates manually and then selecting that table with...

Hello Sean,

I got what I needed I just dumped the data set into a table variable then ran a cursor to update the dates manually getting the previous rows enddate....

Yes, so when you run the select from my latest code, the second row StartDate should be the first row EndDate, then the EndDate for second row would add the...

I have been for past few hours. =) I just added + 1 for speed purposes. Appreciate the help.

Ok here is my other issue. Below is the sample data. What if the StartDates and EndDates were not stored in the table and were derived originally from...

Np thank you! I will review it. Appreciate it.

Ok thanks for the post.

here is the code to get sample data. So, my results I want the first row to be as is then second row (the ID...

Awesome thank you SQLBuddy!

Does nobody know or is this a stupid question? Please do share if it is a stupid question I can take it. =)

Found out it was a quoted identifier issue. Needed to write the table with double quotes around it. Interesting thing though is I also recreated the package with...

Found it needed to use qoutes like this. I also tried using another table name and it worked. Got to love Oracle. GRRrrr.

SELECT * from TESTDB."test2"

I got it to work, but now when I try and query the table in Oracle it says the table does not exist? But, I see the table on...

I believe so not 100% sure. How can I verify I did? I can tnsping the Oracle server fine and I have sqldeveloper connecting to the Oracle server...

thank you Evil Kraig!