I have edited the function to add the extra columns u asked for and laso add an Input Parameter. If you wnat to get last 3 months from the current...

THis?

IF OBJECT_ID (N'dbo.LastThreeMonths', N'IF') IS NOT NULL

DROP FUNCTION dbo.LastThreeMonths;

GO

CREATE FUNCTION dbo.LastThreeMonths()

RETURNS TABLE

AS

RETURN

WITH CurrentDate AS

(

SELECT ThisMonthFirstDay = DATEADD( MM, DATEDIFF(MM,0,GETDATE()) ,0)

)

, Numbers(N) AS

(

...

Like this?

-- Input variables

DECLARE @StarteDate datetime

DECLARE @EndDate datetime

SET @StarteDate = '1/1/2012'

SET @EndDate = '12/31/2020'

-- local variables and initialization

DECLARE @Diff INT

SELECT @Diff =...

I sense that the last two values are proper/accurate.. do you sense some discrepancy there Lynn?

Instead, you can use DATALENGTH function to get the length, inlcuding white spaces

DECLARE...

I use it mostly to parse out the file names from a long file path. Example:

DECLARE @FilePath VARCHAR(100)

SET @FilePath = 'C:\Users\abcd\AppData\Local\Temp\Temp.txt'

SELECT REVERSE(LEFT ( REVERSE(@FilePath) , CHARINDEX('\',REVERSE(@FilePath))))

Instead of finding the last...

Try

SELECT STUFF ('RA99999-09',3,0,'0')

Will always the first two characters be alphabets ? and will it always be two characters?

wats your expected results based on the sample you provided?

how to identify which states touch wich values?

Hello Iduvall,

I see that my earlier code works for your new data set too. Did you take the latest version?

I initially posted a version and then edited it for bug...

Canazei65 (7/20/2012)

---

Elliott and SSC Crazy - After a bit of a delay, I've implemented Elliott's solution and will be changing a few other Finance views too. This will make reporting...

Where is the question?

Cross post. Please direct your replies here : http://www.sqlservercentral.com/Forums/Topic1332694-392-1.aspx

Did u see my post ? can you give me the data you provided in a readily-usable format?...