you rock Jim.

I just found other way.

Select

reverse(substring(reverse(PATH),charindex('/',reverse(PATH)), charindex('/',reverse(PATH),charindex('/',reverse(PATH))+1) - charindex('/',reverse(PATH))+1)) as foldername

FROM table

Besides finding the Position of the folder. i would like to display the name of the folder from the LEVEL3

the output should be: /folder2/

Thanks Craig. i am trying to debug into this code from long time.But i am unable to figure it out.Thanks for the info. I will try to debug line by...

Great Suggestions!

Thanks,

Sahasam

Thanks Lowell..That helps..

This is generic Question.

If you get a chance, please go through the link to view some videos by Microsoft mentors.

http://sqlcat.com/presentations/archive/2009/05/02/designing-and-tuning-for-performance-your-ssis-packages-in-the-enterprise-sql-video-series.aspx

Hope this helps.

Thanks,

Suman..

Guys,

I came up with a solution.

DECLARE @STARTDATE DATETIME

SELECT @STARTDATE = '01-JAN-2001'

SELECT DATEADD(MM,NUMBER*3,@STARTDATE)-1

FROM master.DBO.spt_values

WHERE TYPE = 'P'

AND number between 1 and (( DATEDIFF(YY,@startdate,getdate())+1)*4)

...

I want to display all those quarter end dates for the past 10 years.

Current year should be Year to date quarter

and all past 9 year quarters.

Example: output should look like...

Hey Wayne,

I need Quarterly dates for the past 10 years. i tried to modify your code, but i am able to retrieve only past 9 years of data.

Sahasam..

I have to insert data into the table at the end of each quarter for the past 10 years.

For now i am able to insert data for the past...

Since, i am sharing config files for database. Most of my packages has text files as destination output. Each text will have there own output path, so what is the...

once you modified your package, You have to build the package for the changes to be effected. Then deploy the package.

USE AdventureWorks;

Select EmployeeID, ContactID, Title, HireDate

From HumanResources.Employee

Where HireDate Between '1996-07-31' AND '2003-07-01'

Please read the below Link. You can see many Suggestions.

http://www.sqlservercentral.com/Forums/FindPost930719.aspx

Jeff,

I went through many of the questions you answered, i really like your explanations.

Thanks for simplifying the words in layman terms.

Sahasam..