Can you post the complete Create table statement and Insert statements for your tables? Please see the link in my signature for directions.

The reason i ask is im wondering...

Lynn i continue to learn from you. my kludge looks awful compared to the datemath you did. {facepalm} for not realizing i could just add 9 months to...

voiding

cidr (4/23/2012)

---

Hi ColdCoffee, does this help:

Date Fiscal_Year Identifier

30-Mar-11 11-12 ...

i think this get you what you want. being that i guessed your fiscal year column is a char or varchar field it got ugly. if you convert...

im going to let it die at my last comment. yelling at grant insulting Lynn. thats 2,...

those of us who know the threads know you are putting what ever you are trying to...

SQLKnowItAll (4/23/2012)

---

Jeff Moden (4/23/2012)

---

Interesting! Where did you take such a class?...

yep your right, off to modify that code real...

all ready been posted im looking for the thread now.

just upgrading should work after reading the liscense requirements with all I Am Not A Lawyer caveats. however you should back up your master msdb and user databases (Might...

dwain.c (4/22/2012)

---

Brubin,

I believe the following will get you what you want although I played a bit fast and loose with your problem description.

--Create a table to hold the data.

DECLARE @tbl_Data...

GSquared (4/23/2012)

---

Solution is, tell whomever put the data in the table to do it again, but do it right this time. Don't split the data across multiple rows like...

+1 however you could also bulk insert into a staging table and use substring functions to break your data into the correct columns and...

what is the end time you are using to figure out the difference in min. and can you post the DDL and Sample data in a more consumer...