On what basis would you want to return

'28,0767Caudal18-05-2010 12:12:52'

from the record that is stored as

28,0767Caudal18-05-2010 9:27:52?'

Without explaining exactly what you're trying to do and why, it seems...

I think the interesting thing is the concern about the use of resources. You could use a table variable thinking it would "use fewer resources" but then have your...

I guess it depends on what you mean by being a mess. I find the error handling in T-SQL very underwhelming, but every single example I've seen results in...

ejbatu1,

I know you're new here. Welcome to the community.

First thing, it really helps people to help you if you include your sample data in a quickly usable format such...

I changed the base data a bit to clear out junk, keep it simple and add some records:

CREATE TABLE #table

(A_NO nvarchar(14)

...

jcrawf02 (7/15/2010)

---

Good recap Lynn, that's what I get from the discussion as well.

Can't say as I agree with the OP, I think I would find that very confusing, although...

Open Books Online and look under the entry for 'BULK INSERT statement'. Within that, go down to the section 'KEEPIDENTITY' and you will find all the information you need.

Novicejatt (7/14/2010)

---

My Table Keeps growing. I add new data all the time to it. So if I use IDENTITY(1,1), then eveytime I update my data, I have to first DROP...

I would have a number of concerns about what you're trying to do. If managers can have multiple underlings and multiple managers themselves, you're going to end up with...

This is probably the most amazing thread that I've ever seen on any forum. I have to give the OP a lot of credit. Despite all 11 respondents...

If you're going to do this, read the article by Jeff Moden in the link above.

First, I changed the insert statement a little because there were a few duplicate Id's.

Create...

Danny,

Jeff Moden wrote a great article ... Solving the "Running Total" & "Ordinal Rank" Problems[/url] here on this site. The method he describes will work for what you're wanting...

I assume you mean "dftt" ... Don't Feed The Trolls

I had to look it up when I...

(edit: This is in response to Euguene.)

I think you're being a bit tongue-in-cheek, but still ...

Part of the thing that makes this site such a good resource is the number...

And not sure if you ultimately just want the count of the years which would be:

--actual query

select sq.STRTDATE,

sq.ENDDATE,

COUNT(sq.myYear) as yearCount

from

(

select t.STRTDATE,

t.ENDDATE,

'Y' + CAST(N as varchar) as myYear

from #temp t

join cteTally...